[EMAIL PROTECTED] wrote:
I have posted this on the Calc users' list but, because that list is
fairly inactive, thought to post here as well.
Looking for an answer to a question in the forum, I discovered a
strange thing.
I am unable to sort a row in alphabetical order.
I place the letters c, a and b (in that order) in contiguous cells in
a row. I use Data >Sort, choose sort by c (it doesn't seem to make
any difference), select "Left to right", de-select "Range contains row
labels", press OK and ... I still have c a b (in that order).
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]