Created attachment 204657 [details]
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.