On Wed, 26 Mar 2008, Keith Bennett wrote:
*Hi, I am new to this list and am new to POI HSSF. I am trying to find a way to programatically invoke the PMT formula and access the resulting value. The code below generates an Excel spreasheet file successfully and even stores the correct value in the A1 cell when I manually open it. However, when I use the HSSFFormulaEvaluator to access the value that the formula computes, I keep getting a CELL_TYPE_ERROR.
Could you upload your code and workbook to a new bugzilla issue? Your email client appears to have added asterisks all over your code, so I'm not able to try it out.
Also, have you ensured that your formula can really be correctly evaluated by excel? Getting back CELL_TYPE_ERROR tends to indicate that that's something up with the formula
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
