[Libreoffice-bugs] [Bug 139369] New: UI Inconsistent screen refresh for conditional Data Bar formatting depending on sort criteria and data values

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139369
           Summary: UI Inconsistent screen refresh for conditional Data
                    Bar formatting depending on sort criteria and data
                    values
           Product: LibreOffice
           Version: 7.0.3.1 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:
Attached is a sample spreadsheet demonstrating the presentation anomaly.
A simple conditional "Data Bar" format has been created for the range C2:C31
The min value has intentionally been set to -10 to facilitate further testing
and ensure bars are visible for the lower values.
Columns B&C have Auto Filter
The screen is split at B2 - The anomaly is not affected by the removal of the
screen split as the same impact is observed when the split is removed and the
sheet "scrolled" under the visible column headers
The impact also appears to be linked to mouse control settings defining how
many rows are scrolled for the scroll wheel. I have only experimented with
"low" numbers <=6
As can be seen, the data in column C is three clusters 1-10
the data in column B is a simple line ID to ensure column C can be "reset"

Steps to Reproduce:
1 To ensure a consistent basic presentation CTRL+SHFT+F9
2 Observe that the formatting is "compartmentalised" for each number
3 Using the "side bar" scroll the data up under the screen split until it
disappears
4 Using the "side bar" scroll the data back into view
5 Observe the formatting now appears to be random

Repeat 1-5 but using the mouse scroll wheel
Note: the "remedial" effect is also observed if the screen is "mouse scrolled"
whilst the "random" formatting is evident from the "side bar" scroll test

6 To ensure a consistent basic presentation CTRL+SHFT+F9
7 Autosort column B "Ascending"
8 Observe that the formatting is now "compartmentalised" for each cell

Note: side bar and mouse scroll have no effect upon the presentation when
"like" numbers are no longer sorted together

9 Leaving the ascending sort on Column B change C2 to -10
10 Drag down to increment to -1
11 To ensure a consistent basic presentation CTRL+SHFT+F9
12 Observe that the "compatmentalising" changes for the sequential single and
double number sets
13 Autosort Column A ascending
14 Scroll up & Down (either method) and observe the "compartmentalisation"
15 CTRL+SHFT+F9

Feel free to experiment with permutations of numbers and sorting criterea.

Of significant interest is the fact that sorting ascending on B produces one
pattern of "compartmentalisation" on the numerical groups and sorting
descending produces another.

Also, sorting in either direction immediately after a "corruption" event has
the same effect as CTRL+SHFT+F9

Actual Results:
Inconsistent screen refresh

Expected Results:
Consistent screen refresh - But I am unsure what should be considered as
consistent as it is difficult to find information concerning expectations and
there are no settings to define any anticipated expectations


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Module: SpreadsheetDocument
Version: 7.0.3.1 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
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/20210102/3b2585af/attachment-0001.htm>