Hi: I am new to Aspose and find it to be a wonderful tool.
I am creating an excel 2007 spreadsheet. I am using Smart Marker and it is working fine pulling in the data from my application.
My problem is that I would like to sum the contents of the Amount Column, but The contents of the file can change. One week I might have 150 rows the next maybe 100.
I have reviewed the Dynamic formulas and did not see anything that I could use to calculate the total of a Column. I have tried using the sum function in excel But because the rows can vary I don't think I can use them.
Is there a variation of the dynamic formulas that I could use?