Description: 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 Actual Results: Document opens, no conditional formatting is executed Opening conditional formatting has no elements in it. Expected Results: Document opens and executes conditional formatting. Opening conditional formatting should conditional formatting elements in it. Reproducible: Always User Profile Reset: Yes Additional Info: Well, keep conditional formatting, for one :) Cross platform bug. Tested broken on Win 10 64-bit and Ubuntu 17.10 64 bit. LibreOffice Portable 4.4.7.2 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 5.3.0.3 some kind of conditional formatting was saved, and starting with 5.4.0.3 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 4.4.7.2 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: https://msdn.microsoft.com/en-us/library/03AE6098-BDC2-475B-BA2C-B8AEF7882174 Closing as NOTABUG. The solution is the reduce the conditional formatting applied to any range to 3 or less. https://cgit.freedesktop.org/libreoffice/core/commit/?id=7ceda09f6780c954fedc49764d5457aa2616b39a author Tor Lillqvist <tml@collabora.com> 2017-03-07 22:40:55 +0200 committer Tor Lillqvist <tml@collabora.com> 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.