Group sheets into “books”
that way a user can have several sheets in a book but also multiple books with multiple sheets.
Basically multiple lists of spreadsheets
Could you please elaborate more: reopen your question and give more details.
Given that nowadays all computers can display several windows simultaneously, what is the advantage of your proposal over several spreadsheets windows coexisting on the screen?
Give use case examples.
Also note contributors on this site are not developers, only mere users like you. Any bug or feature request should be filed on TDF Bugzilla.
Sounds like a “book” is a file with several tabs?
I think OP is asking for a tree-like organisation of tabs. At first level we have the “books”. After one “book” is selected, this tab expands to a list of spreadsheets inside this book. However I don’t see why this should be limited to a single level. But, OP should tell what happens to non-selected first level tabs. Do they temporarily disappear? Then how to we go back to the previous level? How do we “close” again the expanded level?
If the question is limited to a single level, it is simpler to open simultaneously several files and give the focus to one window when needed.
Yeah, basically allow a single file to have multiple tab groups for organization.
I’d rather not a a separate file for each collection of data. The only other solution would be to use a database, and I really don’t need that functionality.
Or is there another way to organize these to have collections of sheets in a single file that I can select between?
You could achieve what you want using the existing functionality. After all, today a spreadsheet sheet is large enough to hold lots and lots of data. Just think of a convenient layout and create it. For example, one sheet is one organization, the sheet contains all the data of one organization; to display or hide various data within the sheet, you can use, for example, a grouping mechanism.
Or vice versa - each sheet is some kind of data set (for example, Report 3rd quarter 2023), and in this sheet there is data from all organizations - the selection of any of them is carried out using a filter.
Of course, sooner or later you will encounter problems - for example, slow loading and saving of this spreadsheet when the volume of data significantly exceeds the technical capabilities of your computer.
But since you say that “solution would be to use a database, and I really don’t need that functionality”, then this is your choice and only your choice.