https://bugs.documentfoundation.org/show_bug.cgi?id=92811
Bug ID: 92811
Summary: FILEOPEN: Reopening spreadsheet changes test value in
conditional formatting rule
Product: LibreOffice
Version: 4.4.4.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 117310
--> https://bugs.documentfoundation.org/attachment.cgi?id=117310&action=edit
Test value for conditional formatting rule shifted down two rows after saving
and reopening
I created a conditional formatting rule applying to $G3:$G1048576. The test
value was $H3. The rule worked correctly during the session in which it was
created. However, when the file was saved and reopened, the rule's test value
had shifted down two rows to $H5. (While I was able to edit the corrupted rule
in Manage Conditional Formatting, I was unable to save the correction, as
Manage Conditional Formatting's OK button is nonfunctional. A separate report
has been filed for that bug.)
Subsequent saves and reopens do not seem to shift the test value any further.
In the attached spreadsheet, entries in the column "$ Calc" (Calculated Price,
Column G) are supposed to turn red (via the ErrorInDataEntry style) if "$ Calc"
is not equal to "$ Paid," indicating that there has been a data-entry error in
the "Gal" (Gallons Purchased, Column E), "$PG" (Price in Dollars Per Gallon,
Column F), or the "$ Paid" (Price Actually Paid, Column H) columns. I
originally specified a test value of "$H3" for the specified range, which is
$G3:$G1048576. The rule functioned correctly during the session in which I
created it. However, saving and reopening the spreadsheet caused the test value
to change from "$H3" to $H5", causing all entries in G to turn red.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
