Ask Your Question

Copy conditional formatting from cell to cell in other sheet [closed]

asked 2014-09-13 21:33:27 +0100

sergtk gravatar image

updated 2016-03-03 18:40:44 +0100

Alex Kemp gravatar image

I created conditional formatting for a cell. It is to highlight the cell if it contains today's date.

When I copy/paste the cell in the same sheet it works fine in the destination cell as well. But when I copy cell to the other sheet formatting is missed. It does not hightlight cell anymore and conditinal formatting appears empty.

How to workaround such behaviour. It looks like a bug. Isn't it?

This behavior may be reproduced for the new calc document.
I use LibreOffice on Windows x32 Version:
Build ID: 62ad5818884a2fc2e5780dd45466868d41009ec0


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-03-03 18:40:59.633815


Can't reproduce it, CondionalFormatting works after copy to other sheets
Lo4.3.1.2 Linux64Bit

karolus gravatar imagekarolus ( 2014-09-13 21:50:51 +0100 )edit

Thanks for note. Hope the bug fix will be available when new version will be released for Windows

sergtk gravatar imagesergtk ( 2014-09-15 12:29:11 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-09-14 21:05:16 +0100

Regina gravatar image

For me it does not work, when copy/paste cells, but it works, if I only copy/paste the format. Use Paste Special with the settings Formats and Add. You need to copy the format from the cell, where it is originally defined.

There seem to be some unsolved problems although some bugs are already fixed, read fdo#82503 and fdo#61946.

edit flag offensive delete link more


"Copy/paste special" results in the same buggy behavior as described in question. Anyway thanks for link to bugs, it is good that the bug is filed.

sergtk gravatar imagesergtk ( 2014-09-15 12:30:35 +0100 )edit

Question Tools

1 follower


Asked: 2014-09-13 21:33:27 +0100

Seen: 5,564 times

Last updated: Sep 14 '14