Description: After I've set up conditional formatting for a group of cells, the style randomly changes when I delete contents of some of the cells and resort the selection (data/sort). The area is 6 columns x 20 or so rows and I'm setting the style changes cell color depending on values. I'll then go back into 'manage conditional formatting' and reset all of the styles. As soon as I delete some contents, add others, and resort, the styles are again randomly reset. Steps to Reproduce: 1.create a table with header row with various values in 4 columns and 10 rows. 2.apply conditional formatting to the cells (if value <x, then whatever style) 3.delete contents of a few of the rows 4. resort the table and the style of various conditions will randomly reset to something else Actual Results: style in various conditions resets to random value other that what was there before Expected Results: conditional formatting for selected cell range (entire columns) should not change when resorting Reproducible: Sometimes User Profile Reset: No Additional Info: I can upload example sheet if that helps
Created attachment 176361 [details] table with conditional formatting that changes when data is deleted and table resorted this is the sheet that resets conditional formatting style when rows are resorted after deletion of data and new data added
cannot reproduce with Version: 7.3.0.0.alpha1+ / LibreOffice Community Build ID: fcad2503ede92b515076f9bb3162855dcc2c575d CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded open your file; deleted content of row 4 and 5; write new content; Sort. Can you attach screencast or provide exact steps?
I made an error in my description. The randomly changing of styles occurs after I save and reopen the sheet. 1. setup conditional formatting for entire columns 2. sort table 3. edit some cells, or delete 4. resort table 5. save new sheet (all still well at this point) 6. reopen sheet: all conditional formatting remains as was EXCEPT styles assigned to various conditions have randomly changed. I'll try to get some representative screen shots to illustrate. thanks
(In reply to kalakai from comment #3) > I made an error in my description. The randomly changing of styles occurs > after I save and reopen the sheet. > > 1. setup conditional formatting for entire columns > 2. sort table > 3. edit some cells, or delete > 4. resort table > 5. save new sheet (all still well at this point) > 6. reopen sheet: all conditional formatting remains as was EXCEPT styles > assigned to various conditions have randomly changed. > > I'll try to get some representative screen shots to illustrate. > > thanks I tried with your steps, but there was no problem. Maybe the bug has disappeared? If not, attach screenshots. Set to NEEDINFO. Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away. Arch Linux 64-bit Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 67eb60672936a10fba840078e6aca918c3331f52 CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 21 November 2022
Thanks for testing. Let's set to worksforme as we don't know the exact fix.