Ask Your Question

How to lock the layout of cells

asked 2016-10-25 14:09:49 +0200

igadget gravatar image

Dear LOo community,

Today I created a nicely laid out spreadsheet in Calc, which will be used to cut-and-paste a lot of different data around in. This all works well of course, except that with each cut-and-paste the layout of cells is going with it and as a result the general layout is 'broken'. So my question is - how do I lock the layout (specifically border style) of cells so when data is cut out of or paste into the cells, the layout remains? General locking seems to also prevent me from modifying the contents, which should remain modify-able.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-10-25 22:06:43 +0200

mark_t gravatar image

You could try to copy and paste special, only pasting the values of the cells instead of all the formatting etc. Then separately delete the content of the original cells.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-10-25 14:09:49 +0200

Seen: 238 times

Last updated: Oct 25 '16