Hi,
I have got a weird problem: We use POI to create some excel sheets from
templates like this:
// Reading the excel template from the
filesystem.
// Because the POI api produces an error
for 'auto filter' rows
// we use the template instead creating
the sheet from the
// scratch.
POIFSFileSystem fs = new
POIFSFileSystem(getClass().getResourceAsStream(
"/ApprovedShowsTemplate.xls"));
HSSFWorkbook wb = new HSSFWorkbook(fs);
// Only one sheet inside.
HSSFSheet sheet = wb.getSheetAt(0);
Yesterday I have finetuned the template (added a line, changed text...)
and now the printSetup got lost. Means: inspecting the sheet shows that it
has a _psBlock (PageSettingsBlock), but the _psBlock lacks the printSetup
(PrintSetupRecord, is set to null). If I try to change a property of the
printSetup sheet.getPrintSetup().setLandscape(false); I get a
NullPointerException.
With the old templates there is no problem: the sheet has a printSetup! So
where is the difference? We use the same Excel 2003 SP 3 version with POI
3.2 final.
If needed I can provide the 2 Excel files.
Anyone got a clue about why the printSetup got lost?
Thanks,
Reiner Kühl
Reiner Kühl
IS&T Enterprise Application Development
QVC Call Center GmbH & Co. KG
Lise-Meitner-Allee 1
44801 Bochum
Telefon: 0049 - 234 - 9732 - 2866
Fax: 0049 - 234 - 9732 - 44 - 2866
eMail: [email protected]
Internet: http://www.qvc.de
QVC - Ideen für mich!
Unternehmenssitz ist Düsseldorf
Eingetragen beim Amtsgericht Düsseldorf: HRA 13610
GF der Komplementärin QVC Call Center Verwaltungs-GmbH:
Neal S. Grabell, Dr. Ulrich Flatten
Danke für Ihre Kooperation!
