sum function within excel

[Administrator]

hello!

what do i wrong?

I add some values to gridcells

gridcontrol(1,2).text = 500
gridcontrol(2,2).text = 700

If i export the grid to excel, i'm not able
to use the internal sumfunction of excel.
Within the excelsheet all cells are formated
as text?

any idea?

Best Regards,
Boris

[Administrator]

Hi Boris,

Try setting the CellValueType property of the GridStyleInfo to System.Int32. Here is a code snippet.

gridcontrol(1,2).text = 500
gridcontrol(1,2).CellValueType = System.Type.GetType("System.Int32")
gridcontrol(2,2).text = 700
gridcontrol(2,2).CellValueType = System.Type.GetType("System.Int32")

Best Regards,
Haneef

[Administrator]

Perfect! It works!

Thank you....