1金币
你好,我在下拉菜单中使用了MultiColumnComboBoxCellType,目前数据源大概有7000行,在数据库中查询很快,但是显示下拉菜单很慢,有没有什么办法关掉下拉菜单的重绘功能,在加载完后一起绘制。代码如下:
Dim mcb As New FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType()
mcb.DataSourceList = ds.Tables("select_list")
mcb.DataColumn = 0
mcb.ButtonAlign = FarPoint.Win.ButtonAlign.Right
mcb.ListWidth = 600
mcb.ListOffset = 5
mcb.MaxDrop = 10
mcb.Editable = False
mcb.AutoSearch = FarPoint.Win.AutoSearch.MultipleCharacter
Fptag.ActiveSheet.Cells(e.Row, e.Column).CellType = mcb
|
|