We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

[Calc] Conditional formatting disappearing when saving as .xlsx

asked 2018-06-06 22:46:25 +0200

bengineer gravatar image

updated 2021-06-01 07:04:23 +0200

Alex Kemp gravatar image

I'm running LibO on Windows 10 Home, version 1803, OS build 17134.48. When editing a document with the .xlsx file extension, if I apply conditional formatting to a range of cells, save the file, exit, and re-open the file, the conditional formatting has completely disappeared.

When saving the document in .ods format, it's fine upon saving, exiting, and re-opening.

Has anyone else experienced this issue? Is it only an issue with .xlsx, or is it anything non-native to LibO? Do you know of any fixes? I'm one of the only people in my company who uses LibO, and it's annoying to not have that compatibility with .xlsx files.


edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2018-06-06 22:55:16 +0200

kompilainenn gravatar image

try update your version of LibreOffice to 5.4.7 or 6.0.4

I tried create conditional formatting for range, saved to XLSX, re-opened - works fine (for Icon Set). My version is 6.0.4

edit flag offensive delete link more

answered 2020-05-21 00:06:45 +0200

-rob- gravatar image

I have the same in LO Version: on MacOS Catalina 10.15.4 (19E287)

edit flag offensive delete link more


That is not an answer. Can you post it as a comment, please?

LeroyG gravatar imageLeroyG ( 2020-05-21 00:24:42 +0200 )edit

answered 2019-01-29 23:02:44 +0200

Yes, I'm having the same issue. I'm using Windoze 10 and Libre Office Version: (x64) Build ID: 86daf60bf00efa86ad547e59e09d6bb77c699acb CPU threads: 2; OS: Windows 10.0; UI render: default; Locale: en-US (en_US); Calc: group threaded

This is a really annoying bug as well since I have to save in MS Office compatible files. Anyone who may know a solution, please chime in.

edit flag offensive delete link more



This is a really annoying bug

Have you filed a bug report with a sample ODS which looses conditional formatting upon saving as XLSX?

Mike Kaganski gravatar imageMike Kaganski ( 2019-01-30 06:43:58 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-06-06 22:46:25 +0200

Seen: 1,190 times

Last updated: May 21 '20