Bug#674839: 674839

[Martin Godisch <martin@godisch.de>]

On Mon, May 28, 2012 at 09:31:00 +0200, Mechtilde wrote:

> Is it right you get "#Name?" in the second example as result?
> 
> Then you have to change the decimal separator to "," (comma) for the
> German version. Then you get "0" (zero) as result.

No, I use "," as usual in Germany, I just used "." in the bug report. 
I'm not sure how the example.ods is displayed in other locale's 
environments. Here is, what I exactly do:

A1: -2,4

(which is -2.4 written in German localization and is recognized as a
number and right-aligned automatically)

A2: -500

A3: 502,4

A4: =SUMME(A1:A3)=0

(which is probably =SUM() in an English environment)

The result in A4 is: FALSCH (FALSE).

If I change A4 to =SUMME(A1:A3) the result is -0.

Kind regards,

Martin