Thanks, Nick. Per your request, I've created Bug 44691. Yes, I have verified that the formula is correctly evaluated by Excel. I appreciate you looking at this. What I'm trying to do with HSSF is use it to compute the PMT value and use this value in my system without having to generate an actual .xls file. I simply generated the .xls file in my test code to ensure that the formula is good. If I can do this, it will be a solution that my client will absolutely love. I really like the work you've done. It's a very useful framework.
Keith On 3/27/08, Nick Burch <[EMAIL PROTECTED]> wrote: > > 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] > >
