https://bugs.documentfoundation.org/show_bug.cgi?id=169984
Bug ID: 169984
Summary: [Feature request] CALC - Display multiple sheets on
one page
Product: LibreOffice
Version: 25.8.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 204657
--> https://bugs.documentfoundation.org/attachment.cgi?id=204657&action=edit
CALC - feature request - display multiple sheets on one page
SUMMARY
The idea is to be able to display multiple Calc sheets in one area ("group") as
if you had multiple files open and placed them on your screen
CURRENT STATE
Right now you can only display one sheet per file at once. Often this is
enough, but not always.
I know that there is the Pivot Table
(https://help.libreoffice.org/latest/en-US/text/scalc/guide/datapilot.html),
but this is not what I'm suggesting.
SUGGESTED RESULT
The user would be able to create a group that is basically an empty page.
Onto this page the user could drag multiple sheets and resize and position them
however they like. The group view would behave as if the user was working with
multiple files on a desktop.
The user would be able to edit the sheet content inside the sheet itself as
well as from within the group as the sheet within the group would just be a
resized version of the sheet itself.
FUNCTION and IMAGE DESCRIPTION
* The user would be able to create a new group that is empty by default
* The background of the empty group is some solid colour (eg. grey, however the
colour does not really matter)
* The sheets can be placed into the group by dragging it from the line at the
bottom and dropping them in the group [Alternative: Right click + 'add sheet'
menu entry]
* A sheet can be removed by dragging it to the waste basket at the bottom left
(maybe a different symbol is better to make clear the sheet is not deleted from
the file itself) [Alternative: Right click + 'remove sheet from group' menu
entry)
* The sheets can be moved around freely like a window on a desktop
* The sheets can resised freely like a window on a desktop
* The sheets can snap together (yellow and green table, black line in the
middle), but can also positioned freely within the group (red).
* When two sheets are snapped together they have a black bar that can be used
to resize them by dragging on the line (like a tiling window manager; for an
example in other software see blender)
* The sheets have a border to better indicate where their borders are.
* If the sheet has an assigned colour, the base line as well as the outline is
coloured. The outline is slightly darker in this image on purpose to have a
little bit stronger separation from the coloured bar at the bottom.
* The group would be separated from the tables with a visual separator (here I
used two black lines in between them)
* The group has all included sheets listed as stripe about the group name (I am
also fine with any other solution, probably even with having no list of sheets
if they are named)
* In my example the group sheet list has a border around it in the colour of
the group.
* Between the group and the list of sheets there is a separator to have a
visual separation (here it's a dashed black (separator colour) and blue (group
colour) line.
EXPECTED BENEFITS
I had the idea when I was working on a sheet where there is data with date
information that expands downward and is added on daily.
I am collecting overview information in a different part of the same sheet.
Because the data is expanded downward, I move the overview information downward
as well.
I would like to have the overview information stay in one place, but be able to
scroll the date information list independent from it.
I do not want to move the overview information to a different sheet as having
the information right next to each other makes future planning much easier.
The expected benefits would thereby be to have more information on the same
screen space and thereby have a better use of 'screen real estate'.
NOTES
I could not find any information about such a feature online. There were some
questions on https://ask.libreoffice.org, but their goal was not what I
suggest. I also wasn't able to find a feature request with such an idea.
The attached image is not meant as final look, but more of a visual suggestion
/ design study about how it could look like. It's therefore meant as
startingpoint for a discussion.
--
You are receiving this mail because:
You are the assignee for the bug.
