Below the tab bar representing the visible sheets in a spreadsheet, Calc has a statusbar with various pieces of information, starting with "Sheet 4 of 10". As there is no visual indication of hidden sheets otherwise, I would like Calc to clearly indicate that there are hidden sheets, without the user needing to manually count sheets (especially since that's not really easy to do when sheet tabs scroll, so you often can't see them all at once anyway). This could be done with a string like this in the statusbar, when there are hidden sheets (i.e. their number is not zero): Sheet %d of %d (%d hidden) For example: Sheet 4 of 10 (4 hidden)
With menu Sheet > Show sheet or with item 'Show sheet' from context menu, you get a list of all hidden sheets. I think, we should not use further space in the status bar for this info. Sheets are usually hidden from ordinary users on purpose. It is counterproductive to make them explicitly aware of hidden spreadsheets.
(In reply to Regina Henschel from comment #1) > With menu Sheet > Show sheet or with item 'Show sheet' from context menu, > you get a list of all hidden sheets. I think, we should not use further > space in the status bar for this info. > > Sheets are usually hidden from ordinary users on purpose. It is > counterproductive to make them explicitly aware of hidden spreadsheets. I appreciate this view.
The topic was on the agenda of the design meeting. While such a string in the status bar takes some space which many users probably prefer to have for sheet tabs the idea is to place an icon-only info button next to the "add sheet" button that shows some information about the document in a tooltip-like / balloon. It has the charme that we can give more feedback on the current document in the future such as size on hard-disk, number of rows/cells, or whatever users are interested in.