Google Sheet Order stops plugin to work

  • Resolved horgster

    (@horgster)


    6 years, 6 months ago

    Hello @meitar

    Great plugin you have made here, love it!
    I think I have found a little bug here, that you might want to take a look at.

    Lets say you have an Google Spreadsheet, with two “sheets”, A and B.
    By default, first sheet, in this case Sheet A, has the GID=0.
    example: https://docs.google.com/spreadsheets/d/xxxx/edit#gid=0

    Sheet B, has an random GID=2934726
    example https://docs.google.com/spreadsheets/d/xxxx/edit#gid=2934726

    If you open the Google Spreadsheet, the order of the Sheets, is like this:
    Sheet A, Sheet B, Sheet C and so on.

    IF you move “Sheet A” in the end of the sheet list or in the middle, the plugin stops
    when calling GID=0.

    If you open the URL to “sheet A” with GID=0, notice that Google first display “Sheet B” first (as this sheet is the first sheet in the spreadsheet) and then moves over to Sheet A after the page has finished loading. I think this is the issue to why my plugin crash.

    If i just move GID=0 as the first sheet, it works.
    if I move the GID=0 sheet as seccond sheet in my spreadsheet, the plugin crash and no data is displayed.

    is this something you can fix?

    Best Regards
    Horgster

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

    (@meitar)

    6 years, 6 months ago

    I am not sure that this is a bug. If you are calling the sheet with ID number 0 but then change this ID on the Google side, you cannot expect the plugin to be aware of this until you inform it by changing your shortcode appropriately.

    If the ID has not changed and is still 0 but the wrong sheet is displayed (rather than no sheet), it is possible that the bug is currently on line 385 in getSpreadsheetUrl. If so, please consider submitting a formal bug report on GitHub. Thanks.

    Thread Starter horgster

    (@horgster)

    6 years, 6 months ago

    Hey Meitar!

    Thanks for your reply.
    I am not changing the sheet ID number from 0 to another value.
    But I am only “moving” the order of the sheets inside the spreadsheet.
    The order of the sheet-order in the bottom of the google sheet 😉
    https://snipboard.io/0SBC1s.jpg

    If the sheet with GID value 0 is not the “First” sheet in the document, then the error happens. So if I move Sheet A, to be in the end, and Shit B appears first, the plugin stops and nothing is displayed on the screen 🙂

    This happens only with ID 0. With other ID´s it dosen´t matter how the sheets are arranged.

    Do you see what I am trying to say?

    Cheers,

    Horgster

    Plugin Author Meitar

    (@meitar)

    6 years, 6 months ago

    Yeah, that does sound like a bug. I’m not certain when I’ll have time to patch it but have made a note of the issue on the project issue tracker. Thanks.

    Thread Starter horgster

    (@horgster)

    6 years, 6 months ago

    You are most welcome.

    If you make an google spreadsheet, re-arrange the sheets in your document.
    Enter the URL with GID=0. If the spreadsheet contains lots of rows, you will notice by a short blink of eye, that wrong sheet is displayed first and not the sheet with GID=0. When the page is loaded, then GID=0 is displayed.

    Maybe it has something do what happens on google API side?

    Check it out, then you might see the reason for the bug 🙂

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

The topic ‘Google Sheet Order stops plugin to work’ is closed to new replies.