Description: When trying to change the color of all the cells in my spreadsheet, selecting all and then applying the change doesn't work as expected: the change is applied in a subset of the spreadsheet. Steps to Reproduce: 1. Open the test file (or create one yourself). You'll see some columns and rows painted in yellow. Let's say you want to remove the yellow color from the spreadsheet: 3. Select all (either by "Edit->Select All" or by clicking on the top-left corner of the spreadsheet 4. Remove colors (i.e. apply a "No fill" to the cell background properties) Actual Results: The yellow color is not removed. Expected Results: Any color in the spreadsheet should disappear. Reproducible: Always User Profile Reset: Yes Additional Info: The action (in this case, apply a "no fill" background) seems to be applied to the populated cells only. For example if you want to change the color of all the spreadsheet, following the 2 steps above will change only the color of the table, not the entire spreadsheet. So the problem seems to be either in the "select all" (that doesn't really select all cells but all populated cells) or in the application of the action (in this case, change background). Version: 7.6.4.1 (X86_64) / LibreOffice Community Build ID: 60(Build:1) CPU threads: 24; OS: Linux 6.5; UI render: default; VCL: qt5 (cairo+xcb) Locale: en-US (en_US.UTF-8); UI: en-US Ubuntu package version: 4:7.6.4-0ubuntu0.22.04.1~lo1 Calc: threaded
Created attachment 192467 [details] Try to remove the yellow color by using "Select all"
This issue has been fixed in master (however I could not find the original ticket) It happens because the formatted cells are beyond the area with data in your sheet. It's definitely a bug and has been fixed, but the fix has not been backported. Maybe the fix should be backported to the 7.6 branch. Tested with Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 34dd150f76a375944ff2bd22dd8535b0fd03b2d5 CPU threads: 16; OS: Linux 6.5; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Calc: CL threaded
*** This bug has been marked as a duplicate of bug 153527 ***