https://bugs.freedesktop.org/show_bug.cgi?id=84927
--- Comment #2 from Llogic <[email protected]> --- Hi Jacques, thanks for replying. 1. I've downloaded the file that I've previously uploaded and tried what you've suggested. Direct link (https://bugs.freedesktop.org/attachment.cgi?id=107731) Action: ======= Copy format using paintbrush as you've suggested. Result: ======= Yes, the range is formated properly. Save the file. Problem: ======== Re-open the file and found that the formatting is lost. Observation: ============ Reference Screnshot http://postimg.org/image/e5rtwaen7/ Noticed that after using the paintbrush for formatting, the conditional formatting is visually correct. However, select (example shown here, cell K23) and verify the conditional formatting criteria, it is not there. Therefore when you save and reopen, the formatting is lost. 2. Testing with actual use case - daily update - For actual usage, data are added daily so the conditional formatting have to be done daily - Also the conditional formatting for each row (of the same column) may be different. Just like copying of value and formulas, can the copying of conditional formatting be done as a whole column ? Action: ======= Using the same file that I've previously uploaded, copy conditional formatting from C2 to C2:C31 Conditional formatting is okay visually for C2:C31 Select column C and copy format using paintbrush. Paste format to column D. Result: ======= The conditional formatting is copied over to column D but not properly done. The above information for your review. Llogic -- 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
