https://bugs.freedesktop.org/show_bug.cgi?id=74278
Priority: medium
Bug ID: 74278
Assignee: [email protected]
Summary: Calc: Conditional Formatting fails to update when
condition changes, scrolling updates display
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 3.5.7.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 93140
--> https://bugs.freedesktop.org/attachment.cgi?id=93140&action=edit
Spreadsheet displaying behavior error
In the attached spreadsheet, a group of cells has conditional formatting set.
The condition is based upon a comparison of two values. When one of those
values changes, the cells should change formatting, but do not. However if I
scroll the displayable area off (down or sideways) screen, and then scroll
back, the conditional formatting is correct.
Specifically, the spreadsheet tracks auto maintenance. Cell C1 contains
current mileage. Cells B7-B59 contain an increasing series of mileages. The
conditional formatting statement is:
IF($Regular.$B8<=$Regular.$C$1,TRUE(),FALSE())
When the comparison is true, the cells become gray, indicating those mileage
ranges have already been passed.
Now if I change the value in C1, nothing displayed changes. But if I scroll to
a blank area of the spreadsheet and then scroll back to the data, the
formatting is now displayed correctly.
I am running LibreOffice 3.5.7.2 on Ubuntu 12.04.
--
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
