Problem with auto-filters in Excel file generated

Topics: Developer Forum, User Forum
Feb 8, 2012 at 9:31 AM

Hi,

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 are OK.

I can try to fix the problem, but I have some difficulties to find where are generated the XML data ?

Thanks for your help,

Xavier