Created attachment 47044 [details]
Downstream bug may be found at:
1) lsb_release -rd
Description: Ubuntu 11.04
2) apt-cache policy libreoffice-calc
*** 1:3.3.2-1ubuntu5 0
500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages
500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages
3) What is expected to happen in LibreOffice Calc via the Terminal:
cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/456100/+attachment/857805/+files/09_1011_h3g_project_report.xls && localc -nologo 09_1011_h3g_project_report.xls
the Excel created file in cell A7 should be /22.
4) What happens instead is it is /21.
Integer 22 is the 21/01/1900.
Entering only the number 22 with a date format show the 22nd day since the origine date.
With Excel, you have 22/01/1900 cause for Excel 1900 is a leap year (false of corse).
It is an Excel bug, not a Calc bug.
So if you enter a date betxeen 1/1/1900 and 1/3/1900 you got a gap of 1 day.
GerardF, thanks for having a look at it. This resolution is confirmed via Microsoft's article "Excel 2000 incorrectly assumes that the year 1900 is a leap year": http://support.microsoft.com/kb/214326
*** Bug 59692 has been marked as a duplicate of this bug. ***
The content of attachment 47044 [details] has been deleted for the following reason:
Remove personal files