Bug 139369 - UI Inconsistent screen refresh for conditional Data Bar formatting depending on sort criteria and data values
Summary: UI Inconsistent screen refresh for conditional Data Bar formatting depending ...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
 
Reported: 2021-01-02 12:54 UTC by Colin
Modified: 2023-08-28 06:44 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample file to demonstrate the anomaly (18.24 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-01-02 12:54 UTC, Colin
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Colin 2021-01-02 12:54:02 UTC
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
Comment 1 Colin 2021-01-02 12:54:56 UTC
Created attachment 168633 [details]
Sample file to demonstrate the anomaly
Comment 2 m_a_riosv 2021-01-03 00:26:59 UTC
Reproducible with or without Skia enable.
Version: 7.0.5.0.0+ (x64)
Build ID: e29387a749edb1bf39ca2b558099964da42b3a4b
CPU threads: 4; OS: Windows 10.0 Build 20180; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); Interfaz: es-ES Calc: CL

Version: 7.2.0.0.alpha0+ (x64)
Build ID: 4e3ce9dd6ace0b22f7b3f45cf2338b201f4dc305
CPU threads: 4; OS: Windows 10.0 Build 20180; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL

Regression since 
Version: 6.4.7.2 (x64)
Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU threads: 4; OS: Windows 10.0 Build 20180; UI render: default; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US Calc: CL
Comment 3 Buovjaga 2021-08-26 14:27:48 UTC
(In reply to m.a.riosv from comment #2)
> Regression since 
> Version: 6.4.7.2 (x64)
> Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
> CPU threads: 4; OS: Windows 10.0 Build 20180; UI render: default; VCL: win; 
> Locale: es-ES (es_ES); UI-Language: en-US Calc: CL

Not my result. I repro in oldest of Linux 6.4, 6.3, 50max, 41max, 43all repos. To be clear, the bad result is that all of the rows show a horizontal split instead of the groups of three, when you use the vertical scrollbar.
Comment 4 QA Administrators 2023-08-27 03:05:39 UTC Comment hidden (obsolete)
Comment 5 Colin 2023-08-27 06:20:10 UTC
Version: 7.4.7.2 (x64) / LibreOffice Community
Build ID: 723314e595e8007d3cf785c16538505a1c878ca5
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded
Comment 6 QA Administrators 2023-08-28 03:05:33 UTC Comment hidden (obsolete)
Comment 7 Colin 2023-08-28 04:41:37 UTC
(In reply to QA Administrators from comment #6)
>
>  
> If the bug is NOT present, please set the bug's Status field to
> RESOLVED-WORKSFORME and leave a comment that includes the information from
> Help - About LibreOffice.
> 
Did that - See comment 5

Version: 7.4.7.2 (x64) / LibreOffice Community
Build ID: 723314e595e8007d3cf785c16538505a1c878ca5
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded
Comment 8 Buovjaga 2023-08-28 06:44:58 UTC
(In reply to Colin from comment #7)
> (In reply to QA Administrators from comment #6)
> >
> >  
> > If the bug is NOT present, please set the bug's Status field to
> > RESOLVED-WORKSFORME and leave a comment that includes the information from
> > Help - About LibreOffice.
> > 
> Did that - See comment 5

Apologies again for the misbehaving automated machinery :(