does calc now recognize the difference between nothing and anything?
in the attachment line 1 adding empty a + empty b results in 0 (case anything)
in the attachment line 2 adding empty a + empty b results in an error (case nothing)
the format for all cells ist the same.
in line 1 a and b are "virgin".
in line 2 a and b were purged by using the space-bar.
Created attachment 49925 [details]
Example for the reported bug
seems to be a dup of
Formula returns #VALUE in 3.4RC2 but works as expected in 3.3
But an space not is an empty cell.
This is reproducible on LibreOffice 3.4 340m1(Build:103), but I do not think it is a problem because like mariosv said, a space is not an empty cell, and also if you remove the spaces, LO SUM functions as expected.
try to think/feel like a simple user of a chartprogram.
in his point of view there is no difference between a cell with space(s) and a cell without anything. both type of cells have a numeric format and are added.
the result of adding two "empty" cells should be zero and not "value". thats the behavior the user expects.
have you ever tested this case with another chartprog?
To my think/feel this is the right way.
What is the meaning of space, empty or zero?.
Could be with a simple A1+B1 no problem, but what happen with for example AVERAGE(A1:B1) or COUNT(A1:B1)
or in a chart representation, is a zero o without data.
The better is avoid any misinterpretation.
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
I tested on 3.5.0beta2. (A cell with a space in it) + 1 = #VALUE! At first I did not like this because in OpenOffice (A cell with a space in it) + 1 = 1. Then I had an OpenOffice user using the space bar to clear out cell data. This looks ok in OpenOffice however when saved as an XLS sheet and sent to an excel user it appears as #VALUE!. So the excel user thinks that OOo has a bug in it. Now with LO behaving the same as excel I think that is better. An LO user would have seen the #VALUE! just like an excel user. This provides better compatibility between LO/excel. I think this bug should be marked INVALID.
*** This bug has been marked as a duplicate of bug 37860 ***