timeboxed

Hey Meitar,

Thanks a lot of for the in-depth answers! Sadly, I just can’t figure it out.
It’s OK though, I worked around be reworking the sheet, reducing it to two columns and sorting it manually.

Just for future people who find this via google. This one led to a deadlock, endlesss loading-animation, both with and without giving a specific query (A to D):
[gdoc use_cache=”no” key=”https://docs.google.com/spreadsheets/d/1YufvZqgD8aLhbJQM6H5d3BezwzWHWgm-NpE9udHMTVI/edit#gid=109303573″ http_opts='{}’ datatables_order=’%5B%5B 1, “asc” %5D%5D’]

This one just ignored the order-by and sorted by the (only visible) column A:
[gdoc use_cache=”no” key=”https://docs.google.com/spreadsheets/d/1YufvZqgD8aLhbJQM6H5d3BezwzWHWgm-NpE9udHMTVI/edit#gid=109303573″ query=”SELECT A,B order BY D”]

And so I sorted the table manually and did this:
[gdoc class=”no-datatables” query=”select A, B” key=”https://docs.google.com/spreadsheets/d/1YufvZqgD8aLhbJQM6H5d3BezwzWHWgm-NpE9udHMTVI/edit#gid=109303573″%5D

This is not as beautiful as this plugin can be but it works for now and I expect that the sheet and its use will change over time anyway.

I thank you a lot for the input, I already learned quite a bit here! In a few weeks I’ll revisit your post and spend a few more days experimenting. Should I find something new then I will update the thread!

Thanks,
Georg

Thank you for the reply!
Sadly, simply copy/pasting it leads to an endless page load. I figured out that it is because I can only sort on columns which are queried as well.

This means that I have altered it to:
[gdoc key=”https://docs.google.com/spreadsheets/d/1YufvZqgD8aLhbJQM6H5d3BezwzWHWgm-NpE9udHMTVI/edit#gid=109303573″ query=”select A,B,D” use_cache=”no” http_opts='{}’ datatables_order=’%5B%5B 2, “asc” %5D%5D’]

This now gives the correct order and shows the columns – but I can’t hide the “D” column.
Even adding in CSS a .col-3 { display: none;} does not change it. I suspect this is because, again, the table is too wide and the column I want removed is hidden in the green (+).

I think I can work around this by changing the table structure but I’m not yet 100% sure. Should you have more ideas, I’m very open to them ??

Thanks a lot already, you helped me a great lot forward in understanding how this plugin works.

Cheers,
Georg