General Questions

Sep 9, 2010 at 11:48 PM

Hi,

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?

 

Thanks,

Ger.