Bug 148712 - Show the count of hidden sheets in the Calc spreadsheets statusbar
Summary: Show the count of hidden sheets in the Calc spreadsheets statusbar
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Statusbar
  Show dependency treegraph
 
Reported: 2022-04-21 15:23 UTC by Jeff Fortin Tam
Modified: 2023-04-25 19:32 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.