| Summary: | Error Setting formula for a cell | ||
|---|---|---|---|
| Product: | POI | Reporter: | Somendra Chathurvedi <somendra_99> |
| Component: | HSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED FIXED | ||
| Severity: | critical | ||
| Priority: | P3 | ||
| Version: | 2.0-FINAL | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Windows XP | ||
| Bug Depends on: | |||
| Bug Blocks: | 34973 | ||
|
Description
Somendra Chathurvedi
2004-03-29 20:06:20 UTC
Looks like this was fixed a while ago.
Here is a new junit test method just in case.
public void test_bug28031() {
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet();
wb.setSheetName(0, "Sheet1");
HSSFRow row = sheet.createRow(0);
HSSFCell cell = row.createCell((short)0);
String formulaText = "IF(ROUND(A2*B2*C2,2)>ROUND(B2*D2,2),ROUND(A2*B2*C2,2),ROUND(B2*D2,2))";
cell.setCellFormula(formulaText);
assertEquals(formulaText, cell.getCellFormula());
if(false) {
// this file can be inspected manually
try {
OutputStream os = new FileOutputStream("output28031.xls");
wb.write(os);
os.close();
} catch (IOException e) {
throw new RuntimeException(e);
}
}
}
To be absolutely sure, I opened the file in Excel, and made sure the formula was correct there too. I left that bit of the test disabled because I assume the rest of the test alone would have shown this bug.
|