← 返回所有博客文章

本文阐述如何通过 ComboCellType 实现类似于实现像google 搜索一样的自动完成功能。

代码如下:

//设置单元格类型
            FarPoint.Win.Spread.CellType.ComboBoxCellType combo = new FarPoint.Win.Spread.CellType.ComboBoxCellType();

            string[] cbstr;
            cbstr = new String[] { "AAA", "AABC", "ABBC", "BBB", "BBC", "BCC" };
            string[] strval;
            strval = new String[] { "1", "2", "3", "4", "5", "6" };

            combo.Items = cbstr;
            combo.ItemData = strval;
            combo.EditorValue = FarPoint.Win.Spread.CellType.EditorValue.ItemData;

            //指定自动完成的模式及数据源
            combo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
            combo.AutoCompleteSource = AutoCompleteSource.ListItems;

            fpSpread1.Sheets[0].Cells[0, 0].CellType = combo;

 

 

效果截图:

 

Demo下载:

spread_win_comboautocomplete.zip (19.56 kb)