I'm using Spreadsheet::WriteExcel to visualize the results of filtering multiples CSV.

I'm able to set autofilters (Dropdowns to limit columns by entries) and filter_column

according to https://metacpan.org/pod/Excel::Writer::XLSX#filter_column(-$column,-$expression-) (other module from same author with identical documentation)

> NOTE: It isn't sufficient to just specify the filter condition. You must also hide any rows that don't match the filter condition. Rows are hidden using the set_row() visible parameter. Excel::Writer::XLSX cannot do this automatically since it isn't part of the file format. See the autofilter.pl program in the examples directory of the distro for an example.

What's irritating me is that when I filter manually inside gnumeric or libreoffice I can see the filtering still active after saving and reopening.°

Do I really need to hide all rows manually?

I can see that the filter_column settings reflect in the checkboxes of the dropdowns, is there a trick to trigger a spreadsheet program to apply the filtering?

edit

°) OK, after posting it occurred to me that saving from Excel/loffice/gnumeric must change the visibility for each row individually.