Uwe Brauer wrote:
"Dan" == Dan Lewis <[EMAIL PROTECTED]> writes:
Dan> If I understand you correctly, you want to sort one column
Dan> and that is it. The information in the other columns remains
Dan> in the order it was in the beginning. If this is the case,
Dan> click the letter at the top of the column you want to
Dan> sort. Data > Sort will bring up a window in which you decide
Dan> how you want that column to be sorted. Click OK.
Dan>To sort a row or column, it must be highlighted first. If you
Dan>want
Dan> to sort multiple columns or rows at one time, they must all be
Dan> highlighted.
Oops, again I explained it badly. It is precisely the other way
around.
That is suppose
Original table
This 1
Book 2
Cesar 3
Now I mark the first column and order it alphabetically I obtain
Book 1
Cesar 2
This 3
But want I want is this, Although I only marked the first column.
Book 2
Cesar 3
This 1
Now you point out that in order to achieve this, I should hightlight
all the relevant columns. Thats right. But I want to have some
protecting. That is also I only mark one column and sort the column
all the others get sorted as well.
What I want is sort of database behaviour for the sheet.
Is this possible, maybe there exists a macro?
I don't follow understand what is wrong with selecting both column and
hitting sort, you get the result. I suppose you could write a macro that
would select the rest of the colummns and sort, then you would only have
to select one.
HTH,
--
Peter Kupfer -- Using OOo since 'OO4 -- [EMAIL PROTECTED]
Want to help? http://www.oooauthors.org
For OOo tips: http://openoffice.peschtra.com/ooo_tips_tricks.html
To order OOo: http://openoffice.peschtra.com/distro/ooo_distro.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
