Ordering sheets within Spread object

[olivermonaco]

I've gotten a lot of utility from this package, but I couldn't find that there was a method for reordering or reindexing spreadsheets within a Spread object. I have tried assigning back the Spread.sheets in a new order to the Spread.sheets attribute, but get a can't set attribute error. Would this be a new feature request, or am I missing something?

Thank you

[aiguofer]

Thanks for reporting @olivermonaco. Indeed this is currently not possible, but sounds like a good addition!

I think that setting Spread.sheets is probably a good way to implement this, but there probably needs to be some checks to ensure that all sheets are present when setting the order.

I'll see if I can find some time this week to implement this, or a PR would be welcome!

For anyone that can help tackle this, I think what would be required is to add a @sheets.setter method that makes a batchUpdate request, that does a updateSheetProperties for each sheet and updates the index.