Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Formatting accuracy problem of numbers exceeding decimal digits' representation precision. | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | kacubuntu <jameboy> | ||||
Component: | formatting | Assignee: | AOO issues mailing list <issues> | ||||
Status: | CONFIRMED --- | QA Contact: | |||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | issues | ||||
Version: | OOo 3.2 | ||||||
Target Milestone: | --- | ||||||
Hardware: | PC | ||||||
OS: | Linux, all | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
kacubuntu
2011-02-10 16:59:53 UTC
Created attachment 75810 [details]
strqange calc bug
This is a formatting accuracy problem. The numbers added actually give not the same result as what is displayed, can be easily verified by manually calculating the sum. If the SUM(...) result is copied to clipboard and then pasted special (as number without formula) to the manual entry the difference is displayed as zero even if the visual representation of the copied value doesn't change. The summation is in fact quite accurate, yet is rounded by the spreadsheets requirement for 15 significant figures, which i understand is due to floating point numbers. The error is not remedied by cutting and pasting without formulas as advised. If the following test is run, one will find that similar calculations on either side (i.e 2^60 to 69 and sam for 80-89 ) are not concerned by such 'formatting' errors. Further checks indicate that this problem occurs in Vista as well as Ubuntu. If one checks the value of the figure, it suggests as you point out that this may be the correct figure which indicates for this value (and maybe others) restrictions of FPU normally seen with such equipment is excelled. Reset assigne to the default "issues@openoffice.apache.org". |