https://bugs.freedesktop.org/show_bug.cgi?id=46153
Bug #: 46153
Summary: EDITING, FORMATTING: SUM() function behave differently
than Sum operator
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.0 Release
Platform: All
OS/Version: All
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
SUM() function behave differently than Sum operator.
1) write in cellA1=1
2) write in cellA2=2
3) write in cellA3=SUM(A1:A2), got results 3
4) write in cellA4=A1+A2, got results 3
5) modify cellA1 to '-', '/', ' ' or '\' (not a number)
in cellA3 the value become 2 as expected
in cellA4 the value become #VALUE!
Note: with OpenOffice 3.3.0 the value in cellA4 become 2 as expected,
this generate an incompatibility to existent .ods electronic sheet,
as #VALUE! propagate to next formulas
--
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
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
