[TheMadGuy]

Well, maybe I am the only one but I am sure I am not having this problem:

Imagine you have an ebook-series with e. g. 3000 items with ascending numbers. And you export what you own to have kind of a catalogue in Excel (or OpenOffice/LibreOffice).

No my problem is that LibreOffice doesn't sort numbers "the right way" what means they look kind of

1.0
10.0
11.0
12.0
13.0
14.0
15.0
16.0
17.0
18.0
19.0
2.0
20.0
21.0

and so on. And especially when the number of items has for digits (or even more), I am never able to get a correct ascending (or descending) list in LibreOffice.

So is there any possibility to "tell" Calibre - according to the highest number of any series - to fill the other ones with "Zeros" (000) at the beginning to have all with the same number of digits? So there wouldn't be a number 1.0 anymore but a 0001.0

As I got a load of series with at least 3 digits and some more with even 4 digits, help would be really appreciated to finally get correct ascending lists.

Thanks in advance for your support!