I think kenkious refers to a feature of Excel that Calc lacks where one
can drag a selected row/column and Excel doesn't overwrite the target
area but makes room for the moved block first.
In Calc one has to make enough room manually. Drag&Drop the data and
remove the now empty space where the data was before.
This is suboptimal if one wants to sort data with the mouse.
Richard Detwiler schrieb:
[EMAIL PROTECTED] wrote:
there is a feature of Excel that i use all the time and its apparent
lack in officeCalc limits my use of this otherwise great program.
Excel allows me to drag selected cells (1, or a block, or rows, or
columns) from one location to another. I just select the cell(s) and
then position the cursor over any border of the selected cell(s). At
that point the cursor becomes a multi-pointed icon (like a compass).
If I left-click and hold down, I can drag the cell(s) and the
contents to another spot. this is a hugely helpful feature that I
cannot find supported in OfficeCalc. I've tried Help and tutorials
and my own best guesses to no avail.
Can anyone there tell me how to drag cells and their contents?
thank you,
Ken
You're correct, the "Help" is not helpful on this topic. Please see
the migration guide:
http://documentation.openoffice.org/manuals/oooauthors2/0600MG-MigrationGuide.pdf
on page 87, where it describes how drag and drop works in Calc.
There is definitely a non-obvious "trick" to dragging a single cell,
which is explained in the reference above. However, dragging a range
is not particularly tricky, in fact it's easier than it is in Excel,
so I'm a bit surprised that you've had trouble doing that. Again, the
above reference should clarify things. If not, please get back to this
list.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
