[sc-issues] [Bug 118342] New: Irregular rounding displays where rounding is not in effect

http://openoffice.org/bugzilla/show_bug.cgi?id=118342

        Issue Type: DEFECT
           Summary: Irregular rounding displays where rounding is not in
                    effect
    Classification: Application
           Product: Spreadsheet
           Version: OOo 3.3
          Platform: PC
        OS/Version: Windows XP
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: P3
         Component: editing
        AssignedTo: [email protected]
        ReportedBy: [email protected]
         QAContact: [email protected]


Created an attachment (id=76729)
 --> (http://openoffice.org/bugzilla/attachment.cgi?id=76729)
single sheet, 18 row demonstration of the problem

Simple formulas including addition and subtraction of near whole integers
(exceptions only down to 2 decimal places) and yet the sheet displays 'nth
decimal point E values for a number that SHOULD be Zero.  (eg, a formula
equating to 97.29+33.92-131.21 = -5.6843418860808E-013  )

As demonstrated in the attached sheet.

I regularly find myself modifying cells to include a ROUND() function to
overcome this irregularity on many sheets as I come across them.  But this
should not be necessary.

Problem does NOT apply in OOO v3.1.

-- 
Configure bugmail: http://openoffice.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.

---------------------------------------------------------------------
Please do not reply to this automatically generated notification
from Bugzilla. Please log into the website and enter your comments.
---------------------------------------------------------------------
-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help