I have an excel file which does some complex logic calculation on input of values into the cells. I wrote a javascript node app to pass the input values and read the output but it seems like the excel does not do the calculation and give the new values. Is this do-able by some other approach? I have a time constraint for converting all the excel formula logic to javascript so thought of doing that.
Asked
Active
Viewed 220 times
0
-
let me see if i got it right... your excel already have formulas and they aren't updating theys values when you insert data via javascript? – dot.Py Jul 01 '16 at 10:40
-
you got it right. @dot.Py – Adnan Hussein Jul 01 '16 at 10:46
1 Answers
0
Probably your Calculation Method is set to manual.
To change this to automatic:
2003: Tools > Options > Calculation > Calculation > Automatic.
2007: Office button > Excel options > Formulas > Workbook Calculation > Automatic.
2010/2013: File > Options > Formulas > Workbook Calculation > Automatic.
Or you can find a way to press Ctrl+F9 to refresh your calculations.
dot.Py
- 5,007
- 5
- 31
- 52