Re: How to apply filter to a sheet in RPG. (HSSFR4, POI, Spreadsheet)

I am not sure if this is what you are after but I have this from a
previous thread back in 2016 ...

For anyone who was following this thread, the following will
correctly provide all the required entries in hssf_h:

D AUTOFILTER_CLASS...
D c 'org.apache.poi.ss.usermodel-
D .AutoFilter'
D SSAutoFilter...
D S O CLASS(*JAVA
D : AUTOFILTER_CLASS)


D ssSheet_setAutoFilter...
D PR like(SSAutoFilter)
D EXTPROC(*JAVA: SHEET_CLASS
D :'setAutoFilter')
D ref like(CellRangeAddress) const

In the rpg program references as an example:

range = new_cellRangeAddress(0:10:0:4);
ssSheet_setAutoFilter(sheet:range);

The missing piece was provided by a gentleman in England
who figured out that the ssSheet_setAutoFilter needed a reference back
to SSAutofilter using the "like(SSAutoFilter)" as shown.




Don Brown



From: "John Rusling via RPG400-L" <rpg400-l@xxxxxxxxxxxxxxxxxx>
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Cc: JRusling@xxxxxxxxxxx
Date: 24/10/2019 12:36 AM
Subject: How to apply filter to a sheet in RPG. (HSSFR4, POI,
Spreadsheet)
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx>



In the past -- I have indicated that a range on a workbook sheet have a
filter on them in RPG.
ie; User opens the spreadsheet, see's there is a filter, clicks the filter

button, and set's their filter.

What I'd like to know - does anyone have code examples, in RPG, that will
allow
me to set the filter, so the user will open the spreadsheet with filter(s)

already set/applied?
ie; When the user opens the spreadsheet, their filter is already set and
applied to the sheet?

Any examples, help or direction is much appreciated.
Thanks,
John
<br />
The information in this email is confidential and may be legally
privileged.
It is intended solely for the addressee. Access to this email by anyone
else is
unauthorized. If you are not the intended recipient, any disclosure,
copying,
distribution or any action taken or omitted to be taken in reliance on it,
is
prohibited and may be unlawful.