[Bug 456100] Re: [Upstream] Calc shows wrong date in Excel created .xls
Launchpad has imported 3 comments from the remote bug at https://bugs.freedesktop.org/show_bug.cgi?id=37501. If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. On 2011-05-23T13:47:30+00:00 Christopher M. Penalver wrote: Created attachment 47044 09_1011_h3g_project_report.xls Downstream bug may be found at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/456100 1) lsb_release -rd Description: Ubuntu 11.04 Release: 11.04 2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.3.2-1ubuntu5 Candidate: 1:3.3.2-1ubuntu5 Version table: *** 1:3.3.2-1ubuntu5 0 500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages 100 /var/lib/dpkg/status 1:3.3.2-1ubuntu4 0 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. Reply at: https://bugs.launchpad.net/df- libreoffice/+bug/456100/comments/5 On 2011-05-23T20:47:11+00:00 Gerard-fargeot wrote: 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. Reply at: https://bugs.launchpad.net/df- libreoffice/+bug/456100/comments/6 On 2011-05-24T16:34:28+00:00 Christopher M. Penalver wrote: 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 Reply at: https://bugs.launchpad.net/df- libreoffice/+bug/456100/comments/7 -- 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 To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/456100/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 456100] Re: [Upstream] Calc shows wrong date in Excel created .xls
** Changed in: openoffice Status: New = Invalid ** Changed in: openoffice.org (Ubuntu) Importance: Medium = Undecided ** Changed in: openoffice.org (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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 456100] Re: [Upstream] Calc shows wrong date in Excel created .xls
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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 456100] Re: [Upstream] Calc shows wrong date in Excel created .xls
** Changed in: df-libreoffice Status: Confirmed = Won't Fix -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 456100] Re: [Upstream] Calc shows wrong date in Excel created .xls
** Changed in: df-libreoffice Status: Unknown = Confirmed ** Changed in: df-libreoffice Importance: Unknown = Low -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs