[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]

Reply via email to