Richard Detwiler wrote:
[EMAIL PROTECTED] wrote:
<snip>
Is there any way to sort a row in Calc?
I got it to work. Here's what I did. I set up the following row (in
row 3 but it shouldn't matter):
c a b x t d
I selected the range of cells. I selected Data > Sort.
I clicked the Options tab, checked Left to Right, and deselected
"Range contains row labels".
I clicked the Sort Criteria tab. Under Sort By, I clicked the dropdown
list and selected Row 3.
The result (after clicking OK) was:
a b c d t x
Thanks to both who replied.
There is something wrong with the file. Even when I paste data into a
new file, it somehow corrupts the new file and Data >Sort does not
work. It does, however, work in a virgin file.
The query on the forum actually relates to sorting a number of rows, all
in random order. It seems to be impossible to sort a number of such
rows simultaneously, so I wanted to record a macro sorting of one row
and adapting it to sort rows in a selection one by one.
Now I have another chore - transferring data from the file (only a test
document) to another file without transferring whatever error is
preventing the file from functionning correctly. :-\
--
If you're seeking, check out http://www.rci.org.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
