https://bugs.documentfoundation.org/show_bug.cgi?id=136621
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |INVALID
Status|UNCONFIRMED |RESOLVED
--- Comment #2 from Eike Rathke <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
