[Libreoffice-bugs] [Bug 134684] Conditional Colour Formatting in CALC becomes inconsistent as table columns are deleted

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134684

--- Comment #2 from Colin <that.man.colin at gmail.com> ---
I am aware that the conditional formatting is "hierarchical" and the latest
conditional formatting will take precedence over any pre-existing cell
formatting. However, the manner in which it is implemented can sometimes be
confusing/inconsistent/undesirable.

If a small column of data is conditionally formatted to the default 3 colour
scheme it produces a single entry into the "register" of conditional
formatting.
If the last cell is dragged to fill and increment then the conditional
formatting is also dragged to encompass the new range.

If the user anticipates extending the data and pre-formats a much greater range
by simply managing the existing formatting register then the formatting is as
would be expected. However, if a selection of the data is itself cut & pasted
into the newly extended array it creates a new formatting schedule with the
three colour range covering only the copied data.

I would observe that if the selection were pasted to an unformatted array area
then whilst that may not be the desired format, the irregularity would remind
the user that the conditional formatting range needs extending BUT, if the
selection is cut & pasted to a pre-existing range then the users' desire is
probably to maintain a consistent format across the entire range. Possibly
another instance where a radio button is required to permit the users to
indicate their preferences.

Special pasting with only the cell values works without damaging the
conditional format - but only when special pasting functions as planned. There
are a number of exisitng reports defining how it is not working to the users'
satisfaction.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201112/b88cc26b/attachment.htm>