I just tested this using the latest versions of 4.1 and 4.2 (and master), and this no longer happens.
To verify, you need to hit F9 after loading the submitted document because the formula results are initially cached. Once the cells get recalculated, the reported problem no longer happens. -- 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: [Upstream] IF function not evaluating correctly with cell borders in .ods Status in LibreOffice Productivity Suite: Confirmed 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/df-libreoffice/+bug/1263326/+attachment/3934242/+files/bug-format-affects-value.ods && localc --nologo bug-format-affects-value.ods is that cells C1 and C2 both show Passed. 4) What happens instead is that cell C2 shows Failed. 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) To manage notifications about this bug go to: https://bugs.launchpad.net/df-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
