Yes, I have submitted this as a Bug (# 21885) as you suggested.
Jai
----- Original Message -----
From: "Danny Mui" <[EMAIL PROTECTED]>
Newsgroups: gmane.comp.jakarta.poi.user
Sent: Thursday, July 24, 2003 10:16 AM
Subject: Re: #VALUE! Error from setCellFormula("PPMT($C$7/1200, C11, $C$6,
$C$5)");
> Can you submit this as a bug so we don't lose track?
>
> http://nagoya.apache.org/bugzilla/enter_bug.cgi
>
> Jai W. Kang wrote:
>
> >Hello,
> >
> >
> >
> >I am new to the POI. It looks very promising, and especially I'm
interested
> >in using the HSSF to generate Excel files from Java program.
> >
> >
> >
> >One problem I have right now is as follows:
> >
> >
> >
> >Below is a part of my source codes to write formulas (PMT & PPMT) using
the
> >setCellFormula. It works OK for PMT, but it does not with PPMT. When I
open
> >the xls file, the cell has an error: ( #VALUE!) even though the formula
bar
> >shows right formula (=PPMT($C$7/1200,C11,$C$6,$C$5). It is so strange
that
> >the cell becomes OK when I either double click the cell itself, or press
> >Enter key at the end of the formula in the cell's formula bar.
> >
> >
> >
> >
> >
> >HSSFRow r10 = sheet.createRow((short)10);
> >
> >
> >
> >HSSFCell r10c3 = r10.createCell((short)3);
> >
> >r10c3.setCellFormula("PMT($C$7/1200,$C$6,$c$5,0)");
> >
> >
> >
> >HSSFCell r10c4 = r10.createCell((short)4);
> >
> >r10c4.setCellFormula("PPMT($C$7/1200, C11, $C$6, $C$5)");
> >
> >
> >
> >
> >
> >I'd appreciate very much for any help.
> >
> >
> >
> >Best regards,
> >
> >
> >
> >Jai
> >
> >
> >
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
> >
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
