Calc Data Sort sorts by only the first number - in this case: sorted by Ascending. For instance 150 in a row would be put before 21 in the row. Please help. Thanks.
Libre 4.3.1.2 Calc English (US) MacBook Pro Mtn Lion 10.8.5
Calc Data Sort sorts by only the first number - in this case: sorted by Ascending. For instance 150 in a row would be put before 21 in the row. Please help. Thanks.
Libre 4.3.1.2 Calc English (US) MacBook Pro Mtn Lion 10.8.5
Perhaps numbers are as text in cells.
Please try the option: Menu/Data/Sort/Options - Enable natural sort.
Thank you for answering so promptly, mariosv. Yes, I had tried that. I saw in an earlier post and version of LOO that this was a bug but thought it might have been fixed by now.
Also, I began with an OO calc document. Would that matter?