Issue 24526

Summary: page format changes modify all sheets in a workbook
Product: Calc Reporter: sparg <sparg>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
2 sheets requiring different print scaling none

Description sparg 2004-01-18 13:31:17 UTC 
I have 2 sheets in a workbook: 1 which will fit on 1 page wide by 1 page tall; 
a second which fits on 1 wide by 2 tall. If I focus the first sheet then enter 
page format and select fit printout on 1 page; then focus the second sheet and 
select fit printout to 2 pages it does not work. The last selection applies to 
both sheets.  
 
This make no sense as differently sized sheets require different formatting. 
Applying page formatting to the entire document is not what users expect i.e. 
unintuitive.  
 
It is possible to achieve different format per sheet by creating a different 
page style in the stylist for each sheet, but this is slow and unintuitive. 
Few people would realise that this is possible and would expect page format 
settings to be alterable for each sheet from the page format dialog. Printing 
shouldn't be such a struggle.
Comment 1 sparg 2004-01-18 13:50:14 UTC 
Created attachment 12552 [details]
2 sheets requiring different print scaling
Comment 2 frank 2004-01-19 10:15:32 UTC 
Hi,

I have to set this to wontfix because OOo Calc is in it's layout caqpabilities
slightly different but in opinion more powerfull than our competitors. So there
is no chance to change this.

Frank
Comment 3 frank 2004-01-19 10:16:00 UTC 
closed wontfix
Comment 4 sparg 2004-01-19 12:42:41 UTC 
There is a way to have the best of both worlds: 
 
Each sheet could have it's own style created by default, named sheet1_style 
sheet2_style etc. The page format dialog works on the current sheet's style so 
changes would only affect that sheet and any others set to the same style. 
 
There would still be a default style and a user could set all his sheets to 
the default style if he wants i.e. no change to current functionality at all. 
 
I agree that the style mechanism is very good. A unique style per sheet would 
give ease of use and full functionality. 
 
Also it would be good to allow the sheet's style to be changed from the 
Organiser tab in Page format. This would make the links between styles and 
page formatting much more obvious. Maybe with a note about needing to use the 
stylist to create/change styles, or a button to launch it?
Comment 5 frank 2004-01-19 15:49:19 UTC 
Hi Falko,

please comment.

Frank
Comment 6 frank 2004-05-03 15:15:20 UTC 
Bettina,

I think you should comment on this.

Frank
Comment 7 bettina.haberer 2010-05-21 15:17:02 UTC 
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".