Bug 45283 - Worksheet Manager
Summary: Worksheet Manager
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Calc-Enhancements Sheet
  Show dependency treegraph
Reported: 2012-01-26 12:40 UTC by Albert Thuswaldner
Modified: 2018-05-29 03:33 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Crude mock-up of the proposed Worksheet Manager (94.49 KB, image/png)
2012-01-26 12:40 UTC, Albert Thuswaldner
The worksheet Manager of Gnumeric (54.36 KB, image/png)
2012-01-26 12:41 UTC, Albert Thuswaldner

Note You need to log in before you can comment on or make changes to this bug.
Description Albert Thuswaldner 2012-01-26 12:40:41 UTC
Created attachment 56201 [details]
Crude mock-up of the proposed Worksheet Manager

I think there is room for improving the means by which you can manage worksheets in LO calc. Inspiration can be drawn from Gnumeric which seems to have the most advanced tool to manage worksheets of all the spreadsheet applications.  

see attachment: gnumeric-sheet-manager.png

I would suggest a different approach than above, and instead draw inspiration form the "Slide Sorter", found in LO Presenter, for the general UI layout of the worksheet manager. This would greatly improve the usability when copying/moving work sheets around, which is horrible at the moment imho. 

Besides this it would give a great overview of work sheets (including their attributes like protected or hidden), where you simply can scan through the thumbnails to navigate between them. 

Manual sorting the slides would obviously be done by drag and drop, but with the the worksheet manager you would also be able to sort the sheets ascending/descending by name.

Suggested actions to be included in the worksheet manager:
- Rename work sheet (including batch rename)
- toggle hidden/show
- toggle protected/unprotected
- remove sheet
- duplicate(copy) sheet 
- insert new sheet
- change tab color

These actions will be accessible through a dedicated toolbar and right-click menu. What action that goes where is still to be defined.

I have made a mock-up on how I imagine the worksheet manager to look.

see attachment: LO-sheet-manager-mockup.png

I will start working on the sorting stuff first (ascending/descending). The UI stuff obviously needs to be discussed/refined.
Comment 1 Albert Thuswaldner 2012-01-26 12:41:27 UTC
Created attachment 56203 [details]
The worksheet Manager of Gnumeric
Comment 2 retired 2014-01-08 09:21:17 UTC
This bug hasn't seen any action. Freeing this bug and switching ASSIGNED to NEW

Albert if you are still working on this, please re-assign yourself.