Hide a row with POI

Scott Klement's open source interface to the POI HSSF/XSSF Spreadsheet Project for RPG Programmers. http://www.scottklement.com/poi/
Post Reply
jeqberry
Posts: 6
Joined: Wed Jan 19, 2022 10:53 pm

Hide a row with POI

Post by jeqberry »

I don't see a shortcut in the Klement tools to make a row be hidden.
Scott Klement
Site Admin
Posts: 856
Joined: Sun Jul 04, 2021 5:12 am

Re: Hide a row with POI

Post by Scott Klement »

You could do it by adding code like this:

Code: Select all

     D SSRow_setZeroHeight...
     D                 PR                  EXTPROC(*JAVA
     D                                     : ROW_CLASS
     D                                     : 'setZeroHeight')
     D   newVal                       1N   value
Then when you have a row object and want to hide the row, you do this:

Code: Select all

   SSRow_setZeroHeight(row: *ON);
(or pass *OFF to unhide a row)
Post Reply