Thank you Aleksandra,
What if the table is empty at the beginning? and I don’t load any data, where do I set up the formula?
this is what I can’t find, all the examples comes with a data where the formula are written.
on another note, there is really nothing to do try to convert number that were calculated using a custom renderer to actual value…I understand those “value” are just “drawing” but I somehow if I could have them recognize a real value before I do a getSourceData()
basically this is what I was doing
function DecemberRenderer(instance, td, row, col, prop, value, cellProperties) {
Handsontable.renderers.TextRenderer.apply(this, arguments);
var december = Math.round(((instance.getDataAtCell(row, col - 13) / 52)) * 10) / 10 * 5;
td.innerHTML = decemberRounded;
td.style.background = ‘#EEE’;
}