Custom function on summary row

Tags: #<Tag:0x00007efc6d14a468>
#1

  1. Can getCellValue grab a result calculated using columnSummary? (it appears not).

  2. Can a cell formula be specified dynamically using e.g. cellFormula = “’=SUM(”.concat("A3 + B3 + ", anotherCellRef, “)’”); etc.?

  3. Does setDataAtCell update on user input into the table?

Basically I am trying to get a table that does the following:

  1. Take user input first row.
  2. Apply correction factors second row.
  3. Sum and display result third row.
  4. Take third row results and apply custom function (logarithmic sum) and display in new cell.

I can get to step 3, but struggling with step 4. I need the whole thing to update dynamically on user input to first row.

Can anyone tell me the right way to do this?

#2

Hey @hoops78

Please find the answers below

  1. The getCellValue is a method from the Formulas plugin, not the columnSummary. If you need a value from the columnSummary you can just check getDataAtCell.

  2. Here https://github.com/handsontable/formula-parser/blob/develop/src/supported-formulas.js is a list of supported formulas. You are able to use variables (ranges) but the formula is still in alpha stage of development so we do not guarantee its stability

  3. Yes, it also closes the editor once called. (Example https://jsfiddle.net/j2q7d4b9/, open editor for 0, 0)

#3