Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Suspect the numbers are being considered by Calc as text and therefore sorted by alphabetic order instead of numeric.

If you have locale where "," is the decimal separator, then when you enter "1." this will be treated as text and not a number. Solution would be to enter "1", "2" etc instead of "1.", "2." etc.

Other possible cause is if data is imported from csv files with incorrect choice of format for the column of data.

Use "View", "Value Highlighting" to show numeric data in blue and text in black to confirm your data is entered correctly.