https://bugs.documentfoundation.org/show_bug.cgi?id=91385
Bug ID: 91385
Summary: Conditional formats based on volatile functions are
not updated when document is recalculated with
F9/shift-F9
Product: LibreOffice
Version: 4.4.2.2 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 115707
--> https://bugs.documentfoundation.org/attachment.cgi?id=115707&action=edit
testcase
I've got a spreadsheet containing dates with conditional formats based on how
late or early these dates are, conditions like 'cell value is greater than
now()'. Unfortunately there is no way to force the update of conditional
formatting: F9 and shift-F9 have no effect, only after a cell of the
spreadsheet - any cell, even the one not involved in conditional formatting, is
actually modified formats finally change. I find it quite awkward and would
like calc to update conditional formats based on volatile functions when F9 is
pressed the same way the data based on volatile functions is updated.
I am attaching a simple testcase wich doesn't require waiting for a certain
time. Orange background is applied to cell A1 if its value (0.5) is greater
than rand(). Start modifying other cells randomly - orange background starts
changing on and off. Now start pressing F9 or shift-F9: nothing happens.
--
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
