MobileRead Forums - View Single Post - Sorting of composite numerical columns with formatting

ownedbycats · 06-26-2021, 11:47 AM

I have a composite column that usually shows a number. However, for a subset of books it shows a value like '60/70.'

If I set the column to sort by number, it fails to sort entirely. I have to do it by text, but this results in weird sorting (e.g. 10, then 100, then 11). Is this intended?

06-26-2021, 11:47 AM	#1
ownedbycats Custom User Title Posts: 11,024 Karma: 75555555 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Sorting of composite numerical columns with formatting I have a composite column that usually shows a number. However, for a subset of books it shows a value like '60/70.' If I set the column to sort by number, it fails to sort entirely. I have to do it by text, but this results in weird sorting (e.g. 10, then 100, then 11). Is this intended?