通过datasource绑定的数据为何显示.00

收藏

通过datasource绑定的数据为何显示小数点带两位，如图

怎么设置才能取消：小数点以及后两位的00

lzh3452 · lzh3452

把列的CellType改为Text就可以了。

lzh3452 · lzh3452

把列的CellType设成Text就行了。

lzh3452 · lzh3452

设置列的CellType为Text就行了。

iceman · iceman

你好，NumberCellType 默认为两位小数，请参考帮助文档-NumberCellType 类。

zheng_hq · zheng_hq

原帖由 iceman 于 2011-11-7 15:49:00 发表
你好，NumberCellType 默认为两位小数，请参考帮助文档-NumberCellType 类。

如何修改默认，设置为整数，没有小数点呢？

iceman · iceman

你好，我是按照如下步骤进行测试的：

DataTable myTable = new System.Data.DataTable();
myTable.Columns.Add("col1",typeof(System.Int32));
myTable.Columns.Add("col2", typeof(System.Int32));
myTable.Columns.Add("col3", typeof(System.Int32));
myTable.Columns.Add("col4", typeof(System.Int32));
myTable.Columns.Add("col5", typeof(System.Int32));
myTable.Columns.Add("col6", typeof(System.Int32));
myTable.Rows.Add("1", "1", "1", "1", "1", "1");
myTable.Rows.Add("1", "1", "1", "1", "1", "1");
myTable.Rows.Add("1", "1", "1", "1", "1", "1");
myTable.Rows.Add("1", "1", "1", "1", "1", "1");
myTable.Rows.Add("1", "1", "1", "1", "1", "1");
myTable.Rows.Add("1", "1", "1", "1", "1", "1");
this.fpSpread1.DataSource = myTable;

复制代码

效果图

png

DataTable myTable = new System.Data.DataTable();
myTable.Columns.Add("col1",typeof(System.Double));
myTable.Columns.Add("col2", typeof(System.Double));
myTable.Columns.Add("col3", typeof(System.Double));
myTable.Columns.Add("col4", typeof(System.Double));
myTable.Columns.Add("col5", typeof(System.Double));
myTable.Columns.Add("col6", typeof(System.Double));
myTable.Rows.Add("1", "1", "1", "1", "1", "1");
myTable.Rows.Add("1", "1", "1", "1", "1", "1");
myTable.Rows.Add("1", "1", "1", "1", "1", "1");
myTable.Rows.Add("1", "1", "1", "1", "1", "1");
myTable.Rows.Add("1", "1", "1", "1", "1", "1");
myTable.Rows.Add("1", "1", "1", "1", "1", "1");
this.fpSpread1.DataSource = myTable;
FarPoint.Win.Spread.CellType.NumberCellType numberType = new FarPoint.Win.Spread.CellType.NumberCellType();
numberType.DecimalPlaces = 0;
this.fpSpread1.ActiveSheet.Columns[0].CellType = numberType;