回复 7楼iceman的帖子
在模板中定义一行,在此行中定义了各单元格的格式(颜色字体大小)及计算公式,程序通过后台查询得到多行记录,
然后动态创建行,然后复制此行的格式到其它新增行,求这样的实现代码
代码如下,其中注意 CopyToOption 参数的设置:
- public MainPage()
- {
- InitializeComponent();
- this.gcSpreadSheet1.Sheets[0].Cells[0, 0].Text = "12";
- this.gcSpreadSheet1.Sheets[0].Cells[0, 1].Text = "12";
- System.Windows.Media.Brush brush = new System.Windows.Media.SolidColorBrush(Colors.Red);
- this.gcSpreadSheet1.Sheets[0].Cells[0, 0].Background = brush;
- this.gcSpreadSheet1.Sheets[0].Cells[0, 2].Formula = "SUM(A1:B1)";
- this.gcSpreadSheet1.Sheets[0].CopyTo(0, 0, 1, 0, 1, 3, GrapeCity.Windows.SpreadSheet.Data.CopyToOption.Formula| GrapeCity.Windows.SpreadSheet.Data.CopyToOption.Style);
- }
复制代码 |