Bug 79930

Hi Alan, thanks for reporting.

I think there is not bug.

If you have select some range to print in any sheet, you need to define a range to print for every sheet which you can print.

In your file (Menu/Format/Print Ranges/Edit) has:
Summary Print Range: -None-
Sheet2 Print Range: - entire sheet -
Sheet3 Print Range: - entire sheet - 

What you can do is:
-Define a range for Summary.
or
Delete the print range for all sheets.

It works for me.

https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide

I've hit the same bug, but on 4.1.6.2, and i can confirm that if i tackle with print ranges, work.

The strange arise from the fact that *every* sheet i add to the file, got created with print area defined, so lead to 'blank page'.

Probably the trouble came from the import of the file from XLS format, but i think it make no sense (why new sheets need a print area defined?), so i think it is still a bug.

Created attachment 102551 [details]
Another file that hit the bug.

Add a sheet to that file: you will get a new sheet with a print area defined, and so you will lead to an empty print.

REOPENED is reserved for a bug that:

1. a developer has marked as FIXED;
2. a developer is assigned to the bug that is marked as FIXED;

In this case the bug report was never independently confirmed so correct status is UNCONFIRMED. Thanks!

(In reply to comment #3)
> Created attachment 102551 [details]
> Another file that hit the bug.
> 
> Add a sheet to that file: you will get a new sheet with a print area
> defined, and so you will lead to an empty print.

Tested with 4.3.1, win7. I downloaded your file, added new sheet, wrote some text into cell. Print preview is correct, I can see text. Print range is "entire sheet".

Sorry for the late answer. I've tried also i, Win7 64bit, LO 4.3.1.2.

I can confirm that if i add a sheet, i wrote something and the i go to print preview, i see something.

But:

1) if i add a sheet, and do a preview, i get empty preview ('Nessun dato', 'No data' in italian).

2) if i add a sheet (with something written on, or not, make no difference) and i go to another sheet (eg, 'id pomeriggio' or 'HLW pomeriggio') and i select print preview i get empty preview, eg a gray page with the gray sentence 'Area di stampa vuota' ('empty print area' in italian).

So, seems to me that the bug is still here...

(In reply to comment #6)
Hello,


> 
> 1) if i add a sheet, and do a preview, i get empty preview ('Nessun dato',
> 'No data' in italian).

There are no data or formatting on page, what do you expect to print/preview? I think it's correct -> no data means nothing to print.

> 
> 2) if i add a sheet (with something written on, or not, make no difference)
> and i go to another sheet (eg, 'id pomeriggio' or 'HLW pomeriggio') and i
> select print preview i get empty preview, eg a gray page with the gray
> sentence 'Area di stampa vuota' ('empty print area' in italian).
> 
Take a look at Format->Print range-> Edit . Print range is set to -none-
Change it to -entire sheet- and preview is here.

(In reply to comment #7)

> > 1) if i add a sheet, and do a preview, i get empty preview ('Nessun dato',
> > 'No data' in italian).
> There are no data or formatting on page, what do you expect to
> print/preview? I think it's correct -> no data means nothing to print.

Yes, it is correct; i've wrote that only to be more precise...


> > 2) if i add a sheet (with something written on, or not, make no difference)
> > and i go to another sheet (eg, 'id pomeriggio' or 'HLW pomeriggio') and i
> > select print preview i get empty preview, eg a gray page with the gray
> > sentence 'Area di stampa vuota' ('empty print area' in italian).
> Take a look at Format->Print range-> Edit . Print range is set to -none-
> Change it to -entire sheet- and preview is here.

I know that.
But this is very confusing for users: because the print area get defined in the new sheet, but apply to all the file, the result lead to a place where if users add a sheet (also for mistakes, or because they need a new sheet but forget to write something in), they get empty print, and don't understand WHY they get empty print.

LO handle perfectly the print area, and works as expected, the trouble is that EVERY NEW SHEET that you add to THAT file get a print area defined within, while people are unaware of that.

I don't know why LO add a print area to new sheet, but this is at least strange and confuse people.

I hope i was clear now...

Not a bug, so resolving.

(In reply to Beluga from comment #9)
> Not a bug, so resolving.

Why not a bug?

(In reply to Marco Gaiarin from comment #10)
> (In reply to Beluga from comment #9)
> > Not a bug, so resolving.
> 
> Why not a bug?

If you would like to propose changing the default behavior or add some helpful text/UI elements, you could make a proposal for an enhancement and submit a new bug that makes it clear.

You might also hop in the design forum to discuss this: https://redmine.documentfoundation.org/projects/design/boards

With changing the default behavior, we have to be very careful, because people can get angry.