Posted 8 September 2017, 1:44 pm EST
I am using GetPreferredWidth to size the columns in my spread, however, some of the data fields are smaller than the column header text, so I use the following:
Dim HeaderCell As New FarPoint.Win.Spread.CellType.TextCellType
HeaderCell.WordWrap = False
For i = 0 To fpSpread1.ActiveSheet.ColumnCount - 1
fpSpread1.Sheets(0).ColumnHeader.Columns(i).CellType = HeaderCell
fpSpread1.ActiveSheet.Columns(i).Width = fpSpread1.ActiveSheet.Columns(i).GetPreferredWidth
But when I do this, the Autofilter icon (the funnel) disappears. When I comment out the line which sets the columnheader celltype it works fine. How can I make the Autofilter icon appear when I use the code above?