We currently have a long running excel spreadsheet which can take a full day to complete on a pc, we have access to very fast servers but they dont run excel so I was hoping to use NPOI to get around this
I have two questions which I hope you can help me with;
1) I only need two output values from this calculation, will EvaluateFormulaCell calculate the precedent cells before calculating the final cell? Ie I only need to call EvaluateFormulaCell on my two cells of concern to yield the
correct ans. I don't care if the cell values are not written to the intermediate cells.
2) How do I create\add functions, for example I notice the "Now()" function is missing, how do I add this so that the Evaluate functions use it?