Autofilter

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
Wild User
Posts: 6
Joined: Sun Oct 29, 2006 2:15 pm
Location: Russia

Autofilter

Post by Wild User »

v.3.0.2
The width of the dropping down list in the autofilter is leveled on width of a column.
It and should be?
The Excel does on width of the text...
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Post by larsa »

Hello

What I can see, the width of the combo box is the same as the column width, otherwise it would interfere on the next column, where it also may be an autofilter combo box...
But if I have missed something, please send me an excel file that describes this.


Lars Arvidsson
Wild User
Posts: 6
Joined: Sun Oct 29, 2006 2:15 pm
Location: Russia

Post by Wild User »

Hello!
The report in the E-Mail.
Guest
Posts: 83
Joined: Tue Aug 16, 2005 6:08 pm

Post by Guest »

Hi!
At me too a problem...

I need to add the autofilter in the first row.
I do so-

Code: Select all

MyXls.Sheets[Index].Autofilters.Add(0, 0, SG.ColCount -1, 0);
After preservation in a file, in the top row there should be buttons of the autofilter. It correctly works.
But.
On ALL buttons triangles - BLUE color (should be - BLACK).
If to switch off the autofilter in Excel - buttons remain on a place.
At presence of buttons of the autofilter in cells - the text of cells is not displayed.
This is a bug? (Excel XP, Win XP Pro, XLSRW v.3.0.7)
Post Reply