Apache POI and Java Excel Library : getFitToPage()

[Frank Wynants]

Hi all,

I have the following problem :
- I create an Excel using Microsoft Excel.
- In the page-setup dialog I set the fit-to-pages option on and set fit to 1/5 pages.

Now when I read in this xls file with "Java Excel API" (http://jexcelapi.sourceforge.net/) I can't manage to get the correct value of the fit-to-pages option.

I can read in everything from the Excel file except this setting. What I try to do is :

SheetSettings sheetSettings = sheet.getSettings(); //sheet being a WritableSheet Object
sheetSettings.getFitToPages(); //PROBLEM HERE ---> This always returns false
sheetSettings.getFitWidth(); //This correctly returns 1 (but also when I have Adjust to instead of fit to in Excel)
sheetSettings.getFitHeight(); //This correctly returns 5

I allready made some changes in the 'Java Excel API' to solve this but without succes.

Next step I took was downloading 'Apache POI'. But I have the exact same problem with this library. I can read in everything from the Excel sheet, except the boolean fitToPages. What I try to do using POI is :

POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream("/tmp/test.xls"));
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheetAt(0);
sheet.setAutobreaks(true); //I read in the bug database that getFitToPage doesn't work unless you set this to true
HSSFPrintSetup printSetup = sheet.getPrintSetup();
System.out.println(printSetup.getFitHeight()); //correctly returns 5
System.out.println(printSetup.getFitWidth()); //correctly returns 1
System.out.println(sheet.getFitToPage()); //PROBLEM HERE --> Always returns true

Anyone knows what is going on and has a solution for this in either one of the 2 API's (I prefer "Java Excel API" over POI, but if you can give me solution for POI I will also be more than happy). I gues I am doing something wrong cause both libraries have the exact same effect but I have no idea...

greetings,
Frank