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 removeble by deleting the entire row where the filter
resides.
2) It seems impossible to place the filter on the column header row it
allways the filter buttons on the next row.
Please help?
Regards Eelco.
Autofilter problems
Autofilter problems
Eelco van der Hoff
HedoN electronic developments B.V.
HedoN electronic developments B.V.
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
changed a number of record and even removed some records.
The removed records like the index record of the sheet and de DBCELL
record have a important function.
Also the records added by Excel for the filters where changed, resulting
in not correctly working filters on the sheet reopening the workbook in Excel.
Please can you comment!
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
changed a number of record and even removed some records.
The removed records like the index record of the sheet and de DBCELL
record have a important function.
Also the records added by Excel for the filters where changed, resulting
in not correctly working filters on the sheet reopening the workbook in Excel.
Please can you comment!
Eelco van der Hoff
HedoN electronic developments B.V.
HedoN electronic developments B.V.
Did you receive the files?
Hi Lars,
Did you receive the files?
Kind regards
Eelco
Did you receive the files?
Kind regards
Eelco
Eelco van der Hoff
HedoN electronic developments B.V.
HedoN electronic developments B.V.
Autofilters
Please let me add my vioce to this, since this is a fairly serious problem for us. Autofilter works exactly as expected in Excel 2007 (which meant that we didn't spot the problem initially); but in earlier versions of Excel (97 to 03) it behaves as described earlier: all filter buttons look as though they're activated, which makes it impossible for users to see which if any are in fact active. These filters also behave rather badly when the user attempts to clear and reset filters in Excel 03.
When we noticed the issue, our first reaction was to purchase an upgrade to your version 4.0. This hasn't helped, however, and unless there's some prospect of a fix for this we shall be obliged to remove our XLSRW autofilters and revert to using com: this is of course an exercise we'd rather not carry out if you're able to come up with a solution.
The style of command I used is simply
xlsReport.Sheet[0].Autofilters.Add(0, 4, 3, 4)
where row 4 contains column headings and I have four columns of data.
Regards, Luke Fitzgerald, Pellcomp Software Ltd
When we noticed the issue, our first reaction was to purchase an upgrade to your version 4.0. This hasn't helped, however, and unless there's some prospect of a fix for this we shall be obliged to remove our XLSRW autofilters and revert to using com: this is of course an exercise we'd rather not carry out if you're able to come up with a solution.
The style of command I used is simply
xlsReport.Sheet[0].Autofilters.Add(0, 4, 3, 4)
where row 4 contains column headings and I have four columns of data.
Regards, Luke Fitzgerald, Pellcomp Software Ltd
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 XLSReadWriteII 3.0 there is a difference in
the Escher records writen to the file. After editing the records written with
xlsReadWriteII 3.0 with a binary editor, it is possible to remove the filter
in Excel.
I have send al this data with files to Lars, but have not received answer
yet.
Greetings Eelco
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 XLSReadWriteII 3.0 there is a difference in
the Escher records writen to the file. After editing the records written with
xlsReadWriteII 3.0 with a binary editor, it is possible to remove the filter
in Excel.
I have send al this data with files to Lars, but have not received answer
yet.
Greetings Eelco
Eelco van der Hoff
HedoN electronic developments B.V.
HedoN electronic developments B.V.