Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I can't get my Calc-document to sort correct alphabetically.

Hi people,

I am busy with a list of movies which I put into my Calc-document. Problem: I can't get it sorted alphabetically allright.

I have setup all my cells (cell layout) to "Text" and aligned all cells to "Left". I mind all spaces at the front so that is not the problem for sorting (a.k.a no spaces at front)

It sorts my movielist now as follows:

10 300 1408 2012 10 Cloverfield Lane 30 Days Of Night 30 Minutes Of Less 300: Rise Of An Empire

etcetera

Calc refuses somehow to sort 300, 1408 and 2012 correctly even when I put those movietitles at the very bottom of column A (1740 rows), or for example put both 300 movies after eachother at the correct place.

Does anyone have suggestions?

Cheers, Geeviz.

I can't get my Calc-document to sort correct alphabetically.

Hi people,

I am busy with a list of movies which I put into my Calc-document. Problem: I can't get it sorted alphabetically allright.

I have setup all my cells (cell layout) to "Text" and aligned all cells to "Left". I mind all spaces at the front so that is not the problem for sorting (a.k.a no spaces at front)

It sorts my movielist now as follows:

10 10
300 1408 2012 10 Cloverfield Lane 30 Days Of Night 30 Minutes Of Less 300: Rise Of An Empire

etcetera

Calc refuses somehow to sort 300, 1408 and 2012 correctly even when I put those movietitles at the very bottom of column A (1740 rows), or for example put both 300 movies after eachother at the correct place.

Does anyone have suggestions?

Cheers, Geeviz.

I can't get my Calc-document to sort correct alphabetically.

Hi people,

I am busy with a list of movies which I put into my Calc-document. Problem: I can't get it sorted alphabetically allright.

I have setup all my cells (cell layout) to "Text" and aligned all cells to "Left". I mind all spaces at the front so that is not the problem for sorting (a.k.a no spaces at front)

It sorts my movielist now as follows:

10
300 1408 300
1408
2012
10 Cloverfield Lane Lane
30 Days Of Night Night
30 Minutes Of Less Less
300: Rise Of An Empire

etcetera

Calc refuses somehow to sort 300, 1408 and 2012 correctly even when I put those movietitles at the very bottom of column A (1740 rows), or for example put both 300 movies after eachother at the correct place.

Does anyone have suggestions?

Cheers, Geeviz.