Select column on number order

  • Resolved shuntink

    (@shuntink)


    7 years, 8 months ago

    Hi,

    I have installed TablePress with the DataTables ColumnFilterWidgets function.
    We have imported an excel, worked great!

    But there is a column that has numbers in them. When I click on the top to filter the column should filter from 0 to 1000000 (smallest number to largest number).
    Now we see that the column does filter but the filter only sees the first number I think. So I get an sorting like 2, 28745, 321, 35, 450 and it should look like 2, 35, 321, 450, 28745 (from small to large).

    Can you help me solve this? Or can somebody tell me how to fix this?
    Hope to hear from you soon.

    Regards, Sanne

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 8 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    Just to be sure, you mean the sorting in the actual dropdown, or in the table?

    I have heard of such a wrong order in the actual dropdowns before, but unfortunately, I don’t know a solution to that, as I’m not the developer of the JavaScript that’s behind this. I only packaged it to be a TablePress Extension.

    Regards,
    Tobias

    Thread Starter shuntink

    (@shuntink)

    7 years, 8 months ago

    Hi,

    Thank you for getting back to me. Yes that is wat I ment, the sorting in the table.

    Regards, Sanne

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 8 months ago

    Hi,

    Can you please post a link to the page with the table where this problem happens, so that I can take a direct look? Thanks!

    Regards,
    Tobias

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 8 months ago

    Hi,

    thanks for that!

    I assume that you are talking about the “Distribution” and “Frequency” columns, right? The problem with the sorting here is that this column does not contain plain numbers. There are also empty fields (which should be ok), but also text (like “Unknown” and “Not applicable”). Unfortunately, as these are not numbers, they turn the sorting mode into text sorting, which results in this problem.

    Regards,
    Tobias

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

The topic ‘Select column on number order’ is closed to new replies.