Ask Your Question

How to preserve a cell's format when cutting from it in Calc [closed]

asked 2012-04-29 21:22:25 +0100

anonymous user


Hi, I frequently cut/paste contents from cells in my worksheets, but I use specific formats for the entire page. However, when I cut a cell, the cell's formatting returns to the default. I understand there's a way to save a worksheet in a desired template but I am working with a huge amount of worksheets that were imported from Excel. Is there a way to prevent Calc from reverting a cell's format to default when I cut it, or is there a way to tell Calc to only cut a cell's contents, not its format?

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 2015-10-15 23:58:48.972736

1 Answer

Sort by » oldest newest most voted

answered 2012-04-30 00:11:15 +0100

m.a.riosv gravatar image

Don't cut directly. 1- Copy. 2- [del], [backspace] give more options.

edit flag offensive delete link more

Question Tools


Asked: 2012-04-29 21:22:25 +0100

Seen: 281 times

Last updated: Apr 30 '12