https://bugs.documentfoundation.org/show_bug.cgi?id=104026
Bug ID: 104026
Summary: Conditional formatting is not updated when deleting a
row
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: p_kongs...@op.pl
Created attachment 128858
--> https://bugs.documentfoundation.org/attachment.cgi?id=128858&action=edit
Conditional formatting error.
In a spreadsheet where conditional formatting is used to compare column A with
column B and to show a background color in case of 'not equal to'.
What happens:
When deleting a row with conditional formatting, the row moved up in place of
the deleted row is not updated correctly. The conditional formatting shows for
this row that 'not equal to' and the background color is shown. Then you need
to format from either the upper or lower part the spreadsheet to have the
correct result.
Expected:
That the conditional formatting is working as on the remaining rows. And no
needs to copy the formatting.
1. Create a new spreadsheet with the same value in column A + B. I have used
numbers.
2. Then from menu Format/Conditional/Condition Formatting in cell A1 you ask
for comparison 'Cell Value is' 'Not equal to' B1. 'Apply Style' you chose new
style. Here you open tab 'Background' and select a color.
3. Clone the formatting using the icon with the brush in A1 and apply this to
your rows in column A. Now all cells in column A should have no background
color.
4. If you try to change a value in column B the corresponding cell in column
should change background color. Change the value back so it equals the row
value in A.
5. Delete a row. Now your row replacing the deleted row will have a background
color. It should not. It will disappear if you clone formatting from the
remaining rows.
Attached is a simple spreadsheet to show the bug
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs