https://bugs.freedesktop.org/show_bug.cgi?id=61137
Priority: medium
Bug ID: 61137
Assignee: [email protected]
Summary: FORMATTING: Changing conditional formatting on a range
of cells does not change all cells
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 3.6.5.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 75132
--> https://bugs.freedesktop.org/attachment.cgi?id=75132&action=edit
Sample sheet to illustrate problems with conditional formatting
When a range of cells is selected and the conditional formatting dialog opened,
and the formatting of that range of cells is adjusted, only some of the cells
are actually changed. It appears that only the first conditional formatting set
is adjusted, and the formatting is not applied to the other cells in the range.
In the sample spreadsheet, select the range U4 to U12, then open the
conditional formatting dialog. Adjust some of the values in the formatting, and
then close the dialog with OK. You'll see that the formatting was not applied
to cells without formatting, nor was it applied to the cell U11 (which has the
same formatting as cell U4).
Trying to remove the formatting works the same way; only the first formatting
is adjusted, everything else is left as it was.
In 3.5, changing the formatting this way applied the change to all of the cells
in the entire selected range (which is how I'd expect it to work).
This makes it impossible to correct missing formatting like that caused by bug
#61136. Especially as one cannot see which cells have conditional formatting
applied. I could have made the conditional formatting visible by adding a third
style to color all of the text, but - ahem - I can't change the formatting in
all of the cells because of this bug. "There's a hole in the bucket..." :-)
(One could find the appropriate ranges in the "Manage" box, delete them [since
the ranges cannot be modified in this box - why is that?], and then manually
reapply the formatting to a selection. Even as a long-time programmer, I find
that distasteful - nothing seems to work as one would expect.)
--
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
