Nick Burch wrote:
On Fri, 15 Jun 2007, Tahir Akhtar wrote:
I have also tried another variation. I didn't set the paper size from
poi then opened the file in excel, tried the print entire workbook
and it worked. Then I changed the paper size from excel and the bug
was reproduced.
So, to confirm:
* if you generate the file with poi, select all the sheets in poi,
and don't touch the paper size, it prints all pages
* if you generate the file with poi, select all the sheets in poi,
set the paper size to a4, it only prints the first page
* if you generate the file with poi, use excel to set the paper size to
a4, select all the sheets with poi, it only prints the first page
* if you generate the file with poi, use excel to set the paper size to
a4, use excel to select all the sheets, it prints all the pages
Have I got all of the above correct?
The problem can be reproduced without bringing sheet selection into the
picture. I am using the "Entire Workbook" option from print dialog. So
the cases are:
* if you generate the file with poi, and don't touch the paper size, it
prints all pages
* if you generate the file with poi, use poi to set the paper size to
a4, it only prints the first *sheet*
* if you generate the file with poi, use excel to set the paper size to
a4, it only prints the first *sheet*
In cases 2 and 3, if first worksheet have more than one pages, all pages
of first worksheet are printed. Remaining worksheets won't print at all.
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
