[Libreoffice-bugs] [Bug 126250] New: make function returning values or reference capable of returning values or reference

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=126250

            Bug ID: 126250
           Summary: make function returning values or reference capable of
                    returning values or reference
           Product: LibreOffice
           Version: 6.1.6.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: freta at gmx.fr

A1=33

I think that all function capable to return a value (33) corresponding to a
reference (A1) should be capable to directly return the reference (A1).
I think that all function capable to return a reference (A1) corresponding to a
value (33) should be capable to directly return the associated value (33).

note : functions are in french
There is plenty of function and some times we are interested by the value,
other times by the reference. I think there is no reason that EQUIV cannot
return value or RECHERCHEV cannot return reference. It make things complicated,
and Calc is ever very complicated. (I'm not able to compare with Excel.)


I propose to add or change the syntax by :
- to get a value : always write « FUNCTION »
I think this is the more common case.

- to get a reference : always write « &FUNCTION »


I know that this should broke plenty of files. But I recently beginning writing
a little bit complicated Calc, and it is a pain. The problem of reference is
not the one : there is a lot of things that are hard to do or understand. And I
am a programmer! Retrospectively, I think, because I am the only user of my
Calc file, that it should be simpler to rewrite it on SQL with views and
procedures.
And my file is not so complicated. I think the tool make things difficult.
I am sorry to write this: I know that the actual Calc have needed a huge work.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190706/a0975859/attachment-0001.html>