** 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 Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: Formula values not updated automatically To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
