Apache OpenOffice (AOO) Bugzilla – Issue 42575
Per-page format setting
Last modified: 2013-08-07 15:12:27 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...
Hi, 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. Frank
About different printer settings I'm not sure that this is achievable. But a solution could be print ranges. Frank
This enhancement should not get closed.
This issue calls for the ability to format each sheet e.g. for printing. Good idea; A competitors already offers this function.
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!
Set target and updated status.
OpenOffice.org 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: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ 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: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html
Hi, 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!