Bug 145777

Summary:	'conditional formatting' randomly resets 'style' when resorting
Product:	LibreOffice	Reporter:	kalakai <lkghebert>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	ilmari.lauhakangas, raal
Priority:	medium
Version:	7.2.2.2 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	table with conditional formatting that changes when data is deleted and table resorted

Description kalakai 2021-11-19 13:27:49 UTC

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

Comment 1 kalakai 2021-11-19 13:40:18 UTC

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

Comment 2 raal 2021-11-21 16:10:03 UTC

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?

Comment 3 kalakai 2021-11-22 21:15:28 UTC

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

Comment 4 Buovjaga 2022-11-21 15:55:54 UTC

(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

Comment 5 Buovjaga 2022-11-21 17:30:00 UTC

Thanks for testing. Let's set to worksforme as we don't know the exact fix.