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

    (@meitar)

    The table does display the data, it’s just that your spreadsheet is seriously malformed. Scroll down in your spreadsheet past “bin 60” and you’ll see lots and lots of mostly-blank rows. Those rows are what the table is being presented as because it’s sorting alphabetically by the first column. When the first column is empty, the empty string ("") is lexicographically ordered before any other data, such as the letter A. That is, “” comes before “A” when sorting.

    I would strongly suggest you learn more about spreadsheets, because the way you’re using them right now is not what they were designed for. You can start at the free YouTube videos produced by ExcelShir.com.

    Thread Starter Studio239

    (@studio239)

    The client created the spreadsheet and needs to keep those empty bins where they are. They just want to display the spreadsheet as-is, without sorting. Can the plugin not do this? Is there a work-around, like adding a dash or zero in the empty fields? Thank you!

    Plugin Author Meitar

    (@meitar)

    Sorting is added by the DataTables enhancements. If you want to disable that, use the no-datatables class as described on this plugin’s front page:

    By default, all tables are progressively enhanced with jQuery DataTables to provide sorting, searching, and pagination functions on the table display itself. If you’d like a specific table not to include this functionality, use the no-datatables class in your shortcode. For instance:

    [gdoc key="ABCDEFG" class="no-datatables"]
    Thread Starter Studio239

    (@studio239)

    That worked. Thank you so much!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Table cycles through 3 different layouts on page load’ is closed to new replies.