scottklement.com

Found it. Had to XSSF on the prototype for the protect sheet.

I have a program that was writing xls. I changed it to use the new HSSFR4 in order to handled xlsx. It works well, except for the Protect Sheet. Is does not want to protect the sheet. I do not see any errors. Maybe is should not be hssf any longer? D ssSheet_protectSheet... D PR ExtProc( *Java D : '...

I found the issue. After a bit of google searching I found that the original sheet cannot have any formulas in it. The source sheet I was using had 2 simple formulas in a couple of cells =b13 and =C12. With xlsx you need to have no formulas in the sheet you are going to update , or you have to set t...

Could be back when you did it, things did work. I tried opening with Excel 2013 and in Teams. Teams will open it, and prompts to "Fix It". Excel 2013 opens it and removes the formulas. I went to the web, and one place indicated I needed poi-ooxml, and I do see that jar on the system and ge...

I have code that was using hssf procedures as it was an xls (old excel). Management want the excel to now be xlsx. I used the ss_formula procedure call and it did not abend. The issue is when I go to open the xlsx it indicates something is wrong with spreadsheet. It allows me to open it and with thi...