On Thu, 3 Jan 2008, James G. wrote:
I experimented with the formula evaluator and was able to successfully evaluate the formulas. But, there didn't seem to be a way (I may not have dug deep enough) to leave the cell's value as the formula, rather than the result of the formula. I'd like to leave open the ability of the Excel user to update the dependent cells, and still have the formula cell update it's result, after being processed by POI.
You should be able to evaluate the formula, set the value into the cell, but leave the formula there too. I'd suggest checking to docs again
The other drawback to this approach, is that I will ultimately be working with a much larger input file than my simple contrived example. While calculating the result for all the formulas contained in the workbook is not impossible, it's not necessarily desired, and would seem to remove a good deal of flexibility from the input file format.
You'll only need to re-calculate the formulas for where you have changed the source data. The rest can be left alone
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
