DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21885>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21885 #VALUE! Error from setCellFormula("PPMT($C$7/1200, C11, $C$6, $C$5)"); Summary: #VALUE! Error from setCellFormula("PPMT($C$7/1200, C11, $C$6, $C$5)"); Product: POI Version: 2.0-pre2 Platform: PC OS/Version: Windows NT/2K Status: NEW Severity: Normal Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] 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)"); --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
