Both FlexCel and Excel will apply the autofilter to all the cells below the autofilter up to the first blank cell. If you sort, it will sort up to the first blank row.
If you are referring to the left and right columns of the autofilter, you need to set up that in FlexCel too.
Can you send me 2 xls files, one with the autofilter created in Excel and the other in FlexCel so I can see the differences?
Regards,
Adrian.
Ps: I am not sure it is possible to attach things to this forum, so just send them to adrian@tmssoftware.com
Sorry if I'm unable to explain it, I'll send you the Excel workbooks on Monday but after I added the empty row above the autofilter, as you suggested the problem was fixed.
The autofilters don't behave exactly the same but it works well now :)
Gunnar Steinn
ps. thanks for an excellent product, really fixed my Interop bugs!
Glad to know at least it was fixed. I will be waiting for the spreadsheets to see if there is something else that can be done.
That is strange, since an Autofilter Record in an Excel file just has 3 parameters, the row where the autofilter is, and the first and last column. Nothing else is saved in the file, and those 3 values are the ones you set in the SetAutofilter call. But well, we'll see with the examples, I must be missing something, maybe some other record that is saved too.