Axolot Data

Hi Luke, I noticed that in some casses (if no filter value was actually set) the record 9Dh AUTOFILTERINFO is missing in the XLs file. When I edit the file with a Hex editor and add this record it works. Maybe you do not wite it if no filter properties are set. When writing the autofilter with XLSRe...

Hi Lars,

Did you receive the files?

Kind regards
Eelco

No response yet :( So I dived into the binary XLS file. I made a simple Excel workbook in Excel 2003 with one sheet and a Filter on the first two columns. I read this workbook with XLSReadWriteII 3.0 and directly did a write. In the saved workbook stream I saw that only a read and write action chang...

Hello, I have some problems with autofilters: 1) When a autofilter is active when opening a file and then writing it back to file the autofilter is moved to the first column of the next row. (It was on the column header row) The arrow is black but al line numbers are blue. The filter is only removeb...