Ask Your Question

lock conditional ranges

asked 2020-06-27 21:37:25 +0200

-rob- gravatar image

working with LO Version: on: Mac OS X 10.15.5

I created a conditional format for a range (in my case R4:AC120). When I copy/paste a cell within the range to a place outside it, the new cell is added to the range.

I tried to fix the range by setting $R$4:$AC$120, to fix the format to specific cells. However, the dialog for setting/changing the conditional formatting keeps on silently deleting the "$" sign from the range.

I hoped to get the behaviour that conditional formatting ws not copied along with copy/paste!

How do I get the intended behaviour?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-06-27 22:00:32 +0200

Lupp gravatar image

updated 2020-06-27 22:02:12 +0200

Conditional formatting is treated like direct attributes. If you pasted a range including its CF, you can clear it with Ctrl+M (default for Clear Direct Formatting). If your unconditional formatting is completely based on cellstyles, it will not be afflicted.
Otherwise it's complicated.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-06-27 21:37:25 +0200

Seen: 20 times

Last updated: Jun 27