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

  • Comment on Re: (SOLVED) Triggering autofilter in Excel via Spreadsheet::WriteExcel resp. Excel::Writer::XLSX

Replies are listed 'Best First'.
Re^2: (SOLVED) Triggering autofilter in Excel via Spreadsheet::WriteExcel resp. Excel::Writer::XLSX
by LanX (Saint) on Dec 03, 2021 at 18:52 UTC
    Thanks, I'll consider this.

    I also have a trick to trigger a Perl script from a spreadsheet, this could be used for a reprocess/reload mechanism. :)

    Cheers Rolf
    (addicted to the Perl Programming Language :)
    Wikisyntax for the Monastery