Tablepress shortcode not sort equations

  • Resolved jongraphics

    (@jongraphics)


    11 years, 1 month ago

    Ive tried to the shortcode sorting plugin. Works well, except it seems to sort my equations before the equations happen.

    I have a winning percentage that I want to sort by and it wont do it.

    For now I just have it sorting by wins but if teams dont play the same amount of games then it could make it confusing.

    The link to the page is http://westerlyvba.com/standings/

    The short code i want to use is [table id=2 row_order=”sort” row_order_sort_column=”A” row_order_sort_direction=”DESC” /]

    Like I said it works if its just numbers, but because I have a formula calculating the numbers in first row it sorts it by the formula letters and not the end result.

    Thanks.

    https://ww.wp.xz.cn/plugins/tablepress/

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

    (@tobiasbg)

    11 years, 1 month ago

    Hi,

    thanks for your post, and sorry for the trouble.

    Are you sure that you are using the latest version of TablePress (1.5.1) and of the Row Order Extension (1.2)? With those, the sorting is done after the formulas are evaluated.

    Regards,
    Tobias

    Thread Starter jongraphics

    (@jongraphics)

    11 years, 1 month ago

    Yes. I do have both and updated. I can send you login so you can check code of you want.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    11 years, 1 month ago

    Hi,

    yes, then I’d like to take a look at this. Could you therefore please create a temporary admin account for me and send me the details via email (the address is in the main plugin file “tablepress.php”)? That way, I can investigate this directly. Thanks!

    Regards,
    Tobias

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    11 years, 1 month ago

    Hi,

    thanks for your email with the login details. I was able to log in and changed the used Shortcode to

    [table id=2 row_order="sort" row_order_sort_column="A" row_order_sort_direction="DESC" /]

    (you had C as the value for the row_order_sort_column parameter).
    After that, everything appears totally fine for me. The table is sorted for the calculated values in the first column.

    Regards,
    Tobias

    Thread Starter jongraphics

    (@jongraphics)

    11 years, 1 month ago

    That is how I had the code to start with. Changed it to C because the formulas in A would get orginized before they are calculated.

    If you look on the site it is out of order, it reads…

    .83
    .33
    .5
    0

    It needs to be…
    .83
    .5
    .33
    0

    so we know how is in first place by winning percentage.

    thanks for any future help.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    11 years, 1 month ago

    Hi,

    argh, indeed. I guess the sorting in my head is broken 🙂
    I’ll take another look! Sorry for the confusion.

    Regards,
    Tobias

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

The topic ‘Tablepress shortcode not sort equations’ is closed to new replies.