ParamQuery grid support forum

General Category => Bug Report => Topic started by: conx on May 08, 2020, 01:25:10 pm

Title: Help on Changing Data type
Post by: conx on May 08, 2020, 01:25:10 pm

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"

Title: Re: Help on Changing Data type
Post by: paramvir on May 08, 2020, 03:01:32 pm

cell dataType remains same for the whole column.

However Excel formulas work fine irrespective of column dataType.

Quote

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.

Title: Re: Help on Changing Data type
Post by: conx on May 08, 2020, 04:24:52 pm

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)

Title: Re: Help on Changing Data type
Post by: paramvir on May 08, 2020, 11:29:04 pm

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