能不能根据分组信息自动生成公式,比如取到分组的开始行和结束行后:
var row = groupStartRow, column = 2, rowCount = groupEndRow - groupStartRow + 1, columnCount = 1;
sheet.setFormula(groupEndRow + 1, column, GC.Spread.Sheets.CalcEngine.rangeToFormula(new GC.Spread.Sheets.Range(row, column, rowCount, columnCount))); |