https://bugs.freedesktop.org/show_bug.cgi?id=60306
--- Comment #22 from Petr Mladek <[email protected]> --- I tested the patch from comment #20 (remove the copied cond format cell attr entries) It helped to show the green border around the cell "I28" but it did not really work. I did the following test: 1. I followed instructions from the comment #0 Result: Green border around the cell "I28" which looks promissing 2. Changed the data in the cell "T28" from "March 2012" to "March 2010" Result: It still shown the green border. Expected result: It should remove the green border and show red strike over the "I28" cell because the condition is not longer true Alternative test is to copy rows 65 and 66 from the source.ods. The result is that both "I28" and "I29" cells have the green border. The expect result is the red strike over the "I29" cell. Observation: It helped me to safe the "SampleTarget.ods" document as "SampleTarget.new.ods" and reload. This helped also without the patch in the comment #20. => It seems that the problem is rather in refreshing or recalculating the formatting. Observation 2: If I had the patch from the comment #20, it helped me to do: - open "Format/Conditional Formatting/Manage" - select the range "I28:I29" - press "Edit" - press "OK" to close the edit window (no change is needed) - press "OK" to close the manage window Result: The cell "I29" become the red strike as expected This does not help without the patch in comment #20 => the patch in the comment #20 actually makes a difference. -- 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
