Team, is there a way to assign a formula in Aspose.Cells, to a particular range in one go rather assigning formula in each cell of the range. Assigning formula in each is time consuming and need to take care of incrementing row and column indices.
If you are in Excel, copy a formula from a single cell and copy to range, Excel takes care of incrementing row and column indices automatically - which is what I am looking for in Aspose. Equivalent code of VBA/COM approach is given below for your reference. Please let me know.
In this example code, I am reading formula string (stored in 1st row without ‘=’ symbol) and appending ‘=’ and assigning the formula to a range in each column.
For iCol = iFirstCol_FormulaeRange To iLastCol_FormulaeRange If Len(wstData.Cells(1, iCol).Value) <> 0 Then strFormula = "=" & wstData.Cells(1, iCol) wstData.Cells(gc_Template_Start_Row, iCol).Resize(iNoOfRows_Data - gc_Template_Start_Row + 1).Formula = strFormula End If Next iCol