Incorrect sorting of numbers

Resolved stockuper
(@stockuper)

6 years, 10 months ago

Hello Tobias
Thank you for your plugin. This is the best plugin in WordPress
I’ve dealt with a lot of things. But I can’t get the columns sorted correctly. The numbers are not sorted correctly. For example, the number 4 910 207 sorting counts more than the number 37 823 040 only because it starts at 4. I understand that the problem is spaces between numbers, but without spaces large numbers are inconvenient to read. Also not correctly sorts the date (in the example there are different options columns).
This plugin I installed, but do not know how to use it – https://tablepress.org/extensions/datatables-sorting-plugins/
Here is a table in Google spreadsheet where I’m doing data import – https://docs.google.com/spreadsheets/d/e/2PACX-1vRfRpHw9Xo2_tkaC9bbtTuWH1M9mKUGkK-sF9F_lhs9gEjumn2yruPbKj7x__07RCmRGU2C60xU1Req/pub?output=xlsx
Please explain what I’m doing wrong

The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)

Plugin Author Tobias Bäthge
(@tobiasbg)

6 years, 9 months ago

Hi,

thanks for your post, and sorry for the trouble.
Also sorry for the late reply! As I was on holidays, I did not have a chance to look at this earlier.

For your case, the best approach might be to develop a custom sorting algorithm in JavaScript, or to maybe try the approach from https://wordpress.org/support/topic/date-order-6/

Regards,
Tobias

Thread Starter stockuper
(@stockuper)

6 years, 9 months ago

it’s beautiful! Thank you!
I think this solution will suit me.
Please tell me, if I need to make several columns do the correct sorting, how do I change the command?
“columnDefs”: [ { “orderData”: [ 4 ], “targets”: [ 3 ] } ] now I put and 4 column hide. Everything works. And if I need to link 1 and 2 more columns?
“columnDefs”: [ { “orderData”: [ 4, 1 ], “targets”: [ 3, 2 ] } ] – it doesn’t work
“columnDefs”: [ { “orderData”: [ 4 ], “targets”: [ 3 ] }{ “orderData”: [ 1 ], “targets”: [ 2 ] } ] so does not work and lost sorting
if you do 2 commands “columnDefs” also lost sorting
Plugin Author Tobias Bäthge
(@tobiasbg)

6 years, 9 months ago
Hi,

you’ll need to combine them like this:
```
"columnDefs": [ { "orderData": [ 4 ], "targets": [ 3 ] }, { "orderData": [ 2 ], "targets": [ 1 ] } ]
```
so basically a comma-separated list around the { ... }.

Regards,
Tobias
Thread Starter stockuper
(@stockuper)

6 years, 9 months ago

thank you! it works. My question was too stupid, sorry.
If can be, then the latest question, to not create a separate subject. How to merge cells if the table is imported from Google spreadsheet? The Union in a Google table is lost when importing

Plugin Author Tobias Bäthge
(@tobiasbg)

6 years, 9 months ago

Hi,

you will need to write the #colspan# or #rowspan# keywords in normal cells in Google Spreadsheet. So, basically, the cell will not be merged there, but after the import in TablePress.

Regards,
Tobias

Thread Starter stockuper
(@stockuper)

6 years, 9 months ago

Thanks for your help. No wonder you have 3512 stars. I owe you support. Thanks.

Plugin Author Tobias Bäthge
(@tobiasbg)

6 years, 9 months ago

Hi,

no problem, you are very welcome! 🙂 Good to hear that this helped!

Best wishes,
Tobias

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Incorrect sorting of numbers’ is closed to new replies.

Tags