Ask Your Question

Copy conditional formating? [closed]

asked 2014-02-03 12:44:05 +0200

Tiago Carrondo gravatar image

How can I copy conditional formating from one calc file to another.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 06:49:35.279477

1 Answer

Sort by » oldest newest most voted

answered 2014-02-03 13:30:21 +0200

Pedro gravatar image

Just Copy the cell with the conditional formatting, switch to the target file and choose Edit > Paste Special. Then uncheck "Paste all" and uncheck all boxes in the Selection area except Formats.

That will paste the conditional formatting.

edit flag offensive delete link more


Doesn't work for me. (with LO 4.2 @ Ubuntu)

Tiago Carrondo gravatar imageTiago Carrondo ( 2014-02-12 10:06:24 +0200 )edit

LO I found that if the cells were "Protected" you couldn't paste using the above answer. Works after cells "Unprotected".

The Old Goat gravatar imageThe Old Goat ( 2019-06-24 11:04:08 +0200 )edit

Question Tools

1 follower


Asked: 2014-02-03 12:44:05 +0200

Seen: 2,649 times

Last updated: Feb 03 '14