[Upstream] IF function not evaluating correctly with cell borders in .ods
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Fix Released
|
Medium
|
|||
libreoffice (Ubuntu) |
Fix Released
|
Medium
|
Unassigned |
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://
100 /var/lib/
3) What is expected to happen via a terminal:
cd ~/Desktop && wget https:/
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
ProcVersionSign
Uname: Linux 3.11.0-14-generic x86_64
NonfreeKernelMo
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_
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago)
description: | updated |
description: | updated |
description: | updated |
description: | updated |
description: | updated |
summary: |
- Formula values not updated automatically + #VALUE doesn't propagate correctly subtracting text from numbers |
Changed in libreoffice (Ubuntu): | |
importance: | Undecided → Low |
status: | New → Triaged |
tags: | added: trusty |
summary: |
- #VALUE doesn't propagate correctly subtracting text from numbers + #VALUE propagates incorrectly subtracting text from numbers |
summary: |
- #VALUE propagates incorrectly subtracting text from numbers + IF function not evaluating correctly with cell borders in .ods |
description: | updated |
Changed in libreoffice (Ubuntu): | |
importance: | Low → Medium |
summary: |
- IF function not evaluating correctly with cell borders in .ods + [Upstream] IF function not evaluating correctly with cell borders in + .ods |
Changed in df-libreoffice: | |
importance: | Unknown → Medium |
status: | Unknown → Confirmed |
description: | updated |
Changed in df-libreoffice: | |
importance: | Unknown → Medium |
status: | Unknown → Fix Released |
Christopher, the calculation in H6 of H5-D6 is protected by the IF() function, ensuring that we do not use H5-D6 when D6 is "". In fact, the cell has the proper value when other things are changed that should not affect this bug. As I stated in my original description, this includes ordering the rows by date or re-copying the formulas in D6 and E6 to themselves. This proves that the formula in H6 is fine. Furthermore the formula for H4 and H5 are the same as H6 except for the row numbers and as you can see there is no #VALUE issue with those cells. This behavior is new, I have been using this spreadsheet since 2001 in OpenOffice/ LibreOffice and never had this issue.