Excel does not seem to respect any value used in a table column's setShowFilterButton() method about phpspreadsheet HOT 3 CLOSED

There appears to be a misplaced statement in Writer/Xlsx/Tables. Expect a fix in a day or two. Just because I think it's interesting, doing something like this in Excel itself seems possible only with VBA.

from phpspreadsheet.

Thanks so much, @oleibman -- that's fantastic to know that a fix is possible! And looking more closely at the MS documentation on the "hiddenButton" attribute, that makes total sense that the only way to adjust this within Excel is with VBA. (And it also explains why I couldn't find any threads out there describing how to hide the filter drop-downs in the regular Excel application interface.)

I also wanted to thank you and everybody else who's been developing this repository -- what an amazingly rich tool to interface with Excel/spreadsheet-applications!

from phpspreadsheet.

Thanks again for all your work and help on this, @oleibman !

I've tested out the fix from #3992 , and it works perfectly with both the test 01_Table.php script, and a locally developed Excel export, so it all looks great to me, and thanks for catching the ancillary changes as well that you identified in #3992 .

We're interfacing with this repository in a Drupal site that uses a module (xls_serialization) that's still using the 1.x branch of this repo, so it may take a while for your fix to make its way down to us on our site, but it's great to know that eventually we'll have the ability to control which columns get the filter drop-down feature.

Thanks again!

from phpspreadsheet.