in reply to (SOLVED) Triggering autofilter in Excel via Spreadsheet::WriteExcel resp. Excel::Writer::XLSX
OK, after posting it occurred to me that saving from Excel/loffice/gnumeric must change the visibility for each row individually.
I seem to recall that this depends partly on the file format, as certain formats don't support certain properties and/or settings. (CSV is notoriously limited.)
Perhaps saving the persistent version separately from the production CSV would help? Sure, it's more steps, but if it saves effort for the export...?
--f
In Section
Seekers of Perl Wisdom