Issue 114517 - Wrong results in multiplication 0 with negative number
Summary: Wrong results in multiplication 0 with negative number
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOO330m7
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2010-09-15 10:53 UTC by r4zoli
Modified: 2017-05-20 11:33 UTC (History)
7 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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".