https://issues.apache.org/ooo/show_bug.cgi?id=122856
Bug ID: 122856
Issue Type: DEFECT
Summary: Conditional formatting references wrong cells
Product: Calc
Version: AOO 4.0.0
Hardware: PC
OS: Windows 7
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: formatting
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Created attachment 81168
--> https://issues.apache.org/ooo/attachment.cgi?id=81168&action=edit
Test file
After upgrading to 4.0.0, and opened a file I'd been working in previous
versions it appears that my conditional formatting broken. All the rules were
there, but they were all referencing the wrong cells. I went in and changed
everything back to the way it should have been, saved the file and closed. When
I opened the file back up again, everything was back referencing the wrong
cells again. No matter how many times I update and save, it always goes back to
being wrecked.
I reinstalled and opened the file in 3.4.1, and everything was referencing the
correct cells.
Here are a couple examples of the same cells in 3.4.1 (how they should be) and
4.0.0 (wrecked)
3.4.1 - Cell A1997
COUNTIF($Sheet2.$A$1:$A$75;$Sheet1.A1997)>0
IF(VLOOKUP($Sheet1.A1997;$Sheet2.$H$2:$I$44;2;0)<>$Sheet1.I1997;TRUE())
3.4.1 - Cell D1997
SUM($Sheet1.B1997:C1997)<>$Sheet1.D1997
----
4.0.0 - Cell A1997
COUNTIF($Sheet2.$A$1:$A$75;$Sheet1.A300)>0
IF(VLOOKUP($Sheet1.A300;$Sheet2.$H$2:$I$44;2;0)<>$Sheet1.I300;TRUE())
4.0.0 - Cell D1997
SUM($Sheet1.IU300:IV300)<>$Sheet1.A300
I have also uninstalled and reinstalled 4.0 a couple times, and it always does
the same thing.
I have attached a small test file created from the file I have been working on.
The conditional formatting is located in cells A, D, and I.
I should also not that this only appears to happen with the .xls extension. If
I re-save the file as .ods in 3.4.1, the problem does not occur in 4.0.0.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
