电子表格齿轮列和计算
本文关键字:计算 电子表格 | 更新日期: 2023-09-27 18:09:47
是否可以设置列第一上的公式说"=SUM(A1:A10)",然后显示A1到A10单元格中的值,然后进行计算
是的,我得到了答案。在做一些研发的时候,我意识到公式操作是不工作与:
SpreadsheetGear.IRange range = WorkBookViewForData.ActiveWorksheet.Cells["A10"];
range.Formula = "=SUM(A1:A9)"
SpreadsheetGear.IRange range1 = WorkBookViewForData.ActiveWorksheet.Cells["A1"];
range1.value = "1"
SpreadsheetGear.IRange range2 = WorkBookViewForData.ActiveWorksheet.Cells["A2"];
range2.value = "2"
SpreadsheetGear.IRange range3 = WorkBookViewForData.ActiveWorksheet.Cells["A3"];
range3.value = "3"
但是与
一起工作 SpreadsheetGear.IRange range = WorkBookViewForData.ActiveWorksheet.Cells["A10"];
range.Formula = "=SUM(A1:A9)"
WorkBookViewForData.ActiveWorksheet.Cells["A1"].Value="1";
WorkBookViewForData.ActiveWorksheet.Cells["A2"].Value="2";
WorkBookViewForData.ActiveWorksheet.Cells["A3"].Value="3";
其中WorkBookViewForData是电子表格齿轮控件的名称
尝试使用:
totalCell.Formula = "=SUM(C6,C11,C16,C21)";
详细代码请参考以下链接:
http://www.spreadsheetgear.com/support/samples/srcview.aspx?file=outline.aspx