Issue 24526 - page format changes modify all sheets in a workbook
Summary: page format changes modify all sheets in a workbook
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-01-18 13:31 UTC by sparg
Modified: 2013-02-07 22:43 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

2 sheets requiring different print scaling (7.04 KB, application/vnd.sun.xml.calc)
2004-01-18 13:50 UTC, sparg
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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. 
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

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.

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.

Comment 6 frank 2004-05-03 15:15:20 UTC

I think you should comment on this.

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".