Created attachment 134747 [details]
Spreadsheet Page Layout view example - Clear space separation betwen pages - Shortuct icons
As an enhancement request, would it be possible to add a new pre-defined view of a spreadsheet in Calc named Page Layout in addition of Normal and Page break?
The idea would be to show pages with clear space separation between them on the screen in a similar way MS Excel does... not just thin black lines that are difficult to see and make difficult to identify page separation when tables are bordered.
Also Excel allow to quickly switch between views via shortcut icons near the Zoom bar at the bottom right of the window. It is quite handy may be a nice plus in LibreOffice for easy migration :-)
See more visual details attached.
Hope that help and would be easy enough to implement to make it available soon :-)
What's wrong with the Print Preview (under file) where you get more or less exactly what you are asking for?
File > Print Preview is simply not the same thing as View > Page Layout... in the second case you are still in normal edit mode and able to modify cells. Basically edit document in Page Layout view...
Hope that clarifies enough.
So in other words you want to modify a spreadsheet that is visually split into printable sections. Why? I mean what is the use case and the advantage of this beyond 'nice-to-have'.
The print previews do render the sheet canvas with header/footer with style and theme applied, but it is not an edit mode. Even though Print Preview mode does provide for margin adjustment to show more or less of the sheet in the print result--it does not allow editing of the data sheets. It also is limited to a single page result, no multi-page or book layout view is available here or in an edit mode.
Currently we have just the two editing modes in calc--Normal and Page Break. They do not provide any visual editing of the header or footer in context. Header/footer edits of which must be done from the Insert > Headers and Footers... dialog that then draws in the Page style (Default, or Report).
Assume this would require a fair bit of effort. For devs can the internals of the sheets for handling things like pivot tables even be reworked for visual editing of the result?
Even if technically feasible, kind of seems the additional visual edit mode would be useful for novice users but not as a primary work flow for more accomplished spreadsheet users.
Adding the view mode(s) to the status bar would be visual candy, but not unreasonable if this additional edit mode were implemented.
All things considered, seems like a valid enhancement if a bit ambitious, but certainly not a priority.
We talked about this idea in the design meeting. While there are many obstacles like pivot tables the idea to have a WYSIWYG edit mode for beginners is tempting. It should work like the standard mode in Writer, and pivot table/charts could just keep the current layout.
(removing needsUX for the idea, keeping the list in CC in case of implementation questions)
*** Bug 112853 has been marked as a duplicate of this bug. ***
Please add keyword 'needsUXEval' and CC 'email@example.com' if input from UX is needed.