melchiaros, please answer the following questions: + When one performs the desired transform what date are you expecting it to be? + Why are you expecting this date to be what you said it should be?
** Description changed: - I am on Ubuntu12.10 Quantal 64bit. + 1) lsb_release -rd + Description: Ubuntu 12.04 LTS + Release: 12.04 - On a spreadsheet with some date informations before 1904 (1899 are the - first ones) I have performed a date transform with setting the default - date + 2) apt-cache policy libreoffice-calc + libreoffice-calc: + Installed: 1:3.5.3-0ubuntu1 + Candidate: 1:3.5.3-0ubuntu1 + Version table: + *** 1:3.5.3-0ubuntu1 0 + 500 http://us.archive.ubuntu.com/ubuntu/ precise-updates/main i386 Packages + 100 /var/lib/dpkg/status + 1:3.5.2-2ubuntu1 0 + 500 http://us.archive.ubuntu.com/ubuntu/ precise/main i386 Packages - Tools-> Options... -> Libre Office Calc -> Calculate -> Date -> - 12/30/1899(default) + What is expected to happen in Calc via the Terminal: + cd ~/Desktop && wget -c https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1005488/+attachment/3166791/+files/02.1_Datum_00.xlsx -O example.xlsx && localc --nologo example.xlsx - to + is when one changes: + Tools-> Options... -> Libre Office Calc -> Calculate -> Date -> 12/30/1899(default) - Tools-> Options... -> Libre Office Calc -> Calculate -> Date -> - 1/1/1904 + to: + Tools-> Options... -> Libre Office Calc -> Calculate -> Date -> 1/1/1904 - and pressing o.k + sheet Datumsbereich cell A5 changes from 1899-12-29 to <INSERT + EXPECTATION DATE HERE>. + 4) What happens instead is it transformed to 1903-12-31. - The transform make a mistake and set the date from 1899-12-29 - not to 1904-01-01 + Before screenshot + https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1005488/+attachment/3166789/+files/libreoffice_date.png + . - - Instead it is transformed to 1903-12-31. - - - I attach the sreenshots of the original spreadsheet, the transformed spreadsheet and the spreadsheet itself. - - The affected date is in the upper right corner(first raw - last colum). + After screenshot + https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1005488/+attachment/3166790/+files/libreoffice%20date%202.png + . ProblemType: Bug DistroRelease: Ubuntu 12.10 Package: libreoffice-core 1:3.5.3-0ubuntu1 ProcVersionSignature: Ubuntu 3.4.0-3.8-generic 3.4.0 Uname: Linux 3.4.0-3-generic x86_64 ApportVersion: 2.1-0ubuntu1 Architecture: amd64 Date: Mon May 28 12:26:46 2012 ExecutablePath: /usr/lib/libreoffice/program/soffice.bin InstallationMedia: Ubuntu 12.10 "Quantal Quetzal" - Alpha amd64 (20120510) ProcEnviron: - PATH=(custom, no username) - LANG=en_US.UTF-8 - SHELL=/bin/bash + PATH=(custom, no username) + LANG=en_US.UTF-8 + SHELL=/bin/bash SourcePackage: libreoffice UpgradeStatus: No upgrade log present (probably fresh install) XsessionErrors: - gnome-session[1866]: WARNING: Session 'ubuntu' runnable check failed: Exited with code 1 - gnome-session[1866]: WARNING: Could not launch application 'gdu-notification-daemon.desktop': Unable to start application: Failed to execute child process "/usr/lib/gnome-disk-utility/gdu-notification-daemon" (No such file or directory) + gnome-session[1866]: WARNING: Session 'ubuntu' runnable check failed: Exited with code 1 + gnome-session[1866]: WARNING: Could not launch application 'gdu-notification-daemon.desktop': Unable to start application: Failed to execute child process "/usr/lib/gnome-disk-utility/gdu-notification-daemon" (No such file or directory) ** Changed in: libreoffice (Ubuntu) Status: New => Incomplete -- 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/1005488 Title: libreoffice calc 3.5.3 wrong date transform Status in “libreoffice” package in Ubuntu: Incomplete Bug description: 1) lsb_release -rd Description: Ubuntu 12.04 LTS Release: 12.04 2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.5.3-0ubuntu1 Candidate: 1:3.5.3-0ubuntu1 Version table: *** 1:3.5.3-0ubuntu1 0 500 http://us.archive.ubuntu.com/ubuntu/ precise-updates/main i386 Packages 100 /var/lib/dpkg/status 1:3.5.2-2ubuntu1 0 500 http://us.archive.ubuntu.com/ubuntu/ precise/main i386 Packages What is expected to happen in Calc via the Terminal: cd ~/Desktop && wget -c https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1005488/+attachment/3166791/+files/02.1_Datum_00.xlsx -O example.xlsx && localc --nologo example.xlsx is when one changes: Tools-> Options... -> Libre Office Calc -> Calculate -> Date -> 12/30/1899(default) to: Tools-> Options... -> Libre Office Calc -> Calculate -> Date -> 1/1/1904 sheet Datumsbereich cell A5 changes from 1899-12-29 to <INSERT EXPECTATION DATE HERE>. 4) What happens instead is it transformed to 1903-12-31. Before screenshot https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1005488/+attachment/3166789/+files/libreoffice_date.png . After screenshot https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1005488/+attachment/3166790/+files/libreoffice%20date%202.png . ProblemType: Bug DistroRelease: Ubuntu 12.10 Package: libreoffice-core 1:3.5.3-0ubuntu1 ProcVersionSignature: Ubuntu 3.4.0-3.8-generic 3.4.0 Uname: Linux 3.4.0-3-generic x86_64 ApportVersion: 2.1-0ubuntu1 Architecture: amd64 Date: Mon May 28 12:26:46 2012 ExecutablePath: /usr/lib/libreoffice/program/soffice.bin InstallationMedia: Ubuntu 12.10 "Quantal Quetzal" - Alpha amd64 (20120510) ProcEnviron: PATH=(custom, no username) LANG=en_US.UTF-8 SHELL=/bin/bash SourcePackage: libreoffice UpgradeStatus: No upgrade log present (probably fresh install) XsessionErrors: gnome-session[1866]: WARNING: Session 'ubuntu' runnable check failed: Exited with code 1 gnome-session[1866]: WARNING: Could not launch application 'gdu-notification-daemon.desktop': Unable to start application: Failed to execute child process "/usr/lib/gnome-disk-utility/gdu-notification-daemon" (No such file or directory) To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1005488/+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
