https://bugs.freedesktop.org/show_bug.cgi?id=57661
Priority: medium
Bug ID: 57661
Assignee: [email protected]
Summary: Conditional formatting gets corrupted after deleting
the contents of some cells.
Severity: minor
Classification: Unclassified
OS: Mac OS X (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 3.6.3.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 70748
--> https://bugs.freedesktop.org/attachment.cgi?id=70748&action=edit
Original conditional formatting range
I selected cells A4:I10000 and added conditional formatting as follows:
Condition 1: Formula is ISEVEN(ROW()), background yellow
Condition 2: Formula is ISODD(ROW()), background white
Everything looks fine.
I enter numbers in the cells and all still looks fine.
Now I delete the contents of cells that contain references like
=IF(ISBLANK(B96);"";$O$6) or calculations like
=IF(ISBLANK(B96);"";(B96-E96)*$K$6). The contents of the cells is deleted and
everything still looks fine,
When I save the file and reopen it, the conditional formatting for the deleted
cells is lost and the conditional formatting looks funny. Please see the
attached files.
--
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
