Support » Plugin: Inline Google Spreadsheet Viewer » Sort Ordering by First Character, not total Value

  • Resolved Jon Griffith

    (@arretx)


    I have one of my tables sorted by the 3rd column descending. It’s sorting like this:

    60
    55
    54
    52
    5
    5
    45
    44
    4
    38
    37

    Whereby it’s sorting by the first character of the number instead of the value of the number. The 5’s should be WAY down the list.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Meitar

    (@meitar)

    If this sorting is happening by DataTables, be sure you’ve set the column type appropriately.

    Thread Starter Jon Griffith

    (@arretx)

    Yeah, so that’s Chinese to me, but I do appreciate it. Is there a more user friendly guide to shortcodes for this plug-in? This is a very confusing plugin.

    Plugin Author Meitar

    (@meitar)

    Not beyond the FAQ and its links. This plugin is a very thin wrapper around the DataTables and Google APIs, so most relevant documentation are theirs.

    Thread Starter Jon Griffith

    (@arretx)

    OMG Did I get it right?

    datatables_columns='{ “type”: “num”, “targets” : 2 }’

    Sets column 3 to type num? The sorting seems to be working now.

    Talk about cryptic.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Sort Ordering by First Character, not total Value’ is closed to new replies.