https://bugs.freedesktop.org/show_bug.cgi?id=43691
Bug #: 43691
Summary: Different interpretation of empty space ("") in case
of formulas sum(A1;C1) and A1+B1+C1
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.0 Beta0
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: libreoffice-bugs@lists.freedesktop.org
ReportedBy: andis.lazd...@gmail.com
Created attachment 54289
--> https://bugs.freedesktop.org/attachment.cgi?id=54289
Excample of error
In file in attachment those two formulas
=IF(A1+B1+C1+D1+E1=0;"";A1+B1+C1+D1+E1) and =IF(SUM(A1:E1)=0;"";SUM(A1:E1))
provides different results. The first ends with error value if at least one
cell in the list contains value of empty space (""). Formula with sum() works
fine. First formula works fine if the cells in the list do not contain any
values at all.
This bug do not affect 3.3.4; however, as far as I can remember it affected at
least some versions of 3.4 branch.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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
