Disable Sorting in Google Sheets Widget

  • 1
  • Question
  • Updated 4 years ago
  • Answered
Is it possible to disable sorting in the Google Sheets widget? I have a sheet that I want to display as it is written, not resorted alphabetically. Thank very much for any help!
Photo of Matt Liddle

Matt Liddle

  • 90 Points 75 badge 2x thumb

Posted 4 years ago

  • 1
Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
The Spreadsheet Gadget doesn't sort the columns.  Are you referring to the Directory Gadget?  If so, then one of the columns will be sorted (by default it is the first one). Clicking on the header on the Display will change the sort - when Navigation is set to top/bottom/none.
Photo of Matt Liddle

Matt Liddle

  • 90 Points 75 badge 2x thumb
Actually the Google Sheets Gadget is sorting alphabetically on the first column. Any ideas on what may be causing this behavior? Thanks!
Photo of Matt Liddle

Matt Liddle

  • 90 Points 75 badge 2x thumb
It seems the problem was my own error. I had failed to click save before attempting to view my changes. Oops!
Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
Can you verify that the spreadsheet itself isn't sorted on the first column?
Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
Ah, thanks for the update! Good to hear that the issue was found and corrected.