Bug 117316 - Different "View" modes for Calc sheets?
Summary: Different "View" modes for Calc sheets?
Status: RESOLVED DUPLICATE of bug 52133
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Enhancements
  Show dependency treegraph
 
Reported: 2018-04-28 12:39 UTC by redirect303
Modified: 2018-04-30 17:31 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description redirect303 2018-04-28 12:39:02 UTC
Description:
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.


Actual Results:  
View Mode is applied to all Sheets in a Calc Document the same

Expected Results:
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.


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:56.0) Gecko/20100101 Firefox/56.0
Comment 1 Thomas Lendo 2018-04-29 17:27:54 UTC
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.
Comment 2 redirect303 2018-04-29 18:22:16 UTC
(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.
Comment 3 m_a_riosv 2018-04-29 22:10:01 UTC
I think this was answer somewhere.

It's possible to create Menu/Window/New, and have a different view for every one.
Comment 4 redirect303 2018-04-29 23:17:03 UTC
(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
> one.

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).
Comment 5 Thomas Lendo 2018-04-30 17:31:53 UTC
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 ***