desktop-packages team mailing list archive

[Bug Watch Updater <456100@xxxxxxxxxxxxxxxxxx>]

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 Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/456100

Title:
  [Upstream] Calc shows wrong date in Excel created .xls

Status in LibreOffice Productivity Suite:
  Won't Fix
Status in The OpenOffice.org Suite:
  Invalid
Status in “libreoffice” package in Ubuntu:
  Invalid
Status in “openoffice.org” package in Ubuntu:
  Invalid

Bug description:
  Binary package hint: openoffice.org

  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.

  WORKAROUND: Use Gnumeric.

  lsb_release -rd
  Description:	Ubuntu 11.04
  Release:	11.04

  apt-cache policy gnumeric
  gnumeric:
    Installed: 1.10.13-1ubuntu1
    Candidate: 1.10.13-1ubuntu1
    Version table:
   *** 1.10.13-1ubuntu1 0
          500 http://us.archive.ubuntu.com/ubuntu/ natty/universe i386 Packages
          100 /var/lib/dpkg/status

  ProblemType: Bug
  Architecture: i386
  DistroRelease: Ubuntu 9.04
  Package: openoffice.org-core 1:3.0.1-9ubuntu3.1
  ProcEnviron:
   PATH=(custom, no user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: openoffice.org
  Uname: Linux 2.6.28-15-generic i686

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/456100/+subscriptions