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]

Reply via email to