Help on Changing Data type

[conx]

is it possible to add the right click option to change the specific column data type or each cell data type??? for eg: dataType:"string" to dataType: "integer"
Because i am not getting =SUM(A1+B1) in column with dataType equals to "string"

[paramvir]

cell dataType remains same for the whole column.

However Excel formulas work fine irrespective of column dataType.

Because i am not getting =SUM(A1+B1) in column with dataType equals to "string"

It's supposed to work even for dataType: string.
Can you please share a small test case via jsfiddle so that I can look into it.

[conx]

A  B     total
5  100   5100
for eg:
=sum(A1+B1) formula on total column shows 5100 instead of 105(which concats the value instead of adding)

(here my dataType is string)

[paramvir]

I'm looking into it. Have you tried =sum(A1,B1)