https://bugs.documentfoundation.org/show_bug.cgi?id=101250
m.a.riosv <miguelange...@libreoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |miguelangelrv@libreoffice.o
| |rg
Resolution|--- |NOTABUG
--- Comment #1 from m.a.riosv <miguelange...@libreoffice.org> ---
it's not possible use the semicolon in that way, because as such you are not
doing a valid range. Semicolon it is used to separate parameters, function like
SUM() accepts several ranges as parameters, but there is a limit of 30.
https://help.libreoffice.org/Calc/Operators_in_Calc#Reference_operators
To join ranges the character to use is the tilde ~
eg:
$Sheet1.$A$1:$A$6~$Sheet1.$C$1:$C$6
You need to verify that it works properly with your formulas, it works fine
with SUM($Sheet1.$A$1:$A$6~$Sheet1.$C$1:$C$6)
but eg not with
SUMPRODUCT($Sheet1.$A$1:$A$6~$Sheet1.$C$1:$C$6).
Resolved as not a bug, please if you are not agree reopen it.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs