To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104378 Issue #|104378 Summary|Missmatch in decimal places when loading xls file Component|Spreadsheet Version|OOO310m9 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|sgreenhow
------- Additional comments from sgreen...@openoffice.org Thu Aug 20 19:42:23 +0000 2009 ------- In the attached file cell A:6 returns the cosine of 5. When viewing under MS Office 2007 the cell value is displayed as 0.283662185, but in OO its 0.28. I know that the option 'OpenOffice.org Calc->Calculate->Decimal Places controls' the number of decimal places that are displayed. It would however be nice if on reading in an MS document that the decimal place settings in that document are honored. Note we are importing documents via an automated process so the appropriateness of the decimal places cannot be assessed. I suspect you'll say its some miss-match between ODF and MS formats, but I'm hoping for the best! --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org