Posted 8 September 2017, 3:04 pm EST
I'm having a SUM function in a cell that sums the following 4 cells in the same row.
I'm using the MoveRange function to move the 2 last cells in the SUM function further 'down' the same row.<font size="2" face="Consolas"><font size="2" face="Consolas">
SheetView sheet = this.fpSpread1.Sheets;
sheet.AutoCalculation = true;
I would like the cell where SUM function is used to extend its range automatically to include the new location. The same way it is done in Excel.
Is there a way to achieve this?