** Description changed: 1) lsb_release -rd Description: Ubuntu Trusty Tahr (development branch) Release: 14.04 2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:4.1.3-0ubuntu2 Candidate: 1:4.1.3-0ubuntu2 Version table: *** 1:4.1.3-0ubuntu2 0 500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages 100 /var/lib/dpkg/status 3) What is expected to happen via a terminal: cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+attachment/3933694/+files/bug.ods && localc --nologo bug.ods is that cells H6 and I6 don't show #VALUE. - 4) What happens instead is it does. However, if you do something which - causes Calc to re-calculate the cells, the value will display fine. For - example if you sort the rows based on the date column. Another trigger - is to re-copy the formulas for D6 and E6 by selecting D5 and E5 and - pulling the formula down. The issue can be reproduced by entering - another line in the checkbook (all the formulas are already entered - through row 1000). Entering the date in A6 causes the formulas to become - live. + 4) What happens instead is it does. This is despite hitting F9 + (Recalculate). + + WORKAROUND: Insert a row, and then remove the row and the expected + values show. + + However, if you do something which causes Calc to re-calculate the + cells, the value will display fine. For example if you sort the rows + based on the date column. Another trigger is to re-copy the formulas for + D6 and E6 by selecting D5 and E5 and pulling the formula down. The issue + can be reproduced by entering another line in the checkbook (all the + formulas are already entered through row 1000). Entering the date in A6 + causes the formulas to become live. ProblemType: Bug DistroRelease: Ubuntu 13.10 Package: libreoffice-calc 1:4.1.3-0ubuntu1 ProcVersionSignature: Ubuntu 3.11.0-14.21-generic 3.11.7 Uname: Linux 3.11.0-14-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 2.12.5-0ubuntu2.2 Architecture: amd64 Date: Sat Dec 21 07:59:29 2013 InstallationDate: Installed on 2012-11-18 (397 days ago) InstallationMedia: Ubuntu 12.10 "Quantal Quetzal" - Release amd64 (20121017.5) MarkForUpload: True ProcEnviron: LANGUAGE=en_US PATH=(custom, no user) XDG_RUNTIME_DIR=<set> LANG=en_US.UTF-8 SHELL=/bin/bash SourcePackage: libreoffice UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago)
-- 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/1263326 Title: Formula values not updated automatically Status in “libreoffice” package in Ubuntu: New Bug description: 1) lsb_release -rd Description: Ubuntu Trusty Tahr (development branch) Release: 14.04 2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:4.1.3-0ubuntu2 Candidate: 1:4.1.3-0ubuntu2 Version table: *** 1:4.1.3-0ubuntu2 0 500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages 100 /var/lib/dpkg/status 3) What is expected to happen via a terminal: cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+attachment/3933694/+files/bug.ods && localc --nologo bug.ods is that cells H6 and I6 don't show #VALUE. 4) What happens instead is it does. This is despite hitting F9 (Recalculate). WORKAROUND: Insert a row, and then remove the row and the expected values show. However, if you do something which causes Calc to re-calculate the cells, the value will display fine. For example if you sort the rows based on the date column. Another trigger is to re-copy the formulas for D6 and E6 by selecting D5 and E5 and pulling the formula down. The issue can be reproduced by entering another line in the checkbook (all the formulas are already entered through row 1000). Entering the date in A6 causes the formulas to become live. ProblemType: Bug DistroRelease: Ubuntu 13.10 Package: libreoffice-calc 1:4.1.3-0ubuntu1 ProcVersionSignature: Ubuntu 3.11.0-14.21-generic 3.11.7 Uname: Linux 3.11.0-14-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 2.12.5-0ubuntu2.2 Architecture: amd64 Date: Sat Dec 21 07:59:29 2013 InstallationDate: Installed on 2012-11-18 (397 days ago) InstallationMedia: Ubuntu 12.10 "Quantal Quetzal" - Release amd64 (20121017.5) MarkForUpload: True ProcEnviron: LANGUAGE=en_US PATH=(custom, no user) XDG_RUNTIME_DIR=<set> LANG=en_US.UTF-8 SHELL=/bin/bash SourcePackage: libreoffice UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
