Ray DeCampo, thank you for reporting this bug and helping make Ubuntu better.
The root problem of this bug is in your attachment's cell H6 where you subtract a cell with a number (H5) from cell D6 containing text: "" The rest of the inconsistent behavior is collateral damage from poor propagation of #VALUE to the other cells utilizing this result. To WORKAROUND this problem, you would want to change all values of "" to the number zero. Given this, this bug report will focus on the root cause, improper propagation of #VALUE. Hence, the issue you are reporting is an upstream one. It would be nice if somebody having it could send the bug to the developers of the software by following the instructions verbatim at http://wiki.documentfoundation.org/BugReport . If you have done so, please tell us the number of the upstream bug (or the link), so we can add a bugwatch that will inform us about the status. Thanks in advance. Helpful bug reporting tips: https://help.ubuntu.com/community/ReportingBugs ** 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. 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. + WORKAROUND: Change all values of: + "" + + to the number zero: + 0 + 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) ** 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. + is that cell H6 shows #VALUE no matter what, given it is a result of + subtracting text from a number. - 4) What happens instead is it does. This is despite hitting F9 - (Recalculate). + 4) What happens instead is if one inserts a row, and then removes the + row, it resolves to a number value. - 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. - - WORKAROUND: Change all values of: + WORKAROUND: Change all formulas containing: "" to the number zero: 0 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) ** Summary changed: - Formula values not updated automatically + #VALUE doesn't propagate correctly subtracting text from numbers ** Changed in: libreoffice (Ubuntu) Importance: Undecided => Low ** Changed in: libreoffice (Ubuntu) Status: New => Triaged ** Tags added: trusty -- 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: #VALUE doesn't propagate correctly subtracting text from numbers Status in “libreoffice” package in Ubuntu: Triaged 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 cell H6 shows #VALUE no matter what, given it is a result of subtracting text from a number. 4) What happens instead is if one inserts a row, and then removes the row, it resolves to a number value. WORKAROUND: Change all formulas containing: "" to the number zero: 0 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
