Posted 16 May 2023, 11:50 am EST
I am evaluating Spreadjs and I encounter the same problem.
I have a VBA custom function in Excel (I_COEFMOY(). I load Spreadjs with the Excel file and recreate the same custom function name in Spreadjs.
At the time of loading with spread.fromJSON(json);, I think the function is not recognized and the file reflects the problem.
Even if I add the custom function afterwards with spread.addCustomFunction(oCoefMoy); , the initial state in the way remains as long as I do not make any change in the cell (for example:
sheet.setFormula(7, 5, “FOO()”);
sheet.setFormula(7, 6, “FOO()”);
sheet.setFormula(7, 5, “I_COEFMOY($E9:$E11,F9:F11)”);
sheet.setFormula(7, 6, “I_COEFMOY($E9:$E11,G9:G11)”);
Isn’t there a way to force the recalculation of the entire sheet?
Thank you for your response,