On 13/03/2008 14:54, Anthony Chilco wrote:
Anthony Chilco wrote:
Mike Field wrote:
Harold Fuchs wrote:
Hi Harold,
I'm using OpenOffice 2.3.1 under Windows Vista Business.
I tried to use the Paste-Special-with-shift-cells idea, but when I'm
trying to move a row, the "Shift Down" radio button is greyed out,
and conversely, when I'm trying to move a column, the "Shift Right"
button is greyed out.
This seems backwards - surely it's a bug?
Hi Mike,
I get the same graying out if I don't delete the column or row that
I've cut. If I delete the area that's been cut, all the shift options
are selectable. I can even undo the deletion and the buttons will
still work as they should.
tc
What is odd about it is that when all the buttons are active, the
default action is the wrong one: i.e. if I cut a row, right is
selected and if I cut a column, down is selected.
tc
I'm confused. The "shift cells" options are available on **paste
special** and on **delete cells**. You are saying they are available on
**cut**. At least, not on my installation. What am I missing here? I am
talking about OOo 2.2 on Win XP Pro.
OK, just installed 2.3.1 and its *exactly* the same.
If I select a few cells in a column and choose Delete Cells then the
options I'm given are Shift Cells Up, Shift Cells Left, Delete Entire
Columns and Delete Entire Rows.
The Shift Cells Up refers to the cells *below* those I selected.
The Shift Cells Left shifts left the data to the right of the selected
column but only those cells in the same rows as the selected cells
The Delete Entire Rows deletes the entire rows in which the selected
cells lie and shifts up the rows below the lowest.
The Delete Entire Columns deletes the column in which the select cells
lie *and* moves left the columns to its right; so that's like "cut column".
This is all very different from "Delete contents" which offers no such
options - the remaining data stay where they are regardless.
It's also different from "Cut" which is like Delete Contents **but**
also copies the data to the clipboard.
Note that this all applies *only* if I select *cells*. If I want it to
apply to *all the cells* in a column then I have to select the first
cell and then Shift-select the last. It does *not* work if I select
Calc's alphabetical column heading - if I do that then the entire column
is deleted without any options and columns to its right are shifted left.
The same applies to selecting/deleting cells in a row except that "left"
replaces "up" and vice versa in the above comments. Similarly, "to the
right of" replaces "below"
I can find no greyed out options nor any illogicalities in what is offered.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
