Sorting by "Size (b)" column is alphabetical not numerical.

JohnnyBook · 09-01-2022, 10:42 PM

Recently I wanted to check what was the largest book in my Calibre library. (Easiest way to find audible books or picture books (Comics, Magazines, etc.)

I have always used the "Size (b)" column (byte) as it shows the exact file size. (ie. 334421 b (same as 334 kb or .3 MB)

BUT when I sorted the column, it came out alphabetically, NOT numerically.

110001
110005
111
111220
12
13555
169
1704493
etc.

I added back the "Size (MB)" column and it DID sort properly, so was able to find what I was looking for.

But why is the "Size (b)" column treated alphabetically when sorted?

I would assume it is a bug?

Thanks

kovidgoyal · 09-01-2022, 10:50 PM

Presumably you didnt specify the column contains numbers when you created it in Preferences->Add your own columns

JohnnyBook · 09-01-2022, 10:57 PM

Quote:

Originally Posted by kovidgoyal

Presumably you didnt specify the column contains numbers when you created it in Preferences->Add your own columns

LOL, Your right. It has been so long since I started using Calibre (Wow its been 15 years!!) That I thought it was a standard column. Did not realize I had created it.

Probably just left it on default. (text) Switched to (number) and it works perfectly.

Thanks.

09-01-2022, 10:42 PM	#1
JohnnyBook Groupie Posts: 196 Karma: 126824 Join Date: Dec 2008 Location: Out There Device: K3 W/3G (Fixed screen!) & Paperwhite Wifi	Sorting by "Size (b)" column is alphabetical not numerical. Recently I wanted to check what was the largest book in my Calibre library. (Easiest way to find audible books or picture books (Comics, Magazines, etc.) I have always used the "Size (b)" column (byte) as it shows the exact file size. (ie. 334421 b (same as 334 kb or .3 MB) BUT when I sorted the column, it came out alphabetically, NOT numerically. 110001 110005 111 111220 12 13555 169 1704493 etc. I added back the "Size (MB)" column and it DID sort properly, so was able to find what I was looking for. But why is the "Size (b)" column treated alphabetically when sorted? I would assume it is a bug? Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Custom Column: Alphabetical sorting in tag browser includes articles	ownedbycats	Library Management	2	06-30-2020 12:52 PM
Reading time by creating a column with "word count"/"your wpm"	Anyssia	Calibre	2	01-04-2019 01:02 PM
Custom column for "Volume" and "Version" (Revision)	BaronKrause	Library Management	10	11-02-2017 09:20 PM
Sorting "Formats" column	dancingbacon	Library Management	7	11-25-2011 06:30 PM
Custom column: "Updated date", when adding new "versions" of the same file?	enriquep	Library Management	16	11-03-2011 10:46 AM

09-01-2022, 10:50 PM	#2
kovidgoyal creator of calibre Posts: 45,345 Karma: 27182818 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Presumably you didnt specify the column contains numbers when you created it in Preferences->Add your own columns

Advert