Bug 148712

Summary:	Show the count of hidden sheets in the Calc spreadsheets statusbar
Product:	LibreOffice	Reporter:	Jeff Fortin Tam <nekohayo>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	buzea.bogdan, cno, erack, mentoring, rb.henschel, xiscofauli
Priority:	medium
Version:	Inherited From OOo
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	86066

Description Jeff Fortin Tam 2022-04-21 15:23:50 UTC

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)

Comment 1 Regina Henschel 2022-05-09 12:06:50 UTC

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.

Comment 2 Cor Nouws 2022-05-10 09:21:14 UTC

(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.

Comment 3 Heiko Tietze 2022-05-12 08:36:07 UTC

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.