I’m just starting to look at Hyperformula for our needs with a handsontable grid. Before I dive in, however, I want to know if working with complex data types is possible?
A simple example is, for a given column, we use a custom render/editor, but the data that is returned to the grid is a simple array of objects like this:
Our own custom renderer displays it how we want.
I want to add a new column to the grid to add a formula. Am I able to reference this data object in my formula? Let’s say I want to create a logical formula which will look at the data in this column and show true if one of the array elements contains ‘john’ . Is that possible?
If so, do you have any working examples you could share of how I would do this?
I’m using React and use the HotColumn object to add my columns to the grid. I’m hoping I could add new columns which then reference formula’s?