https://bugs.freedesktop.org/show_bug.cgi?id=84436
Priority: medium
Bug ID: 84436
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Spreadsheet SUM workaround
Severity: normal
Classification: Unclassified
OS: Mac OS X (All)
Reporter: watersb...@hawaii.rr.com
Hardware: Other
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
After much frustration I realized that the expression "=SUM(A10,A20,A30)"
doesn't work because the function does not work when referring to lines that
include zero's. The workaround is to shift the input position down so that you
have "=SUM(A11,A21,A31)", etc. This is true for versions 4.3.2.2 and 3.6.6.2
with Mac OSX Maverick.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
