scottklement.com

moved the fittopage
to the SS_save in my code, still not working:

1994.00 // >> Set up autofit
1995.00
1996.00 SSSheet_setFitToPage(sheet: *ON);
1997.00 ps = SSSheet_getPrintSetup(sheet);
1998.00 SSPrintSetup_setFitWidth(ps: 1);
1999.00 SSPrintSetup_setFitHeight(ps: 1);
2000.00 // >>
2001.00 ...

Well, been trying to get this to work. Moved code to be before the SaveSheet(book);
Debugged, see the code being executed.

I am saving the spreadsheet as a XLS, thought that may be the issue. so change to XLSX, to match the provided code.

Just not having any luck.

Okay, I copied your code. Got your copy compiled and ran with huge success.

Now trying to merge into my existing code.

getting RNF5406 - The call passed fewer parameters than the prototype indicates
are required.

I understand you are very busy, I am working through and researching what the ...

Thanks sir!! Will give it a try today.

Use this instead? I am pretty lost on this...
*...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+...
1615+D .HSSFClientAnchor'
1616+D HSSF_PRINTSETUP_CLASS...
1617+D C 'org.apache.poi.hssf.usermodel-
1618+D .HSSFPrintSetup'
1619+
1620+D HSSFWorkbook S O CLASS ...

Trying to find the right combination to scale a spreadsheet to one page.

I have inherited this code that was referencing the following BNDDIR and /copy statements.

H BNDDIR('HSSF')
* Load JAVA Routines
/copy hssf_h

I am trying the following statements, with program dump results. So doing ...