[Libreoffice-bugs] [Bug 138478] CALC: Dynamic conditional colour formatting in autofiltered arrays

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from Colin <that.man.colin at gmail.com> ---
(In reply to Heiko Tietze from comment #6)
> Probably a misconception. Let's take a simple example
> 
> Group	Value
> 1	1
> 1	1
> 1	2
> 2	2
> 2	3
> 2	3
> 
> If you apply the color scale to value 1 becomes green, 2 yellow, and 3 red.
> If you copy the group 1 and apply the same color scale you don't have the
> full range and 2 becomes red.
> 
> Without having read the initial request: doing the calculation based on the
> current filter makes absolutely no sense. A filter is not a subset.

Precisely the substance of the request. The implication is that the boundaries
are set by the original group and it would be nice if there were some mechanism
by which the boundaries could be changed by the selection of a subset to
reflect the new highs & lows extant in the subset.
I think what you're saying is - Not possible/desirable/logical via the
auto-filter/SUBTOTAL() mechanism and that a user would have to copy and paste
special the data and then re-define the conditional colour spectrum for each
and every iteration of paste special.

-- 
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/20210115/19638601/attachment.htm>