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: .
Could you attach your file if this doesnt contain confidential info?
Created attachment 165149 [details] Calc
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
Created attachment 165150 [details] V2
Sorry, check the version 2 attachment
Temp tab, B2:B192
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
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.
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?...
(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.
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).
Yes. I saw. Thanks for the help.
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.
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