Ask Your Question

Is there a way to preserve conditional formatting created in LibreOffice .xlsx and opened in Excel? Thanks

asked 2017-02-17 09:10:49 +0200

this post is marked as community wiki

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.)

edit retag flag offensive close merge delete


I'm thinking macros might be the answer - would be a steep learning curve for me, but maybe worth doing if it works. So if anybody's had experience "simulating" conditional formatting through this means and preserving the results when opened in Excel - please let us know! Thanking you ...

steve.101 gravatar imagesteve.101 ( 2017-02-18 02:48:20 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-02-19 18:39:44 +0200

m.a.riosv gravatar image

There is a know bug about this matter.

edit flag offensive delete link more


Thanks for that, but unfortunately it doesn't help me :)

steve.101 gravatar imagesteve.101 ( 2017-02-27 10:45:35 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-02-17 09:10:49 +0200

Seen: 608 times

Last updated: Feb 19 '17