Hi Laurence ,
What will be the column width of SUM cell? And also what will be format of SUM cell?
For example,
I have range from A1 to A8 are formatted as currency, and use aspose make the cell A9 as formula=String.format("=SUM({0}:{1})", startcell.name, endcell.name), where startcell will be A1, and endcell will be A8. Will A9 be currency format as well?
If I am using autofitcolumn for the cell A, it will only autosize A1-A8. The A9 looks like recognized as 5 only.
Thank you
- You should format A9 as currency also.
2. Call Excel.CalculateFormula before call autofitcolumn. But please don’t call Excel.CalculateFormula too many times for it’s a time-consuming method.