[Libreoffice-bugs] [Bug 136621] CALC INDIRECT() Function does not work correctly if local function separator for formulae is defined

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |INVALID
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #2 from Eike Rathke <erack at redhat.com> ---
0. the Swedish currency symbol certainly is not ':' colon but 'kr' for Svensk
krona instead.

If the function parameter separator is ';' semicolon then the formula
=SUM(D1;INDIRECT(C1))
returns the sum of two individual arguments, namely D1 and the reference
returned by the call to INDIRECT(C1).

In the formula
=SUM(D1:INDIRECT(C1))
the ':' colon is the range operator so the range passed to sum is the result of
D1 as one corner and the second corner is the reference returned by the call to
INDIRECT(C1). So if C1 contains "D7" the resulting range is D1:D7 passed to
SUM().

There is no bug and not an esoteric issue, the function parameter separator is
not misbehaving and there is no malfunction. It is simply that you were not
aware of the syntax.

-- 
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/20200909/c457a15f/attachment.htm>