FP 6.0 小数位超过4位如何禁用科学计数法

收藏

FarPoint.Web.Spread.DoubleCellType objNumCell = new FarPoint.Web.Spread.DoubleCellType() ;
objNumCell.DecimalDigits = 6 用公式进行计算的时候如果结果是0.00001 就自动科学计数法计算了如何禁止

iceman · iceman

回复 1楼cngrain的帖子

可以使用 GeneralCellType 来替代：

protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
FarPoint.Web.Spread.GeneralCellType objNumCell = new FarPoint.Web.Spread.GeneralCellType();
System.Globalization.NumberFormatInfo nfi = new System.Globalization.NumberFormatInfo();
nfi.NumberDecimalDigits = 6;
nfi.NumberDecimalSeparator = ",";
objNumCell.NumberFormat = nfi;
FpSpread1.ActiveSheetView.Cells[0, 2].Formula =
"SUM(" + FpSpread1.ActiveSheetView.Cells[0, 0].Column.Label.ToString() + FpSpread1.ActiveSheetView.Cells[0, 0].Row.Label.ToString() +
"," + FpSpread1.ActiveSheetView.Cells[0, 1].Column.Label.ToString() + FpSpread1.ActiveSheetView.Cells[0, 1].Row.Label.ToString() +
")";
this.FpSpread1.Sheets[0].Cells[0,0].CellType=objNumCell;
this.FpSpread1.Sheets[0].Cells[0,1].CellType=objNumCell;
}

复制代码

		自动登录	找回密码
密码			立即注册

[已处理] FP 6.0 小数位超过4位如何禁用科学计数法

1 个回复

活字格认证

微信认证勋章

元老葡萄