To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=48139 Issue #:|48139 Summary:|import "Precision as shown" in OOo 1.1.4 and 680m95 Component:|Spreadsheet Version:|OOo 1.1.4 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|open-import Assigned to:|spreadsheet Reported by:|dannyb
------- Additional comments from [EMAIL PROTECTED] Mon Apr 25 11:42:22 -0700 2005 ------- In Excel 2002 and Excel 2003 there is a setting... Tools --> Options --> Calculation [x] Precision as displayed This corresponds to this setting in OpenOffice.org 1.1.4... Tools --> Options --> Spreadsheet --> Calculate [x] Precision as shown This also corresponds to this setting in OpenOffice.org 2.0 beta... Tools --> Options --> OpenOffice.org Calc --> Calculate [x] Precision as shown The bug... When OOo imports an Excel 2002 worksheet, it should import the Excel "Precision as displayed" checkbox into OOo's "Precision as shown" checkbox. This problem does not seem to occur using Excel 2003. Failure to do so results in the boss saying that OpenOffice.org Calc gives different results than Excel 2002. Example problem 1. In Excel 2002, create new spreadsheet. 2. Set four cells as follows.... C3 = 13778.20 C4 = 120 C5 = C3/C4 C6 = 119*C5 Notice that the four cells display these numbers... C3 = 13778.2 (note lack of trailing zero) C4 = 120 C5 = 114.818333 (Note that this number is a repeating decimal) C6 = 13663.3817 3. Now format column C. Format --> Cells Category: Number, pick -1234.10, check [x] Use 1000 Separator (,), Decimal places to 2. click OK. Now note that the values are displayed as C3 = 13778.20 C4 = 120.00 C5 = 114.82 C6 = 13,663.38 (Note cell C6 IS the correct value ending in ".38" and not ".58".) 4. Tools --> Options --> Calculation check the box: [x] Precision as displayed (Note cell C6 now displays a number ending in ".58", due to rounding of C5.) 5. Save your excel spreadsheet. 6. Now repeat steps 1-5, but using Excel 2003. 7. Open your Excel 2002 spreadsheet in OOo 1.1.4 or OOo 2.0 beta. Note that... In OOo, cell C6 displays 13,663.38 In Excel, cell C6 displayed 13,663.58 (see step 4) Boss says: We can't use this OpenOffice.org stuff because it gives the wrong results! How to fix in OOo 1.1.4? Tools --> Options --> Spreadsheet --> Calculate [x] Precision as shown How to fix in OOo 2.0 beta? Tools --> Options --> OpenOffice.org Calc --> Calculate [x] Precision as shown But if you open the Excel 2003 spreadsheet created in step 6 into OOo 1.1.4 or OOo 2.0 beta, it did seem to correctly import the "Precision as shown" checkbox. --------------------------------------------------------------------- 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]
