INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: JR character sort is different to Excel  (Read 2111 times)

FenceFurniture

  • Galactic Citizen
  • ****
  • Posts: 420
JR character sort is different to Excel
« on: November 14, 2019, 04:31:25 pm »

If I have cells with the following characters, in Excel they sort (ascending) as follows:

©   (which is Alt 184)
♪   (which is Alt 269)
♫   (which is Alt 270)
10cc
2Cellos
z

However, in JRiver they sort like this:

2Cellos
10cc
©   (which is Alt 184)
♪   (which is Alt 269)
♫   (which is Alt 270)
z


It is particularly perplexing how JR thinks a 2 is less than 1, and I would much prefer it to sort in the same way as Excel does (for all characters).

Posting this on the very slight off chance that the sorting can be modified?
Logged

Hendrik

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 10933
Re: JR character sort is different to Excel
« Reply #1 on: November 15, 2019, 03:33:56 am »

Number sorting is performed "smart", as in it doesn't sort 2 is less then 1, but it sorts 2 is less then 10, which in most cases makes much more sense then strict alphabetic sorting on numbers (so that eg. 1, 2, 3, 10, 11, 12 comes out just like that, and not as 1, 10, 11, 12, 2, 3)

We're not aiming to match any other softwares sorting directly, but have it make sense on its own.
Logged
~ nevcairiel
~ Author of LAV Filters

FenceFurniture

  • Galactic Citizen
  • ****
  • Posts: 420
Re: JR character sort is different to Excel
« Reply #2 on: November 16, 2019, 10:25:33 pm »

Ok, I understand.
Logged
Pages: [1]   Go Up