[Libreoffice-bugs] [Bug 144549] New: Filter by Color does not work for colors, which are set by number format

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Sep 16 14:29:14 UTC 2021


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

            Bug ID: 144549
           Summary: Filter by Color does not work for colors, which are
                    set by number format
           Product: LibreOffice
           Version: 7.3.0.0 alpha0+ Master
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: rb.henschel at t-online.de

Created attachment 175075
  --> https://bugs.documentfoundation.org/attachment.cgi?id=175075&action=edit
Example of Color in number format

It is possible now to filter on colors. However, that covers only text color
and background color. But it is possible to set colors in number-format. That
is in the predefined number formats done for negative numbers. But you can
define number-formats with other colors and other ranges too. Such example is
attached.

Number-formats with colors can be used for the y-axis in charts too.

To include colors from number-format in a filter is important for exchange with
Google Tables. That application considers colors set by number-format the same
as colors set by text format.

-- 
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/20210916/f42bc528/attachment.htm>


More information about the Libreoffice-bugs mailing list