Issue 96182

Summary: incosistent precision for numeric and date values
Product: Calc Reporter: andreschnabel <andre.schnabel>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, weigel
Version: OOo 3.0Keywords: ms_interoperability
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
simple testcase
none
test case to compare with Excel none

Description andreschnabel 2008-11-13 13:53:49 UTC 
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.
Comment 1 andreschnabel 2008-11-13 13:57:05 UTC 
Created attachment 57966 [details]
simple testcase
Comment 2 andreschnabel 2008-11-13 14:01:22 UTC 
Created attachment 57967 [details]
test case to compare with Excel