![]() |
|
Pathologically Eclectic Rubbish Lister | |
PerlMonks |
Re: (SOLVED) Triggering autofilter in Excel via Spreadsheet::WriteExcel resp. Excel::Writer::XLSXby footpad (Abbot) |
on Dec 02, 2021 at 12:50 UTC ( #11139317=note: print w/replies, xml ) | Need Help?? |
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
|
|