Apache OpenOffice (AOO) Bugzilla – Issue 9235
Broken Printing Scaling in Spreadsheet Component
Last modified: 2013-08-07 15:15:02 UTC
Requesting a print scaled to a single page actually produces a multi-page printout (according to page preview). To reproduce: Open a new document. Insert text "TopLeft","TopRight","BottomLeft","BottomRight" in cells A1, AH1,A4875,AH4875 respectively. Go to Page Preview. Select Page Format,Sheet. Under scale, select "Fit printout on number of pages" and set this to the value 1. Examine the page navigation controls on the upper left - these now show that the printout will span nine pages, instead of the requested one. The text also does not fit the first page nicely. On a related note, it would be useful to be able to scale the printout to a set number of pages in either the vertical or horizontal directions (as per Excel or Gnumeric). This helps in cases, such as the example above, where the spreadsheet is far larger in one dimension than the other. For instance, for this spreadsheet, I would like to fix it to 1 page wide (i.e. the range of columns A to AH fits the width of a single page), but any number of pages long (i.e. the range of rows 1 to 4875 fits as many pages as is required for the current font aspect ratio).
Created attachment 3598 [details] Test Spreadsheet as described in bug report
Trying to put such a big amount of cells on one page is useless. So OOo determines the smallest possible Fontheight and width. This results in an 9 Page document. Not a bug. Frank
closed invalid
Hi Frank I see why the spreadsheet I gave as an example will not print on a single page. However, please consider the request I'm making later in the original bug report. The example I attached to the bug report was a reductio ad absurdium to illustrate the problem; I don't really intend to print a sheet that large. The problem I have is that printing scaling currently only allows a user defined scaling or for the entire sheet to be fit to a single page. When a sheet is much longer than it is wide (1), or much wider than it is long (2), the fit to one page option is inadequate - the largest dimension will be fit to the page and the aspect ratio kept, resulting in either a very narrow vertical strip (in case 1) or a very narrow horizontal strip (in case 2) along the side or top of the single page that is printed. What I'm suggesting is a facility like that in Excel - allowing the user to specify that the printout be scaled to fit either one page wide (but potentially many pages long) (for case 1) or 1 page high (but potentially many pages wide) (for case 2). The user could of course achieve this manually by trying out different scaling factors until he finds one that achieves this, but this would be cumbersome and the OpenOffice.org team have already prevented this in the case that the entire sheet should fit on one page. The implementation is obvious and easy, given that the scaling primitives clearly exist - if the sheet is to be fit to 1 page wide, choose the scaling factor that would fit the horizontal dimension of the spreadsheet to the width of the page; if 1 page tall, choose the scaling factor that would fit the vertical dimension of the spreadsheet to the height of the page. All that would need to be added is the extra options in the print dialog. I anticipate that the OpenOffice.org team is under pressure to close bug reports during the runup to the 1.1 release. However, please consider this request as it would make the spreadsheet printing considerably more usable for little effort. Regards Allan Holman
Hi Bettina, sizing of print output could be improved as mentioned here. Frank
double *** This issue has been marked as a duplicate of 8868 ***
double->closed