Bug 136470

Summary:	Conditional Formatting not maintained after saving and shutting down spreadsheet
Product:	LibreOffice	Reporter:	Surebrec <surebrec>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal	CC:	buzea.bogdan
Priority:	medium
Version:	7.0.0.3 release
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	113782
Attachments:	Calc V2 working this is your file after I changed what I have done in the video

Description Surebrec 2020-09-04 13:37:10 UTC

Description:
I have created values to include in conditional formatting for temperature cells, and they appear like this:

https://imgur.com/sV0Lchp

But after saving the spreadsheet and closing it down, upon reopening, the above formats are losing their inheritance from the "Celcius" bracket, and are being placed under the "Default Cell Style" bracket.

Furthermore, the cells that I have applied the conditional formatting to, are having the control shifted from the above "T" values to this:

https://imgur.com/BYetsyc

This seems to be screwing with the formatting of the cells in question.

Is this a bug, or am I doing something wrong?

OS: W10
LO: 7.0.0.3
File Format: .xlsx

Actual Results:
The cells that I have applied the conditional formatting to, are having the control shifted from the above "T" values to this:

https://imgur.com/BYetsyc

This seems to be screwing with the formatting of the cells in question.

Expected Results:
I have created values to include in conditional formatting for temperature cells, and they appear like this:

https://imgur.com/sV0Lchp


Reproducible: Always


User Profile Reset: No



Additional Info:
.

Comment 1 BogdanB 2020-09-04 14:31:04 UTC

Could you attach your file if this doesnt contain confidential info?

Comment 2 Surebrec 2020-09-04 14:36:28 UTC

Created attachment 165149 [details]
Calc

Comment 3 BogdanB 2020-09-04 14:49:03 UTC

I dont see any conditional formating applied anywhere. In what sheet and in what cell I can find a conditional formating?...

I confirm that after changing Temp 0 "Inherited" from Default to Accent it is changed, but after close and reopening of the file, it is moved back to Default.

Checked in
Version: 7.0.1.2
Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (ro_RO.UTF-8); UI: en-US
Calc: threaded

Comment 4 Surebrec 2020-09-04 15:39:49 UTC

Created attachment 165150 [details]
V2

Comment 5 Surebrec 2020-09-04 15:40:27 UTC

Sorry, check the version 2 attachment

Comment 6 Surebrec 2020-09-04 15:40:55 UTC

Temp tab, B2:B192

Comment 7 Surebrec 2020-09-05 11:29:59 UTC

Ok, after further testing, I have saved the sheet as .ods and it seems to make the formatting act as it should.

Maybe there's a compatibility issue with .xlsx

Comment 8 BogdanB 2020-09-06 12:27:14 UTC

Created attachment 165195 [details]
working

You can see in my video it worked with xlsx file.
You just need to change styles for each case.

Comment 9 BogdanB 2020-09-06 12:27:56 UTC

Created attachment 165196 [details]
this is your file after I changed what I have done in the video

It is opeining ok on your computer?...

Comment 10 Surebrec 2020-09-06 13:44:20 UTC

(In reply to BogdanB from comment #8)
> Created attachment 165195 [details]
> working
> 
> You can see in my video it worked with xlsx file.
> You just need to change styles for each case.

Yes. I changed them myself, but after saving the file and closing, then reopening, the formatting was lost again.

I have since discovered that it is an issue with .xlsx file format. Saving as .ods doesn't have the same problem.

Comment 11 BogdanB 2020-09-06 13:49:39 UTC

Ok, so maybe it's just on windows.
I can't repro on Linux.

You can see in my video I was working on your own file, I dind't save it as .odf.

I change to unconfirmed (until someone with Windows will confirm it) and I will change to Windows (it seems Windows related).

Comment 12 Surebrec 2020-09-06 15:10:33 UTC

Yes. I saw. Thanks for the help.

Comment 13 BogdanB 2020-09-06 15:33:02 UTC

I want to close this bug.
We have 2 variants:
- in your case anything you save it is not saved - > it's a bug
- in your case now everything it is saved - > it is NOT a bug

Waiting for your variant.
Thank you.

Comment 14 NISZ LibreOffice Team 2021-01-04 09:29:35 UTC

Conditional formatting does not retain the associated styles name when saved to XLSX, this is not a bug, but a consequence of conceptual differences. 
See the reasoning given here:

https://bugs.documentfoundation.org/show_bug.cgi?id=124788#c5