1

i am using phpspreadsheet. I have two tables in the same spreadsheet and in both tables I would like to add the autofilter, but it takes into account only the last one added. Example:

//table 1 code
...
...
//autofilter 1
$spreadsheet->getActiveSheet()->setAutoFilter('A1:E1');

//Table 2 code
...
...
//autofilter 2 
$spreadsheet->getActiveSheet()->setAutoFilter('G1:K1');

output: autofilter only from G1 to K1, and not from A1 to E1

Spino
  • 9
  • 2
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. – Community Feb 25 '22 at 16:17
  • I think is a limitation, only the last setAutoFilter() function call is evaluated, even on the same sheet. I think I'll open a bug report. – Rickyx Jul 31 '23 at 18:02

0 Answers0