Issue 47681 - same selection für output methods
Summary: same selection für output methods
Alias: None
Product: Calc
Classification: Application
Component: printing (show other issues)
Version: OOo 2.0 Beta
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 75493 (view as issue list)
Depends on:
Reported: 2005-04-18 18:56 UTC by gerhard_oettl
Modified: 2013-08-07 15:12 UTC (History)
5 users (show)

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

example-file (7.47 KB, application/vnd.oasis.opendocument.spreadsheet)
2005-04-18 18:57 UTC, gerhard_oettl
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description gerhard_oettl 2005-04-18 18:56:28 UTC

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.

Comment 1 gerhard_oettl 2005-04-18 18:57:24 UTC
Created attachment 25181 [details]
Comment 2 frank 2005-04-19 08:05:30 UTC
Comment 3 frank 2007-04-26 15:16:22 UTC
*** Issue 75493 has been marked as a duplicate of this issue. ***
Comment 4 discoleo 2007-04-26 19:15:25 UTC
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


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'].

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

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)?

 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.
Comment 5 discoleo 2008-04-28 12:54:37 UTC
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?