Ask Your Question

How to convert conditional formatting to static/permanent formatting

asked 2017-02-02 20:59:04 +0100

Donaithnen gravatar image

updated 2017-02-03 17:18:33 +0100

This was first asked several years ago ( but apparently closed because it never got an answer.

The question is, given a set of data with conditional formatting, how to you copy that data to another sheet or another document while keeping the visible formatting but _without_ copying the conditional formatting rules. The intent is to "freeze" or "flatten" the formatting onece you've achieved the desired results and don't want any further changes to the data to be reflected by changes in the conditional formatting.

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2019-01-03 11:17:58 +0100

bene25 gravatar image

Thanks for help, it works!

edit flag offensive delete link more

answered 2017-02-02 21:01:13 +0100

Donaithnen gravatar image

Since i couldn't find an answer here i ended up perusing several Excel and OpenOffice forums. I found multiple answers, but most of them involved running complicated macros to copy the formatting. However there was one slightly awkward but brilliantly simple solution. Just save the spreadsheet as an html document, then open up that html document in LibreOffice. The formatting will have been applied directly to the cells but the conditional formatting will not be present. You can then copy that data to whatever final location you want.

edit flag offensive delete link more

answered 2018-01-09 02:35:17 +0100

Hi guys

I was looking for exactly the same thing and Donaithnen advise (save as HTML) worked great for me. One problem that occurs with this solution is that it changes fonts and width of the columns. It is however easy to rectify. Thank you for that, I appreciate the time you spend looking for the solution.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-02-02 20:59:04 +0100

Seen: 4,740 times

Last updated: Jan 03