Unable to print multiple workbooks per page

  • 7002031
  • 01-Dec-2008
  • 26-Apr-2012

Environment

Novell iPrint for NetWare
Novell iPrint Client for Windows
Novell NetWare 6.5 Support Pack 7
Novell NetWare 6.5 Support Pack 8

Situation

Printing acts different depending on the iPrint client and printer when trying to print an Excel spreadsheet that has multiple workbooks.  The print options selected were to print 4 workbooks per page and print in color.  With the 4.35 and 4.36 iPrint clients printing to a Color Laserjet 4600 or Officejet 9130, attached to a NW65SP7 server, results in one small workbook printed in the upper left hand corner of the first page and then each workbook after that prints on a full page.  When printing in Black and white, printing to both prints works correctly.
 
Using the 5.12 iPrint client, printing the same spreadsheet to a Kodak Easyshare 5300 printer attached to a NW65SP8 server results in 4 workbooks printing on the first page but only 2 workbooks on each page after that for both color and black and white.
 
Printing to an HP Photosmart 1215 printer, results in one small workbook printed in the upper right hand corner on the first page and each workbook after that prints on a full page, again in both color and black and white.

Resolution

This isn't an iPrint issue at all but rather the way in which Microsoft Excel sends the multiple worksheets to the printer.  It sends each worksheet as a different print job however the print dialog box that comes up is only for the first job (first worksheet) so the customization can only be done for that first job.  If the printer driver defaults to B&W, and color is specified only that first page (worksheet) prints in color.