回复 6楼hyqangel的帖子
“spread for silverlight FarPoint CellType 未定义”问题:
这个问题我看代码中使用的是 Spread form Winforms 平台的 NumberCellType 类型。无法通用两个平台的单元格类型。
并且 spread for silverlight 平台没有单元格类型的概念,是通过格式化单元格来实现的。
实例代码:
- double dvalue = 12345.6789;
- gcSpreadSheet1.Sheets[0].Cells[0, 0].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.StandardNumericMode, "c");
- gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = dvalue;
- gcSpreadSheet1.Sheets[0].Cells[0, 1].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.StandardDateTimeMode, "M");
- gcSpreadSheet1.Sheets[0].SetValue(0, 1, new DateTime(2011, 2, 9));
- gcSpreadSheet1.Sheets[0].Cells[0, 2].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter("m");
- gcSpreadSheet1.Sheets[0].SetValue(0, 2, new DateTime(2012, 10, 15));
- gcSpreadSheet1.Sheets[0].Cells[0, 3].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter();
- gcSpreadSheet1.Sheets[0].SetValue(0, 3, new DateTime(2012, 10, 15));
- gcSpreadSheet1.Sheets[0].Cells[0, 4].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.CustomMode, "#.#%");
- gcSpreadSheet1.Sheets[0].SetValue(0, 4, 1);
- gcSpreadSheet1.Sheets[0].Cells[1, 0].Formatter = new GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.CustomMode, "[>2]0.0;[<-3]0.0;zero;");
- gcSpreadSheet1.Sheets[0].SetValue(1, 0, 3);
- gcSpreadSheet1.Invalidate();
复制代码 |