Issue 114517

Summary:	Wrong results in multiplication 0 with negative number
Product:	Calc	Reporter:	r4zoli <r4zoli>
Component:	code	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues, kami911, kyoshida, oliver.brinzing, ooo-build, rb.henschel, timar74
Version:	OOO330m7	Keywords:	oooqa
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description r4zoli 2010-09-15 10:53:27 UTC

Open empty spreadsheet in OOO330m7, insert into B2 cell =SUM(B3:B123)*-1 
the results will be -0, which is wrong.

If you make it in vanilla OOo 3.2.1 it will show correct result.
If you open in go-oo source 3.2.1 will show -0, in go-oo 3.2.0 show correct result.

It seems to me it is a regression.

Comment 1 timar74 2010-09-15 11:36:09 UTC

confirmed

Comment 2 Oliver Brinzing 2010-09-15 17:33:14 UTC

Comment 3 Regina Henschel 2010-09-15 18:39:24 UTC

go_oo specific. Please have a look.

Comment 4 Regina Henschel 2010-09-15 18:44:35 UTC

Not a bug in vanilla OOo.

Comment 5 Regina Henschel 2010-09-15 18:45:27 UTC

Has to be handled in go-oo.

Comment 6 r4zoli 2010-09-15 19:31:42 UTC

No 
It is a vanilla bug, but first showed in go-oo in 3.2.1,
and after OOO330m3 this is the oldest which I tested reincarnated in vanilla build. 

This issue is true in DEV300m87, at least on win version.

Comment 7 Regina Henschel 2010-09-15 21:02:15 UTC

OK, I see it too in DEV300m87 on WinXP. I had tested DEV300m86 and there was no
bug. The error remains, if the area is not empty but filled with zero.

Comment 8 Joe Smith 2010-09-15 21:39:09 UTC

Testing OOO330_m7 on Fedora Linux 13, en_US

Any of these show as "-0":

=SUM(A3:A123)*-1	
=-1*0	
=-0	
plain number, entered as “-0”

All show as "0" in 3.2.1.

Only for default format (Number/General); specific number format, including
"General", shows as "0".

Compares as equal to "0".

Comment 9 ooo 2010-09-21 17:50:24 UTC

@kohei: I suspect this was introduced with the dynamic decimals, it occurs with
the 'General' format, but not with, for example, '0'.

Comment 10 Marcus 2017-05-20 11:33:45 UTC

Reset assigne to the default "issues@openoffice.apache.org".