steffen, when one only types in a cell 22, with a date format, it show
the 22nd day since the original date. With Excel, one has 01/22/1900.
However, Excel intentionally and incorrectly assumes 1900 is a leap year
as noted in the article "Excel 2000 incorrectly assumes that the year
1900 is a leap year": http://support.microsoft.com/kb/214326
Hence, this is a bug in Excel, not LibreOffice. Feel free to report any
other bugs you may find.
** Changed in: libreoffice (Ubuntu)
Importance: Medium => Undecided
** Changed in: libreoffice (Ubuntu)
Status: Triaged => Invalid
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/456100
Title:
[Upstream] Calc shows wrong date in Excel created .xls
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs