Sum format


Hi Laurence,

sorry keep bugging you guys. I have a issue about the format of SUM

For i As Int32 = 0 To 100

xls.Cells(i, 0).PutValue(99)

xls.Cells(i, 0).Style.Custom = “$#,##0.00;($#,##0.00)”


xls.Cells(“A110”).Formula = String.Format("=SUM(A1:A100)")

The cell A110 is not auto formatted as currency. In Ms-Excel, if I format cells as currency, the sum cell will automatically be formatted to currency. Is that possible to fix it?


You have to format A110 as A1 to A100.

MS Excel is a desktop application while Aspose.Excel is generally used in server environment. So performance is a key issue to Aspose.Excel. Automatically formatting will heavily degrade the performance.