I have a source workbook where I have two sheets named ‘Data’ and ‘Calculations’. using Aspose I will copy these, calculate and export the output excel. In ‘Data’ sheet I will add dynamic data using code and in sheet ‘Calculations’ I will set the static complex formulas for a row, that row cells formula contains the data from ‘Data’ sheet for calculation. For example if the Data Sheet contains 1000 dynamic rows then I need to calculate 1000 rows in ‘Calculations’ sheet. How can I Roll out the formula from each cell to 1000 rows in Calculations Sheet? (Note: the rows are not consistent to 1000)
Any example related to this greatly appreciated.
Thanks in Advance