| Summary: | Conditional Formatting is completely lost on save to XLS format FILESAVE FILEOPEN FORMATTING | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | C Hemingway <chemingway> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | aron.budea, chemingway, timur |
| Priority: | medium | Keywords: | bibisected, bisected |
| Version: | 5.4.0.3 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 88174, 160146 | ||
| Attachments: |
Spreadsheet as ODS with Conditional Formatting (prior to save as XLS)
Spreadsheet as XLS; Conditional Formatting as beenlost (just used save-as to XLS) Spreadsheet as XLSX; Conditional Formatting partial corruption (ODS to XLSX) |
||
|
Description
C Hemingway
2018-01-31 20:41:18 UTC
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. |