https://bugs.freedesktop.org/show_bug.cgi?id=44453
Rainer Bielefeld <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW AssignedTo|[email protected] |[email protected] |desktop.org | CC| |LibreOffice@bielefeldundbus | |s.de Ever Confirmed|0 |1 Summary|EDITING: Date will show |FILESAVE FILEOPEN .xls: |different values in MS |EXCEL Leap year bug has to |Office and Libre Office |be mentioned |when year is set to 1900. | Version|LibO 3.3.4 release |LibO 3.3.0 Beta2 --- Comment #1 from Rainer Bielefeld <[email protected]> 2012-01-04 11:02:25 PST --- [Reproducible] with Parallel Dev-Installation of "LibreOffice 3.5.0 Beta2- WIN7 Home Premium (64bit) German UI [Build-ID : 8589e48-760cc4d-f39cf3d-1b2857e-60db978]. References were MS OFFICE 2010, and MS EXCEL Viewer, als Gnumeric May be there is some kind of EXCEL-bug what has to be mentioned for export of particular Numbers? Comparison counting down shows No LibO Date EXCEL date 61 01.03.1900 01.03.1900 62 28.03.1900 29.02.1900 !!!! Excel Counts 1900 as a leap year, but it was not <http://en.wikipedia.org/wiki/Leap_year#Gregorian_calendar> They also have a Saturday, January 0th 1900 in Redmont ;-) Because of this we can't simply leave the "number behind the date" when we export to EXCEL.XLS (and import), but we have to modify numbers in Date formatted fields for import/export within particular date ranges. That also never worked in OOo, so inherited. Gnumeric seems to know the EXCEL bug and does it correct. So this one is more or less a DUP of "Bug 37501 - FILEOPEN Calc shows wrong date in Excel created .xls". But I disagree with decision "NOTOURBUG there. We claim to be able to open and edit EXCEL documents, and so we have to mention EXCEL bugs for the sake of compatibility. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
