[Stackoverflow] [Progress OpenEdge ABL] Using autofilter on excel sheet in Progress 4GL

[Szabó László]

I have some issue about Autofilter a range of cells on an Excel sheet.

the part of the code: vchWorkSheet:Range(XLS_col(1) + STRING(2) + ":" + XLS_col(vi_x) + STRING(2)):Autofilter.

where: vchWorkSheet - the actual worksheet Range(XLS_col(1) + STRING(2) + ":" + XLS_col(vi_x) + STRING(2)) - the range of cells

I've got an error message when building app: "Wrong number of parameters. Component method Autofilter called with < 3 parameters."

Actually I would like to use only VisibleDropDown parameter, nothing to filter in default.

Error message here

Any idea?

I've tried to add some parameters, but i don't know the syntax of Autofilter arguments.

I would like to display filter option on the range

Continue reading...