LibreOffice strips all conditional formatting from a document if saved into the XLS format. For triage, this bug began occurring in LO 5, and does not occur in LO Portable
Steps to Reproduce:
1. Create a LO spreadsheet with some conditional formatting
Format - Conditional Formatting - Manage
2. Save spreadsheet as XLS (test.xls)
3. Close window (Ctrl W) or Close application (Alt-F4)
4. Open spreadsheet (test.xls)
5. Go to Format - Conditional Formatting - Manage
6. -_- No conditional formatting
Document opens, no conditional formatting is executed
Opening conditional formatting has no elements in it.
Document opens and executes conditional formatting.
Opening conditional formatting should conditional formatting elements in it.
User Profile Reset: Yes
Well, keep conditional formatting, for one :)
Cross platform bug. Tested broken on Win 10 64-bit and Ubuntu 17.10 64 bit.
LibreOffice Portable 220.127.116.11 is the last known working version that produces CF in XLS documents. I hope that helps you triage this bug.
OpenGL is NOT enabled
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0
Can you please upload a sample ODT which loses conditional formatting when saved as XLS?
Created attachment 139487 [details]
Spreadsheet as ODS with Conditional Formatting (prior to save as XLS)
Created attachment 139488 [details]
Spreadsheet as XLS; Conditional Formatting as beenlost (just used save-as to XLS)
Created attachment 139489 [details]
Spreadsheet as XLSX; Conditional Formatting partial corruption (ODS to XLSX)
Also note! There is a Bug in LO that - when a spreadsheet is saved to XLS/XLSX, the column format of the BOOLEAN VALUE column to custom format TRUE;TRUE;FALSE
As noted in my other bug, this breaks the ISLOGICAL function, which factors heavily in my conditional formatting functions.
Workaround - select all of Column S2 and convert back to BOOLEAN type.
Thanks for the sample. The conditions are quite complicated.
I wouldn't say it used to be perfect in 4.4, but until 18.104.22.168 some kind of conditional formatting was saved, and starting with 22.214.171.124 none of that is saved. At least that change could be bibisected.
Thank you for your prompt attention in this matter. If you need any further testing, I'll be happy to do so for you. Just let me know when the change is committed.
For reference, the files generated from LibreOffice Still Portable 126.96.36.199 with conditional formatting are being opened on Mac Office 2004 (maybe 2008). That is why I have to use xls format instead of xlsx. The xlsx format is opens, but is not editable according to the staff. It may even be a PPC Mac.
Bibisected to the following commit using repo bibisect-linux-64-5.4. It appears to be a limitation of XLS format, see the following link:
Closing as NOTABUG.
The solution is the reduce the conditional formatting applied to any range to 3 or less.
author Tor Lillqvist <email@example.com> 2017-03-07 22:40:55 +0200
committer Tor Lillqvist <firstname.lastname@example.org> 2017-03-08 00:44:01 +0200
A 'CondFmt' record can have a maximum of three CF records following (eek)
The XLSX part could probably be worth a bug report, though.