incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject DO NOT REPLY [Bug 118999] Leap year not correctly calculated
Date Sun, 04 Mar 2012 05:09:13 GMT

--- Comment #16 from orcmid <> 2012-03-04 05:09:13 UTC ---
Created attachment 77285
Leap Day Smoke Test XLS Smoking in Excel

When the Smoke Test document is saved from Calc as an Excel 97/2000/ME XLS
file, it round trips back into Calc just fine.

When the file is opened in Excel 2010, it opens fine but it exhibits the Excel
"leap-year bug."  This is revealed in how the serial day-number values are
computed differently.  (Note that excel does not present 1899-12-31 for day 0,
it presents 0 day-value numbers as 2000-01-00.)  

This demonstrates that the Excel "leap-year bug" and the problem with dates
being failed to day-value 0 are different situations, although the Smoke Test
is useful in checking for either of them.

Configure bugmail:
------- You are receiving this mail because: -------
You are the assignee for the bug.

View raw message