** Summary changed: - #VALUE doesn't propagate correctly subtracting text from numbers + #VALUE propagates incorrectly subtracting text from numbers
** Also affects: df-libreoffice via https://www.libreoffice.org/bugzilla/show_bug.cgi?id=72969 Importance: Unknown Status: Unknown ** Summary changed: - #VALUE propagates incorrectly subtracting text from numbers + IF function not evaluating correctly with cell borders in .ods ** 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 + cd ~/Desktop && wget https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+attachment/3934242/+files/bug-format-affects-value.ods && localc --nologo bug.ods - is that cell H6 shows the expected value of $4081.03. + is that cells C1 and C2 both show Passed. - 4) What happens instead is it shows #VALUE. + 4) What happens instead is that cell C2 shows Failed. - WORKAROUND: if one inserts a row, and then removes the row, it shows the - expected $4081.03. - - WORKAROUND: Change all formulas containing: - "" - - to the number zero: - 0 + WORKAROUND: Insert a row, and then remove the row. 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) ** Changed in: libreoffice (Ubuntu) Importance: Low => Medium -- 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: IF function not evaluating correctly with cell borders in .ods To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs