ParamQuery grid support forum

General Category => ParamQuery Pro Evaluation Support => Topic started by: joaosales on March 15, 2018, 06:15:27 pm

Title: Excel Formula for columns
Post by: joaosales on March 15, 2018, 06:15:27 pm

Hi,

I would like to create a table based on some customization that I read from a json and one of the things i would like to do is  associate a column with an excel formula,
so for example, i would define 3 columns (A,B,C) and would  have info saying that column C is SUM(A[row];B[row]).
I know you can use formulas and create a function based on the ui rowData, but i would like to know if it is possible to pass a excel formula as the dataIndx for a column.


Thanks,

Title: Re: Excel Formula for columns
Post by: paramvir on March 16, 2018, 09:31:47 pm

Excel formulas can be predefined in JSON data as shown in this example:

https://paramquery.com/pro/demos/excel_formula