** Description changed:
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.
+ 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
+ PATH=(custom, no user)
+ LANG=en_US.UTF-8
+ SHELL=/bin/bash
SourcePackage: openoffice.org
Uname: Linux 2.6.28-15-generic i686
** Changed in: libreoffice (Ubuntu)
Importance: Undecided => Medium
** Changed in: libreoffice (Ubuntu)
Status: New => Triaged
** Summary changed:
- date wrong in excel file
+ Calc shows wrong date in Excel created .xls
** Tags added: lo33
** Description changed:
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
+ 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
+ apt-cache policy gnumeric
+ gnumeric:
+ Installed: 1.10.13-1ubuntu1
+ Candidate: 1.10.13-1ubuntu1
Version table:
- *** 1:3.3.2-1ubuntu5 0
- 500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386
Packages
+ *** 1.10.13-1ubuntu1 0
+ 500 http://us.archive.ubuntu.com/ubuntu/ natty/universe 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
--
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:
Calc shows wrong date in Excel created .xls
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
