Bug 21885

Summary: #VALUE! Error from setCellFormula("PPMT($C$7/1200, C11, $C$6, $C$5)");
Product: POI Reporter: Jai Kang <jwkang>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P3    
Version: 2.0-pre2   
Target Milestone: ---   
Hardware: PC   
OS: All   
Bug Depends on:    
Bug Blocks: 34973    

Description Jai Kang 2003-07-25 13:55:32 UTC
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)");
Comment 1 Josh Micich 2008-05-05 13:42:55 UTC
Re-tested OK in 3.1-beta1.

Bug was present until 3.0.2.  It looks like the bug was due to incorrect parameter operand classes.  That was fixed in bug 44675.