Sum format


#1

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)”

Next

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?


#2

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.