https://bugs.freedesktop.org/show_bug.cgi?id=61172
Priority: medium
Bug ID: 61172
Assignee: [email protected]
Summary: TABLE: Weird formula syntax to calculate the sum of
non-adjacent cells
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 3.6.4.3 release
Component: Writer
Product: LibreOffice
I tried to calculate the total sum of the two cell ranges C2 to C16 and G2 to
G16.
The formula I used was
= sum(<C2:C16>)+sum(<G2:G16>)
it resulted in an error message:
** Fehlerhafter Ausdruck ** (erroneous expression?)
When i try the weird (and possibly undocumented) syntax
= sum(<C2:C16>+<G2:G16>)
the calculation works.
When i try the Microsoft-Word-like
= sum(<C2:C16>;<G2:G16>)
the result is zero! No error message is being shown.
Operating System: Ubuntu
Version: 3.6.4.3 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
