Autofilter with ascending gives a different order from unix

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 (:heavy_check_mark:)

…and/or show you like it with an uptick ()