Description: Background Colour Malfunction in LibreOffice Calc MALFUNCTION Background colours randomly disappear & reappear, in random cells CAUSE Loading an image to background (Menu-Format-Arrange-To background) whilst using Value Highlighting (Menu-View-Value Highlighting) CONCLUSION Value Highlighting cannot be used if an image is in background Steps to Reproduce: 1. LibreOffice Calc-File-New 2. Select a decent block of cells 3. Click Paint icon arrow-Select a colour 4. Select a cell in the block 5. Menu-Insert-Image (locate and open an image from a directory) 6. Whilst image is selected, Menu-Format-Arrange-To background 7. Scroll to a new section of worksheet, and scroll back The colours should be stable, as expected 8. Activate Menu-View-Value Highlighting 9. Scroll around, as before, to see colours disappearing in random cells (displaying erratic behaviour) Actual Results: Random appearance, and disappearance, of background colours Expected Results: The worksheet should display background colours correctly Reproducible: Always User Profile Reset: No Additional Info: BUG confirmed by 3 independent testers ---------------- Version: 7.2.5.2 (x64) / LibreOffice Community Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: CL ----------------- Version: 7.3.1.3 (x64) / LibreOffice Community Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951 CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: default; VCL: win Locale: en-NZ (en_NZ); UI: en-GB Calc: CL ----------------- LO 7.3.1.3 on Ubuntu 20 ----------------- COMMENT This BUG is bad news for any developer, because: Value Highlighting provides at a glance knowledge of the worksheet and Background Colours provide at a glance knowledge of the worksheet Both would normally be used together. Using images as background may be required, or aesthetically pleasing. As a background, values can be written over the images (very useful). Background images, background colours, and value highlighting should be capable of working together.
Created attachment 179186 [details] ods file: BUG- Background colour fail when graphic sent to background AND Value Highlighting switched on This is a simple ods worksheet. Some cells have a background colour. Some cells have a background image. To recreate the bug, simply scroll around with Value Highlighting ON and OFF. The background colours become unstable with Value Highlighting ON.
Repro Version: 7.2.6.2 (x64) / LibreOffice Community Build ID: b0ec3a565991f7569a5a7f5d24fed7f52653d754 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: default; VCL: win Locale: es-ES (es_ES); UI: en-US; Calc: CL, also with Skia enable. Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community Build ID: b000d964fcc8849d10576bf3539bde7729db2eb1 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: default; VCL: win Locale: es-ES (es_ES); UI: en-US;Calc: threaded
Thanks m.a.riosv for taking a look at this bug. What are your thoughts on it's priority? I ask out of interest rather than desperation. I can live without value highlighting, though it is obviously better to have it. It's a useful tool :)
(In reply to David Smith from comment #3) > What are your thoughts on it's priority? As a rule of thumb, prioritization is done along the following flowchart: https://wiki.documentfoundation.org/File:Prioritizing_Bugs_Flowchart.jpg