Ask Your Question

Cut and paste without deleting grid lines (calc) [closed]

asked 2017-09-15 18:05:11 +0100

appreciatethehelp gravatar image

Howdy folks.

So when I cut and paste in calc, the (manually entered/visible when printed) grid lines are removed as well. Is there any way to prevent this from happening?

To get around this problem I am copying the stuff to be pasted and then just deleting the text and numbers from the copied area, however this is one step too many and a little inconvenient, particularly when doing this many, many times.


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 2020-10-15 16:09:10.825768

1 Answer

Sort by » oldest newest most voted

answered 2017-09-15 18:15:14 +0100

When you cut cells, the range is reset to the Default cell style. If you assign borders to the Default style, then cut will leave cells in the bordered state. But: 1. all cells will be bordered that way (unless you clear borders explicitly), and 2. non-default bordering will still be reset to default.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-09-15 18:05:11 +0100

Seen: 485 times

Last updated: Sep 15 '17