Issue 96182 - incosistent precision for numeric and date values
Summary: incosistent precision for numeric and date values
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: ms_interoperability
Depends on:
Blocks:
 
Reported: 2008-11-13 13:53 UTC by andreschnabel
Modified: 2013-01-29 21:47 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
simple testcase (8.57 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-11-13 13:57 UTC, andreschnabel 		no flags Details
test case to compare with Excel (45.00 KB, application/vnd.ms-excel)
2008-11-13 14:01 UTC, andreschnabel 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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