Issues with decimal numbers sorting + sorting series but showing title first

[TheRealAce]

Dear E-readers,

this is a 2-part question, I hope that's okay.


First, for some reason the Kindle doesn't sort decimal number correctly when displayed like this:

program:

sidx=field('series_index');
i=format_number(sidx, "{:02d}");
f=format_number(sidx, "{:04.1f}");
isInt=cmp(f, i, '', 'yes', '');
final_sidx=finish_formatting(
    test(isInt, i, f),
    '',
    ' [',
    '] '
);

# Add together the final result
strcat(
    field('series'),
    final_sidx,
    field('title')
);

Stormlight Archive [01] - Way of Kings
Stormlight Archive [02.5] - Edgedancer
Stormlight Archive [02] - Words of Radiance

After an extensive search I concluded it's not possible because of the number/symbol order programmed in Kindle itself. However, the threads and articles I read where at least 2 years old, some older.
Has there been an update and/or is it fixable with the current version?

To clarify, I did get it to sort correctly with:

{series} {series_index:04.1f|[|] }{title}

but then it shows all numbers with a .0 like so:

Stormlight Archive [01.0] - Way of Kings
Stormlight Archive [02.0] - Words of Radiance
Stormlight Archive [02.5] - Edgedancer

and that applies to other series without decimals as well.
Apologies for sounding like a total OCD freak, but this is not quite what I want.


Second, nothing major but, I'd like to sort my series on the series name and number but with the title showing first, like this:


Way of Kings - Stormlight Archive [01]
Words of Radiance - Stormlight Archive [02]
Oathbringer - Stormlight Archive [03]

But when putting title first, it of course sorts on title alphabetically:

Oathbringer - Stormlight Archive [03]
Way of Kings - Stormlight Archive [01]
Words of Radiance - Stormlight Archive [02]

Is it possible to have title show first but still sort on series?


Any help or advice would be greatly appreciated, apologies again for the nitpicking. If it's not solvable I guess I'd have to choose between ugly numbers or wrong sorting.

BTW: I have a Kindle Basic 10th gen 6" and Calibre 4.6

[theducks]

I can't answer for a New Kindle (have a K4nt )
PLUGBOARD and Collection was my solution

{series_index: >5.2f|| - }{title}

BTW use a leading space when formatting the index for some of the issue as space sorts before 0 - 9, elims the leading 0

Personally, I just leave the leading and trailing 0's, it makes the list look more even

[TheRealAce]

Originally Posted by theducks

I can't answer for a New Kindle (have a K4nt )
PLUGBOARD and Collection was my solution

{series_index: >5.2f|| - }{title}

BTW use a leading space when formatting the index for some of the issue as space sorts before 0 - 9, elims the leading 0

Personally, I just leave the leading and trailing 0's, it makes the list look more even

How do you remove all the trailing 0's and still be able to use decimals like:
1
2.5
and not
2.50

Right now I've managed to remove the leading zero and have only 1 trailing 0.

{series}{series_index:2.1f| #| - }{title}

Series #1.0
Series #1.5

I guess this is best option under the circumstances. Would be great if someone can get it to:

Series #1
Series #1.5
Series #2

Thanks for replying!

[chaley]

See this post.