To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96182 Issue #|96182 Summary|incosistent precision for numeric and date values Component|Spreadsheet Version|OOo 3.0 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|andreschnabel
------- Additional comments from [EMAIL PROTECTED] Thu Nov 13 13:53:49 +0000 2008 ------- for very small deviations in values, values that are formatted as number and values formatted as date seems to be threaded different. e.g. 39766 - 1E-11 is displayed as 39766,00000000000000000000 (numeric format, 20 decimal places) but 2008-11-13 (date formatted) Date value for 39766 is 2008-11-14 As Excel is more consistent in this case, spreadsheets behave different in calc and Excel. --------------------------------------------------------------------- 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]
