To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=55040
                  Issue #:|55040
                  Summary:|Possible incorrect number formatting
                Component:|Spreadsheet
                  Version:|680m130
                 Platform:|All
                      URL:|
               OS/Version:|All
                   Status:|UNCONFIRMED
        Status whiteboard:|
                 Keywords:|
               Resolution:|
               Issue type:|DEFECT
                 Priority:|P5
             Subcomponent:|formatting
              Assigned to:|spreadsheet
              Reported by:|dabrown





------- Additional comments from [EMAIL PROTECTED] Sat Sep 24 13:04:32 -0700 
2005 -------
Derek Brown
Ian Hodges
September 24, 2005

Version: 1.9.130
While testing some summations in a spreadsheet insert of Impress, we noticed the
following issue:

Insert 0.001 in cell A1, format to 2 decimal places.
Insert 5 in cell A2.
Insert “=A1+A2” in A3, formatted to 3 decimal places.
The result in A3 is 5.001.  We believe the result should display 5.000 instead.

We are not sure if this is a bug or a design implementation (i.e. should 0.001
be changed to 0.00 internally when formatted to two decimal places or stay the
same internally and be displayed as 0.00).  If the current issue is as you
designed it to be, please close this issue as invalid.  We figured it was best
to report something that may or may not be a bug rather than leave it possibly
unknown.

Thank you for your time.

---------------------------------------------------------------------
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