Hello
I have a new TXLSReadWriteII4 Object, if I Insert A sheet in front of others, all Autofilters in following sheets does not work anymore. If you open the created file in Excel (2010) and try to Sort a column, excel crashes.
xls := TXLSReadWriteII4.create;
sheet := xls.sheet[0];
sheet.Asstring.... [Insert some content]
sheet.Autofilters.Add(0,3,2,3); ///Sheet has data in three columns, row four are the title
sheet := xls.sheets.insert(0);
XLS.Filename := fileName;
XLS.Write;
---> Autofilter on sheet 1 (the second) does not work...
Is there A bug, or did I something wrong?