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

Reply via email to