https://bugs.documentfoundation.org/show_bug.cgi?id=172868
Bug ID: 172868
Summary: Calc: UI: WORKSPACE LAYOUT: Save and restore
document-specific workspace layouts (multiple windows,
sheets, positions and zoom, monitors)
Product: LibreOffice
Version: 26.2.4.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Many Calc users work with large spreadsheets using multiple document windows,
often distributed across two or more monitors.
Currently, Calc stores the active sheet, cursor position, zoom level and some
view settings, but it does not restore the complete workspace.
When reopening a document, users must manually:
- create additional windows
- move each window to the desired monitor
- resize the windows
- select the appropriate sheet in each window
- restore their working layout
This becomes repetitive and time-consuming for documents that are used
regularly.
# Proposed Feature #
Allow Calc to save and restore a document-specific workspace layout.
Possible menu entries:
View
├── Save Workspace
├── Restore Workspace
└── Manage Workspaces...
Optional document setting:
Restore workspace automatically when opening this document
# Information to store #
For every document window:
- displayed sheet
- zoom factor
- scroll position
- active cell
- frozen panes / split view
- window size
- window position
- maximized/fullscreen state
- monitor identifier (when available)
# Storage #
The workspace information could be stored inside the ODF document (for example
in settings.xml) as document-specific view information.
This would keep the feature portable together with the document.
# Platform Behaviour #
If the original monitor configuration is unavailable:
- place windows on the primary monitor
- preserve as much of the layout as possible
- restore all remaining view settings
# Future Extensions #
Support multiple named workspaces, for example:
- Data Entry
- Analysis
- Dashboard
- Printing
similar to workspace concepts available in IDEs and CAD applications.
# Benefits #
- Significant productivity improvement for advanced Calc users
- Especially useful on multi-monitor systems
- No impact on existing users unless the feature is used
- Fully backward compatible
- Fits naturally into Calc's existing document view model
# Example / Use-Case: #
A financial workbook is opened in four windows:
- Window 1: Dashboard (left monitor)
- Window 2: Raw Data (right monitor, top)
- Window 3: Charts (right monitor, bottom)
- Window 4: Pivot Tables (secondary monitor)
Reopening the document restores this complete workspace automatically.
Actual Results:
always manually to open the same worksheets in new windows (see description)
Expected Results:
useful enhancement (see description)
Reproducible: Always
User Profile Reset: No
Additional Info:
Thank you very much in advance for considering and hopefully realising this
feature as it would be very handy and useful for me and probably many others
working frequently with the same set of spreadsheets (in the same document).
--
You are receiving this mail because:
You are the assignee for the bug.
