Bug 46153 - EDITING, FORMATTING: SUM() function behave differently than Sum operator
Summary: EDITING, FORMATTING: SUM() function behave differently than Sum operator
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.0 release
Hardware: All All
: medium major
Assignee: Not Assigned
Keywords: regression
Depends on:
Reported: 2012-02-16 02:33 UTC by Valerio Messina
Modified: 2012-02-26 02:16 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Valerio Messina 2012-02-16 02:33:48 UTC
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
Comment 1 wope 2012-02-25 11:54:36 UTC
It is the same behavior as in MS Office. It was changed in LibO 3.4.0
Comment 2 Valerio Messina 2012-02-26 02:16:40 UTC
the bug is about compatibility with previous .ods calc sheet and opensource applications. All previous native .ods file that use this behavior require fixes for this LO modifications