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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 138478
           Summary: CALC: Dynamic conditional colour formatting in
                    autofiltered arrays
           Product: LibreOffice
           Version: 7.0.3.1 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: that.man.colin at gmail.com

The function [SUBTOTAL] will provide the defined analysis - sum, min, max, avg,
etc., for the displayed cells from within an autofiltered array.
If the component cells are also subject to Format > Conditional > Colour Scale
then prior to the auto filtering, the colour rendition is graduated across the
entire range of the cell values.
Following auto filtering, the colour rendition does not change so the
likelyhood is that all the cells will be varying hues of the same colour if
multiple instances of a similar event are filtered.
I feel it would be appropriate for the user to be in a position to define that
the colour scale should re-define itself to represent the low, middle & high
values of the resulting display, thereby more clearly highlighting the cell
value extremes.
Perhaps a radio button either with the colour scale definition or the
[SUBTOTAL] function which is defaulted to static evaluation. That is to say -
the user MUST choose a dynamic colour rendition.
I'm not sure if eXcel has a similar facility but obviously, importing and
exporting are a major consideration if Dynamic Colour Scaling proves to be
unique to LO.
Note: [SUBTOTAL] obviously provides values for min, max, etc., but there's
still a significant effort required to "scan" a list of potentially similar
values to identify those most closely matching the defined SUBTOTAL

-- 
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/20201125/4eeda1bf/attachment-0001.htm>