Issue 42575 - Per-page format setting
Summary: Per-page format setting
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0
Hardware: All All
: P4 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: ms_interoperability, rfe_eval_ok
Depends on:
Reported: 2005-02-11 15:26 UTC by dieeasy
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description dieeasy 2005-02-11 15:26:03 UTC
I noticed that when i set a page format on a sheet in a spreadsheet the change
applies to all sheets. I'd like to be able to format different sheets in
different ways so I can, for example, print various sheets in sequence, and one
i s A4 and goes to tray 1 on my printer with draft setting, while another goes
to tray 2, being an A3 page and needs quality setting...

hope I've been clear and I'm not duplicating something.

Good work! -> to all of you...
Comment 1 frank 2005-02-11 15:49:43 UTC

you can do this by using page styles. Open the Stylist (F11), select pagestyles
and create a new one. Go to the sheet you want this style applied to and double
click on the style name.

Please also have a look at the help files regarding styles and it's use in OOo.

Comment 2 frank 2005-02-11 15:51:24 UTC
About different printer settings I'm not sure that this is achievable. But a
solution could be print ranges.

Comment 3 bettina.haberer 2005-02-14 10:45:15 UTC
This enhancement should not get closed.
Comment 4 bettina.haberer 2005-02-14 10:54:30 UTC
This issue calls for the ability to format each sheet e.g. for printing. Good
idea; A competitors already offers this function.
Comment 5 dieeasy 2005-02-14 14:38:23 UTC
I think this functionality should not stop where for example Microft Office
stops, but add something like being able to apply some formatting to all the sheets.

What I mean is:

1. I format different sheets with different styles and set them to print in
different ways
2. say now I want to set all of them to A4, or draft or whatever
3. being able to apply some setting/s to all sheets would be great!

Is this too much or is it going to be in the wish list? thanks!
Comment 6 bettina.haberer 2005-02-18 12:20:41 UTC
Set target and updated status.
Comment 7 ace_dent 2008-05-16 00:39:08 UTC Issue Tracker - Feedback Request.

The Issue you raised is currently assigned to 'Requirements' pending review, but
has not been updated within the last 3 years. Please consider re-testing with
one of the latest versions of OOo, as the problem(s) may have already been
addressed. Either use the recent stable version:
or consider trying the new OOo 3 BETA (still in testing):
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
Comment 8 dieeasy 2010-03-02 08:57:04 UTC

I realize styles already are a satisfying solution to the problem this issue
talks about. Anyhow, the way it works now doesn't ever get in the way of the
user, which is good for those who know what they're doing but prevents new users
to learn how to use styles (and to do stuff, to some extent). I guess many users
don't even know about styles' existence, let alone understand what *page* styles
can do.
Moreover, using styles requires the user a bit of computer-like thinking, which
probably means the actual solution doesn't "scale down" very well to newbies. I
mean, for someone who just needs to compute some small numbers then print a
detailed view on an A3 page and a shorter summary on an A4 one, OOo could be
overkill if managing to print it takes 10 times the effort of creating the
spreadsheet in the first place.

I may be repeating myself, but what I mean is: getting in the way of the new
user and teaching him/her how to do basic things may be a good idea. As an
example, when first formatting a page (that is, modifying the predefined page
layout), OOo could ask the user if he/she wants those changes applied to the
whole document (that's not correct, but if someone doesn't know about styles the
concept applies) or only that single page, maybe offering to create a new
layout. The user could be provided a choice to "not show again" the
message/popup/dialog/whatever is informing him/her about page layouts.
..should these tips become too many to handle one at a time (in some distant
future?) OOo could provide a config option to enable/disable all of them
globally, sort of a beginner/expert mode choice.

I see what I'm proposing is out of scope in respect to this specific issue, but
I see it as a possible evolution and like to hear other people's points of view.

Sorry for the long post and many thank to anybody taking the time to read and
think about this!