[This is an automated message.] There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix
If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already. Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination. -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/715701 Title: spreadsheet date fields load wrong date Status in “libreoffice” package in Ubuntu: Incomplete Status in “openoffice.org” package in Ubuntu: Won't Fix Bug description: Binary package hint: openoffice.org I've got a ods file with plain date fields I've created two years ago and since then updated regulary except for the last year. However, when I now open this file, all dates are about four years off or so, though the date in content.xml is still correct. I can reproduce this with the following test.ods: Whenever I create a ods file with just one date field containing a valid date, the content.xml contains <office:body> <office:spreadsheet> <table:calculation-settings table:case-sensitive="false" table:automatic-find-labels="false" table:use-regular-expressions="false"> <table:null-date table:date-value="1904-01-01"/> </table:calculation-settings> <table:table table:name="Sheet1" table:style-name="ta1" table:print="false"> <table:table-column table:style-name="co1" table:default-cell-style-name="ce1"/> <table:table-row table:style-name="ro1"> <table:table-cell office:value-type="date" office:date-value="2011-02-01"> <text:p>01.02.11</text:p> </table:table-cell> </table:table-row> </table:table> </office:spreadsheet> </office:body> The file I created some time ago is lacking table:calculation-settings tag. <office:body> <office:spreadsheet> <table:table table:name="Sheet1" table:style-name="ta1" table:print="false"> <table:table-column table:style-name="co1" table:default-cell-style-name="ce1"/> <table:table-row table:style-name="ro1"> <table:table-cell office:value-type="date" office:date-value="2011-02-01"> <text:p>01.02.11</text:p> </table:table-cell> </table:table-row> </table:table> </office:spreadsheet> </office:body> Though the code still contains 2011-02-01, soffice displays 31.01.07 (meaning 31 Jan 2007). The error observed with the old file can be reproduced by removing the tag from the test.ods and the old file can be fixed by adding this tag to the file. I don't know if the tag is required by the standard but as the old ods file was only written by different versions of openoffice, i would expect openoffice to handle this. Further, it is not obvious to me why someone would want a stored 2011 to mean 2007. ProblemType: Bug DistroRelease: Ubuntu 10.04 Package: openoffice.org-calc 1:3.2.0-7ubuntu4.2 ProcVersionSignature: Ubuntu 2.6.32-27.49-generic-pae 2.6.32.26+drm33.12 Uname: Linux 2.6.32-27-generic-pae i686 Architecture: i386 Date: Wed Feb 9 12:05:01 2011 ProcEnviron: LANGUAGE=de_DE:de:en_GB:en PATH=(custom, user) LANG=de_DE.UTF-8 SHELL=/bin/bash SourcePackage: openoffice.org To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/715701/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
