http://qs321.pair.com?node_id=11139317


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