Search found 6 matches
- Thu Oct 14, 2021 4:08 pm
- Forum: HSSFR4
- Topic: Scale to Fit spreadsheet to one Page
- Replies: 10
- Views: 39674
Re: Scale to Fit spreadsheet to one Page
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...
- Thu Oct 14, 2021 12:26 pm
- Forum: HSSFR4
- Topic: Scale to Fit spreadsheet to one Page
- Replies: 10
- Views: 39674
Re: Scale to Fit spreadsheet to one Page
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.
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.
- Tue Oct 05, 2021 9:13 pm
- Forum: HSSFR4
- Topic: Scale to Fit spreadsheet to one Page
- Replies: 10
- Views: 39674
Re: Scale to Fit spreadsheet to one Page
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...
- Tue Oct 05, 2021 12:06 pm
- Forum: HSSFR4
- Topic: Scale to Fit spreadsheet to one Page
- Replies: 10
- Views: 39674
Re: Scale to Fit spreadsheet to one Page
Thanks sir!! Will give it a try today.
- Mon Oct 04, 2021 6:44 pm
- Forum: HSSFR4
- Topic: Scale to Fit spreadsheet to one Page
- Replies: 10
- Views: 39674
Re: Scale to Fit spreadsheet to one Page
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...
- Mon Oct 04, 2021 12:50 pm
- Forum: HSSFR4
- Topic: Scale to Fit spreadsheet to one Page
- Replies: 10
- Views: 39674
Scale to Fit spreadsheet to one Page
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...