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]
