desktop-packages team mailing list archive

[Launchpad Bug Tracker <715701@xxxxxxxxxxxxxxxxxx>]

[Expired for libreoffice (Ubuntu) because there has been no activity for
60 days.]

** Changed in: libreoffice (Ubuntu)
       Status: Incomplete => Expired

-- 
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:
  Expired
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