Activity log for bug #456100

Date Who What changed Old value New value Message
2009-10-20 07:57:21 steffen bug added bug
2009-10-20 07:57:21 steffen attachment added 09_1011_h3g_project_report.xls http://launchpadlibrarian.net/34023204/09_1011_h3g_project_report.xls
2009-10-20 07:57:21 steffen attachment added Dependencies.txt http://launchpadlibrarian.net/34023205/Dependencies.txt
2009-10-22 01:20:31 Chris Cheney openoffice.org (Ubuntu): status New Incomplete
2010-05-13 22:27:19 Chris Cheney tags apport-bug i386 apport-bug i386 jaunty
2010-05-17 16:02:07 Chris Cheney openoffice.org (Ubuntu): importance Undecided Medium
2010-05-17 16:02:07 Chris Cheney openoffice.org (Ubuntu): status Incomplete Triaged
2010-05-17 16:02:49 Chris Cheney summary calculation error [upstream] date wrong in excel file
2010-05-17 16:02:58 Chris Cheney bug task added openoffice
2011-05-23 13:07:11 penalvch summary [upstream] date wrong in excel file date wrong in excel file
2011-05-23 13:10:30 penalvch bug task added libreoffice (Ubuntu)
2011-05-23 13:15:42 penalvch description Binary package hint: openoffice.org In my attached sheet please have a look e. g. to field A7. If I open it with Microsoft, there is calculated the 22th. If I open this document with OO, there is a 21th calculated. I work only with OO under Linux and got this sheet from my company to fill it out. 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 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 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 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
2011-05-23 13:15:56 penalvch libreoffice (Ubuntu): importance Undecided Medium
2011-05-23 13:15:56 penalvch libreoffice (Ubuntu): status New Triaged
2011-05-23 13:16:59 penalvch summary date wrong in excel file Calc shows wrong date in Excel created .xls
2011-05-23 13:17:47 penalvch tags apport-bug i386 jaunty apport-bug i386 jaunty lo33
2011-05-23 13:21:50 penalvch 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 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 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 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
2011-05-23 13:48:58 penalvch bug watch added http://bugs.freedesktop.org/show_bug.cgi?id=37501
2011-05-23 13:48:58 penalvch bug task added df-libreoffice
2011-05-23 13:49:22 penalvch summary Calc shows wrong date in Excel created .xls [Upstream] Calc shows wrong date in Excel created .xls
2011-05-23 17:33:15 Bug Watch Updater df-libreoffice: status Unknown Confirmed
2011-05-23 17:33:15 Bug Watch Updater df-libreoffice: importance Unknown Low
2011-05-24 17:20:52 penalvch libreoffice (Ubuntu): importance Medium Undecided
2011-05-24 17:20:52 penalvch libreoffice (Ubuntu): status Triaged Invalid
2011-05-24 17:47:12 Bug Watch Updater df-libreoffice: status Confirmed Won't Fix
2011-06-06 05:54:42 penalvch openoffice: status New Invalid
2011-06-06 05:55:05 penalvch openoffice.org (Ubuntu): importance Medium Undecided
2011-06-06 05:55:05 penalvch openoffice.org (Ubuntu): status Triaged Invalid