[Libreoffice-bugs] [Bug 140855] New: Calc Row conditional colour formatting corrupted by column sort with alternate conditional colour format

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 140855
           Summary: Calc Row conditional colour formatting corrupted by
                    column sort with alternate conditional colour format
           Product: LibreOffice
           Version: 7.0.4.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: that.man.colin at gmail.com

Description:
Colour rendition of a filtered array with a conditional colour sort assigned to
MOST of the cells in each row is corrupted when sorted on a column that has an
alternate colour sort assigned to the column.
Sample Calc file and .png example attached.

Steps to Reproduce:
1. From the sample calc attached which is sorted on column [A] - the original
natural data entry condition, observe the three colour sort applied to Cells
C2:F10 together with the three colour sort applied to Cells O2:P10.
2. Sort on either column [O] or [P] and observe the corruption of colour scheme
for C2:F10
Columns [Q:AC] are irrelevant to the conditional colour format and [AE:AH] only
affect the identification of the "latest" column containing non-zero values

Actual Results:
Colour scheme of C2:F10 becomes corrupted - no longer reflecting the original
Correct/Anticipated colour scheme for each row. O2:P10 is Correct/Anticipated.
See attached .png.

Expected Results:
Colour scheme for each row of C2:F10 should remain unchanged from the unsorted
condition as the data rows have not changed value - just location.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 7.0.4.2 (x64)
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded

-- 
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/20210307/02548239/attachment.htm>