To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=106358
                 Issue #|106358
                 Summary|Round-Off Error According to Cell Formatting
               Component|Spreadsheet
                 Version|OOO310m9
                Platform|PC
                     URL|
              OS/Version|Linux
                  Status|UNCONFIRMED
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|code
             Assigned to|spreadsheet
             Reported by|mathuhenry





------- Additional comments from [email protected] Tue Oct 27 16:02:31 
+0000 2009 -------
Observed in 3.1.1 OOO310m19 Build:9420 - Ubuntu 9.04

Enter data into two cells: example
A1=1,45
A2=1,33
assign cell as the sum of these two cells
A3=A1+A2
it will show 2,78
Format A1 and A2 to show only 1 decimal place so they show:
A1=1,5
A2=1,3
A3 will now show 2,80 even though the value should be 2,78.

I just checked with 2.4.2 and this is not an issue in the older release.

My system information is: Dell Inspiron 1525
Ubuntu 9.04 Kernel 2.6.28-11
GNOME 2.26.1
Dual Intel Processor T5850 @ 2.16GHz

---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to