In OpenOffice Calc, how do I drag and drop cells to insert rather than replace their destination?

Posted by joachim on Super User See other posts from Super User or by joachim
Published on 2010-03-26T16:14:32Z Indexed on 2010/06/12 11:33 UTC
Read the original article Hit count: 354

Filed under:

openoffice.org

|

calc

I want to rearrange rows with the mouse in Calc.

In Excel, I select the whole row, then drag and drop it while holding Shift. This causes the drag and drop cursor to turn into a bar rather than cells, and the cells are inserted at the bar's position.

Is there a way to accomplish the same sort of thing in Calc without going around the houses inserting columns before the drag operation?

© Super User or respective owner

Related posts about openoffice.org

apt-get is broken

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I Cannot install any package in the server, As I am newbie in Server. In Morning I found that some, I am not able to install any package from command line in the server,Now every package is now manually downloaded packages and then installed in the server. Can any one Please tell me what is the issue… >>> More
Install OpenOffice for headless use

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
The question very simple and short. I am following this article to install OpenOffice headless: sudo apt-get install openoffice.org-headless openoffice.org-writer openoffice.org-draw And I get the following error : Reading package lists... Done Building dependency tree Reading state information… >>> More
Install OOo for headless use

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
The question very simple and short. I am following this article to install OpenOfficle headless: sudo apt-get install openoffice.org-headless openoffice.org-writer openoffice.org-draw And I get the following error : Reading package lists... Done Building dependency tree Reading state information… >>> More
How to recover dpkg from corrupted downloads?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I just upgraded to the 10.10 RC earlier and had a few problems with graphic drivers (x didnt start) But i have remedied that now. When i run 'sudo apt-get install -f' i get this: will@UbuntuBox:/mnt/slax$ sudo apt-get install -f [sudo] password for will: Reading package lists... Done Building dependency… >>> More
Programmatically convert *.odt file to MS Word *.doc file using an OpenOffice.org basic macro

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to build a reStructuredText to MS Word document tool-chain, so I will be able to save only the rst sources in version control. So far I -- Have rst2odt.py to convert reStructuredText to OpenOffice.org Writer format. Next I want to use the most recent OpenOffice.org (currently 3.1) that… >>> More

Related posts about calc

Ubuntu: Convert OpenOffice Calc to Excel workbook using CLI

as seen on Super User - Search for 'Super User'
I need to create an automated report in a spreadsheet format. Unfortunately, There seems to be an easy way to create these reports using OpenOffice Calc, but upper managements wants them in MS Excel format. As these reports are to be created and emailed automatically, is there a nice, command-line… >>> More
Automatically insert Cell References from one Sheet into other Sheet in OOO Calc

as seen on Super User - Search for 'Super User'
I have a spreadsheet in Open Office 3.0 Calc. The spreadsheets consist of the first sheet and an arbitrary number of additional sheets, each collecting data for a specific month. The Month sheets have an identical structure. The first sheet is supposed to provide an overview to the most important… >>> More
Set CSV import default to UTF-8 in Calc

as seen on Super User - Search for 'Super User'
Every time I open a CSV (comma separated values) document in OpenOffice.org Calc I get a dialog with CSV preferences. The current default character set is "Eastern Europe (ISO-8859-2)". I would like "UTF-8" to be selected by default instead. >>> More
Open Office crashes, recovers, crashes again

as seen on Super User - Search for 'Super User'
After completely reinstalling my laptop due to apparent registry corruption, I've encountered a problem with Open Office: I open a simple Calc spreadsheet, it comes up normally, but then after anywhere from 5 seconds to several minutes (without even touching the Calc window) OO crashes, then comes… >>> More
Python regex to parse text file, get the items in list and count the list

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a text file which contains some data. I m particularly interested in finding the count of the number of items in v_dims v_dims pattern in my text file looks like this : v_dims={ "Sales", "Product Family", "Sales Organization", "Region", "Sales Area", "Sales office", "Sales Division", "Sales… >>> More