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 ss_save...

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 differenc...

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(*JAVA: HSSF_WORK...

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 something w...