Win form spread 5.0 .net number列设置小数点后位数

收藏

spread 5.0 for .net win form 将表格某一列设置为number，如何设置小数点后的位数谢谢

iceman · iceman

回复 1楼wangfabei1989的帖子

请使用以下代码测试，DecimalPlaces 属性控制小数位数：

FarPoint.Win.Spread.CellType.NumberCellType num = new FarPoint.Win.Spread.CellType.NumberCellType();
num.DecimalPlaces = 3;
num.DecimalSeparator = ",";
num.FixedPoint = true;
num.LeadingZero = FarPoint.Win.Spread.CellType.LeadingZero.UseRegional;
num.MaximumValue = 50000.0;
num.MinimumValue = -1000.0;
num.NegativeFormat = FarPoint.Win.Spread.CellType.NegativeFormat.Parentheses;
num.NegativeRed = true;
num.Separator = "/";
num.ShowSeparator = true;
num.SpinButton = true;
num.SpinDecimalIncrement = 10;
num.SpinIntegerIncrement = 5;
num.SpinWrap = true;
fpSpread1.ActiveSheet.Cells[0, 0].CellType = num;
fpSpread1.ActiveSheet.Cells[0, 0].Value = -443.0908;

复制代码

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

[已处理] Win form spread 5.0 .net number列设置小数点后位数