Hi,
I have a problem with sorting when I use autofilter ascending with Calc
It gives me something different from the order given by a unix ls command.
> ls -1
aaa2004
aaa_2005
aaa_2006
Calc with an autofilter set on ascending order gives me
aaa_2005
aaa_2006
aaa2004
How can I get the same sort as with my ls unix command ?
Thanks
Patrick
I got the same under both 5.0.0.1 & 4.4.4.3. In fact, v4 is worse as it moves the (blank) header row below the selected range.
It’s a bug - report it.
Simply for reference, the default filter for ascend/descend is supposed to be Unicode order. Thus:-
_(U+005F) LOW LINE
> 9(U+0039) DIGIT NINE
> 0(U+0030) DIGIT ZERO
If this helps then please tick the answer (
)
…and/or show you like it with an uptick (∧)