你指的设置“千位分隔符”不起作用,能详细描述一下吗,我使用下面的代码保存的Excel没有发现什么问题,能否把你的测试工程发给我看一看。
- protected void Page_Load(object sender, EventArgs e)
- {
- if (!IsPostBack)
- {
- FarPoint.Web.Spread.GeneralCellType generalCellType1 = new FarPoint.Web.Spread.GeneralCellType();
- generalCellType1.NumberFormat = ((System.Globalization.NumberFormatInfo)(new System.Globalization.CultureInfo("zh-CN", false).NumberFormat.Clone()));
- generalCellType1.NumberFormat.NumberGroupSeparator = ",";
- generalCellType1.NumberFormat.NumberGroupSizes = new int[] { 3 };
- this.FpSpread1.Sheets[0].Cells[0, 0].CellType = generalCellType1;
- this.FpSpread1.Sheets[0].Cells[0, 0].Value = -55123456;
- }
- }
- protected void Button1_Click(object sender, EventArgs e)
- {
- FpSpread1.ActiveSheetView.Protect = false;
- FpSpread1.SaveExcelToResponse("test.xls");
- }
复制代码 |