Author Topic: Excel Formula for columns  (Read 2206 times)

joaosales

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 20
    • View Profile
Excel Formula for columns
« 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,

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Excel Formula for columns
« Reply #1 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