Download it now!
Bug 109230 - Implement a page layout mode for Calc to edit headers, footers and sheet data in visual context
Summary: Implement a page layout mode for Calc to edit headers, footers and sheet data...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Keywords: needsDevAdvice
Depends on:
Blocks: Calc-Header-Footer
  Show dependency treegraph
Reported: 2017-07-20 11:38 UTC by Richard Léger
Modified: 2020-03-09 13:28 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

Spreadsheet Page Layout view example - Clear space separation betwen pages - Shortuct icons (42.10 KB, image/png)
2017-07-20 11:38 UTC, Richard Léger

Note You need to log in before you can comment on or make changes to this bug.
Description Richard Léger 2017-07-20 11:38:12 UTC
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 :-)

Comment 1 Heiko Tietze 2017-08-08 12:03:44 UTC
What's wrong with the Print Preview (under file) where you get more or less exactly what you are asking for?
Comment 2 Richard Léger 2017-08-08 13:50:49 UTC
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.
Comment 3 Heiko Tietze 2017-08-08 14:28:03 UTC
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'.
Comment 4 V Stuart Foote 2017-08-08 15:40:26 UTC
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.
Comment 5 Heiko Tietze 2017-08-10 15:23:19 UTC
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)
Comment 6 Xisco Faulí 2017-10-03 08:06:50 UTC
*** Bug 112853 has been marked as a duplicate of this bug. ***
Comment 7 Xisco Faulí 2020-03-09 13:28:23 UTC
Please add keyword 'needsUXEval' and CC '' if input from UX is needed.