I am using PHPExcel to generate Excel 7 files. I read a file as template input, I add some date, and I generate output file.
The input file contains some auto-filter on columns. In the generated file, the auto-filters are no more present.
Is this problem already known ?
I have analyse the original file and the generated file. The problem is that there is the sheet name in the autofilter reference <autoFilter ref="FEUIL1!A5:W5"/>. I I remove it, like this <autoFilter ref="A5:W5"/>, the autofilters
I can try to fix the problem, but I have some difficulties to find where are generated the XML data ?
Thanks for your help,