Currently if one changes the view mode (View -> Normal/PageBreak), this change will apply to all sheets in a Calc document. Would it be possible to define the View mode separately for each sheet? There is a reason for this:
Let's assume the user builds a page to be printed and it requires to see it in Page Break mode, so it can better format it. At the same time, on separate sheets other things are happening (helper tables/formulas, etc) which do not require printing, but where a normal tabular view would be more beneficial. As it is now, the user would have to permanently switch between the two view modes, based on the needs, which is not very productive.
This feature could be added as an option, so if some users wish to have the setting applied to the entire workbook, that would be their choice, but also for other users who need different views on different sheets should be able to do it so.
Thanks for your attention in this matter.
View Mode is applied to all Sheets in a Calc Document the same
View Mode (View Menu -> Normal/Page Break) should be applied separately to each sheet in the document, so different sheets could have different view modes.
User Profile Reset: No
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:56.0) Gecko/20100101 Firefox/56.0
This could be realized with a new checkbook in the Calc options dialog as it was done with the zoom synchronization through all sheets (Tools > Options... > LibreOffice Calc > View > Synchronize sheet). Or the existing checkbox can be enhanced to do what is mentioned in this bug report as it has a very generous name in the options dialog.
(In reply to Thomas Lendo from comment #1)
> This could be realized with a new checkbook in the Calc options dialog as it
> was done with the zoom synchronization through all sheets (Tools >
> Options... > LibreOffice Calc > View > Synchronize sheet). Or the existing
> checkbox can be enhanced to do what is mentioned in this bug report as it
> has a very generous name in the options dialog.
I support this solution.
Thank you Thomas for your suggestion. Let's hope it will be heard and implemented soon.
I think this was answer somewhere.
It's possible to create Menu/Window/New, and have a different view for every one.
(In reply to m.a.riosv from comment #3)
> I think this was answer somewhere.
> It's possible to create Menu/Window/New, and have a different view for every
This is not a solution. It just creates a new Window, which requires the user to switch between windows. Switching between sheets is a quick action and people who use Calc often are used to it. Trying to introduce a workaround with a second window would just make things harder for the user. So hard that it won't be worth the effort eventually. It's simple when you have only two windows open, but most people have many programs open at once and scrolling between open windows won't make it easier.
The fix here is to introduce a native feature that allows two separate sheets in the same document to have different styles. It's not difficult to do (zoom can be synchronized or separate for each sheet, that can be achieved for View Mode too).
Bug opener: If you want discuss about this, please write comments in the older bug.
*** This bug has been marked as a duplicate of bug 52133 ***