** Description changed: - I am planning on attaching an example spreadsheet which demonstrates the - issue. The example spreadsheet is a checkbook where the account is - split into three categories. Then there is a 'Total' category which is - the sum of the transactions in the other categories. The idea is to - have virtual subaccounts in the checkbook. When you open the example - you will see that cells H6 and I6 are not being calculated and display - #VALUE instead. 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. + 1) lsb_release -rd + Description: Ubuntu Trusty Tahr (development branch) + Release: 14.04 - There is a further issue with this spreadsheet in column F. Column F is - an indicator that the bank has reflected the transaction to facilitate - balancing the checkbook. You will notice that F4 and F5 contain the - string 'x ', that is 'x' followed by two spaces. Unfortunately I have - only entered 'x' into these cells. Every time the spreadsheet is saved, - closed and re-opened another space is appended to these cells. I - haven't been successful re-producing this phenomena in another - spreadsheet and I am not sure if it is related to the issue above. + 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 - These issues appeared with the upgrade from 13.04 to 13.10. + 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 it doesn'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. 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 + 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)
** 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 + 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 it doesn't show #VALUE. + 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. 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
