Adding Autofilter & Frozen Panes

[DrTob]

in XLSReadWriteII4 I add an autofilter with

Code: Select all

XLS.Sheet[0].Autofilters.Add(0, 4, 3, 4);

in Version 5 the method "ADD" does not exist. How can I create an autofilter in XLSReadWriteII5?


In my existing Code, I can Create fixed header rows with to following code:

Code: Select all

    sheet.Pane.SplitColX := 0;
    sheet.Pane.SplitRowY := FHeaderRows;
    sheet.Pane.TopRow    := FHeaderRows;
    sheet.Pane.PaneType  := ptFrozen;
    sheet.Pane.ActivePane := 0;
    sheet.Options := sheet.Options + [soFrozenPanes];

In V5 this does not work. The Option soFrozenPanes does not exist anymore.

[DrTob]

still not solved...

[larsa]

Hello

Autofilters is added in update. 5.20.03

In order to create frozen/split panes use FreezePanes/SplitPanes methods: XLS[x].FreezePanes(Col,Row);