Apache OpenOffice (AOO) Bugzilla – Issue 47681
same selection für output methods
Last modified: 2013-08-07 15:12:27 UTC
hello it would be fine, if the three build-in output-methods (previw, print and pdf-export) would use the same selection. Now print knows more options than the other two what would result in a different pdf than a print done at the same time. And the preview does not show what is printed currently. And the possible pages shown in the file -> printer dialog does not reflect the real count of pages that would be printed so it is hard to make a selection there. what i have recogniced till now: (view=page-preview, dlg=print-dialog) options, recogniced by the differenz output methods: - print range "none": view=yes, print=yes, dlg=yes, pdf=yes - print only selected sheets: view=no, print=yes, dlg=no, pdf=no - supress empty pages: view=yes, print=yes, dlg=no, pdf=no There may be contras for taking account for the "print only selected sheets" option in page preview. I think it should show what will be printed now. If i push the "print direct" button in the toolbar in editing-mode i get the one sheet. The same button in preview prints 3 pages and the footer (page x of xx) are different too. Someone might see all would be printed, if the "print only selected sheets" option is released. A compromise could be to show an icon in the preview toolbar that indicates if this page is included to a print with the current settings or not. The print-dialog in the current example shows pages 1-4. If i delete sheet 4 (that would be supressed, because the print range is a empty cell) pages 1-3 is offered. Even if i disable header and footer. Pdf-export also produces a empty page when header and footer are disabled. gerhard
Created attachment 25181 [details] example-file
requirements
*** Issue 75493 has been marked as a duplicate of this issue. ***
I discussed in issue 75493 (now closed) a method to enhance the printing / exporting to pdf of various spreadsheet documents. I will add those comments to this issue and also expand on some other related features. 1. SUPPRESS TRAILING EMPTY PAGES 2. TYPES OF EMPTY PAGES 3. IMPLEMENTATION 1. TRAILING EMPTY PAGES ======================= When printing / exporting as pdf, I would like to suppress trailing empty pages. Trailing empty pages are empty pages at the *END of the document*, so they are almost always annoying. Please note, that this issue is *NOT trivial*. Unfortunately, when I export dozens of pages, I select to have the *page number* and the *total number of pages* in the footer. The total number of pages will count these empty pages, too. Therefore, even IF I manually select which pages to export to pdf, the *total number of pages* will include these empty pages. The workaround *define the print range* is really tedious for anything having more than just a few pages. IF this is an official document, then the total number of pages will point to non-existent pages, which will make Calc pretty useless in official settings. [Documents from governmental sources ALWAYS contain the total number of pages explicitly stated, so that, whatever page is available, the reader knows how many pages the document should have.] A checkbox with *Strip trailing empty pages* seems a really fine solution [this is NOT equivalent to 'Strip ALL empty pages']. 2. EMPTY PAGES ============== There are a number of types of empty pages: a.) There are pages that are completely empty, NO hidden cell content, NO EMPTY cells, NO formulas (evaluating to nothing), NO formatting, nothing. - e.g. when the text of row 1 extends beyond the width of one page, - YET rows 2-xxxx do NOT extend beyond the width of a page => row 1 will occupy page 1 and page n => rows 2-xxx pring on pages 1 through n-1 => pages n+1 to 2*(n-1) will be completely empty (just annoying footer and header) b.) Pages that contain formulas that evaluate to empty. - NO visible elements - yet cells are NOT empty (contain formulas OR references that evaluate to empty) c.) Pages that contain graphical formatting, yet contain NO other data. - e.g. contain various table borders set BUT NO elements [and neither images/charts] These are 3 common types of empty pages which should be possible to suppress *selectively*. [By combining the latter 2 varieties, a number of other possibilities arise.] 3. IMPLEMENTATION ================= This could be implemented in the following way: when Calc generates the page, it should set for every page the following properties: a.) does the page display any data (including charts)? b.) does the page display any graphical elements? [excluding proper/printable data] c.) does the page contain other elements (e.g. formulas)? SET GLOBALLY: d.) store last NON-EMPTY page IF a page contains (a.) then any previous EMPTY pages are NOT trailing pages; ANY page up to 'last NON-EMPTY page' is NOT a trailing empty page It would be really helpful to extend Calc to support all these features.
I am just revisiting the trailing empty pages. Couldn't resist. Empty pages that are at the end of the document, so there are NO other pages beyond them: - should be suppressed from printing - should be suppressed from exporting - should NOT count during page numbering And should be by default handled as previously stated, without the user having ever to select - using a very complex process - some print-ranges. What IF new data is added to the spreadsheet and the print-range changes? You have to redefine everything. Why waste time with defining a print-range when this should be the default setting and should work without any user input (at most a click on a checkbox). Have ever wondered when receiving a fax and you get page 6 of 10, but the pages 7, 8 ,9 and 10 are missing? Should I ask the fax to be resubmitted? Was it a transmission error?