Ask Your Question

Calc How do I drag and drop contents only, while preserving formatting in the original cell? [closed]

asked 2013-02-05 14:02:11 +0200

SusanCragin gravatar image

I have a spread sheet with some complex formatting, and I do a lot of drag-and-drop of individual cells. How do I drag-and-drop without disturbing my original formatting? I need to d-a-d text only, or text and formulas only.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-27 01:34:56.311454

3 Answers

Sort by » oldest newest most voted

answered 2013-02-15 23:12:08 +0200

SusanCragin gravatar image

It can't be done drag-and-drop.

edit flag offensive delete link more


Hi @SusanCragin, Were you responding to @mikebibo's Answer? I think you should have enough karma now to comment on Answers :-)

qubit gravatar imagequbit ( 2013-03-19 08:23:26 +0200 )edit

answered 2013-03-19 08:28:45 +0200

qubit gravatar image


Sounds like you have a couple of different use cases:

I need to d-a-d text only, or text and formulas only.

How were you hoping to be able to drag-n-drop in the couple of different ways? Were you thinking about holding down an option/modifier key while you dragged a particular cell, or?

If you still haven't found an answer yet, it's possible that we don't know or the feature hasn't been implemented. If you have a good idea about how this should work, please file an enhancement bug and provide a description of how the drag-and-drop would be easiest for our users. Don't forget to mark your bug as an 'enhancement'. The QA team will be happy to help you triage your feature request in the bugtracker.

Please post a link to any bugs you file in a comment below using the format "fdo#123456".


edit flag offensive delete link more

answered 2013-02-05 22:10:44 +0200

mikebibo gravatar image

Copy -> Paste special... allows you to choose what you paste: values, text, formulas, formatting, etc

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-02-05 14:02:11 +0200

Seen: 1,283 times

Last updated: Mar 19 '13