Is there a way to preserve conditional formatting created in LibreOffice .xlsx and opened in Excel? Thanks
asked 2017-02-17 09:10:49 +0100
This post is a wiki. Anyone with karma >75 is welcome to improve it.
Hi. I've recently completed an SEO Audit course which uses spreadsheets with conditional formatting. I can do this in Calc as .xlsx, but when opening the file in Excel (as I expect many of my clients would), the conditional formatting is lost. Is there any way around this? Thanks!
For instance - highlighting duplicates, or background colour for cells containing certain text. Can do in LibreOffice but when opening in Excel get the following message:
"Excel found unreadable content in '<filename>.xlsx'. Do you want to recover the contents of this workbook? If you trust the workbook, click Yes."
Click Yes, file loads, all there - except the conditional formatting.
(Same thing happens as an .ods file.)