poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Danny Mui <da...@muibros.com>
Subject Re: #VALUE! Error from setCellFormula("PPMT($C$7/1200, C11, $C$6, $C$5)");
Date Thu, 24 Jul 2003 14:16:27 GMT
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: poi-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>  
>


Mime
View raw message