RE: setPageWidth not working on all pages in Workbook

[Laubach Shawn Contr OC-ALC/PSB]

I wrote a simple test that created 11 sheets and called your function for
each one.  When I opened the resulting file, all values were set properly
for each sheet.  Would it be possible to get the smallest test program and
example spreadsheet that recreated this.

Shawn

-----Original Message-----
From: Brian Glick [mailto:B.Glick@;Freightek.com]
Sent: Thursday, October 24, 2002 8:06 AM
To: [EMAIL PROTECTED]
Subject: setPageWidth not working on all pages in Workbook


I am trying to create a workbook with 10 sheets.  Before writing the
workbook, I run the following method on each sheet:

  static void printFormat(HSSFSheet sht)
  {
      //format sheet
      HSSFPrintSetup pSetup = sht.getPrintSetup();
      sht.setAutobreaks(true);
      pSetup.setFitWidth((short)1);
      pSetup.setFitHeight((short)0);
      pSetup.setLandscape(true);
  }

When I open the workbook in Excel and look at Page Setup, all sheets have
the correct Fit to Page settings, but only the first page has the "Fit to:"
radio button selected.  All other pages are still set to "Adjust to:".
Therefore only my first page is printing correctly.  

When I use BiffViewer all of the pages have the same values in the [WSBOOL]
and [PRINTSETUP] sections, which are included below.

(All of the pages are correctly formatted for landscape.)

What am I doing wrong?  Thanks in advance for any help.

Brian Glick
Freightek, Inc.
(215) 887-6100
[EMAIL PROTECTED]


[WSBOOL]
    .wsbool1        = 5
        .autobreaks = true
        .dialog     = false
        .rowsumsbelw= false
        .rowsumsrigt= false
    .wsbool2        = ffffffc1
        .fittopage  = true
        .displayguts= false
        .alternateex= true
        .alternatefo= true
[/WSBOOL]

[PRINTSETUP]
    .papersize      = 1
    .scale          = 100
    .pagestart      = 1
    .fitwidth       = 1
    .fitheight      = 0
    .options        = 0
        .ltor       = false
        .landscape  = false
        .valid      = false
        .mono       = false
        .draft      = false
        .notes      = false
        .noOrientat = false
        .usepage    = false
    .hresolution    = 300
    .vresolution    = 300
    .headermargin   = 0.5
    .footermargin   = 0.5
    .copies         = 0
[/PRINTSETUP]

--
To unsubscribe, e-mail:   <mailto:poi-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>

--
To unsubscribe, e-mail:   <mailto:poi-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>