Bug 47078 - Empty page with cell borders gets printed out when "Suppress output of empty pages" is enabled
Summary: Empty page with cell borders gets printed out when "Suppress output of empty ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.5.0 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-03-07 19:00 UTC by AH
Modified: 2014-08-15 12:34 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:


Attachments
A sample doc to easily see the problem (8.65 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-03-07 19:01 UTC, AH
Details

Description AH 2012-03-07 19:00:17 UTC
As far as my understanding goes, "Suppress output of empty pages" option supposed to exclude empty pages from being printed out when this option is enabled.

And as it is stated in the help menu; "Specifies that empty pages that have no cell contents or draw objects are not printed. Cell attributes such as borders
or background colors are not considered cell contents. Empty pages are not
counted for page numbering."

Therefore, if a page has no data, or objects, that page is considered "Empty"
and will not be printed disregard the border settings.

However, if a page that contains empty cells with only cell borders are included
within a print range, that empty page gets printed out.
Comment 1 AH 2012-03-07 19:01:27 UTC
Created attachment 58150 [details]
A sample doc to easily see the problem
Comment 2 Markus Mohrhard 2012-04-02 18:50:45 UTC
@Astron: Any suggestions from UX POV? This seems like a corner case. Defining a print range together with suppress output of empty pages.
Comment 3 Stefan Knorr (astron) 2012-04-04 06:55:47 UTC
So, I did a bit of testing and noticed that this happened even when choosing "All pages" (which is a print range, but not one where the user actually says, "I want this page!").

So, I think that it should be changed, as Sushi described – otherwise the feature is just broken.

But, going a bit further, if the user specifically lists the empty page, we should print it anyway. For instance (with page 2 being the empty one, as in the test case):
* 1-3 – don't print the empty page
* 1,2,3 – print the empty page
* 1-2 – print the empty page
* 2-3 – print the empty page

Rationale: If the user specifies a print range that includes a more or less empty page, my assumption would be that they might have set the range to specifically print the empty pages.

Does that help/compute?
Comment 4 AH 2012-04-05 19:41:24 UTC
Perhaps, just change what is written in the Help and/or
add additional comment to the Options settings?

Say, the option works differently depending on how print
range is specified?

Or add another options setting to allow users to choose
whether to include empty pages if print range is manually
specified. It is always better to have more options.
Comment 5 Stefan Knorr (astron) 2012-04-06 02:07:35 UTC
Maybe I am misunderstanding something about the behaviour here, but as far as I can see, the option is currently _completely broken_: even if you select the range "All pages", you get empty pages – thus, output of empty pages is actually never suppressed.

The only way to successfully suppress empty pages currently is to choose a print range like "1,3" (for the sample document) where the option won't even come into effect because the user chose a range that already excluded the empty page
Comment 6 AH 2012-04-08 18:37:53 UTC
> Astron
Thank you for getting back to me.

The point of this ISSUE is that only when the borders are set, the option
does not work as expected.

As you can see in the sample doc, the "Empty page" is not suppressed from
printing disregard the print range settings. (Delete the defined print range
and the 2nd page would still be printed)

Remove all the borders from 2nd page of sample doc, it is suppressed from
printing disregard the print range. And fill background of 2nd page, it is
still suppressed from printing.

Therefore, the feature works partially and is NOT "Completely Broken" but
does not work as it should only for the borders.

I am fine with "Print empty pages anyway if it is manually specified to
do so" but in that case, I think what is written on the Help page needs
to be changed to suit the actual behavior.


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.