https://issues.apache.org/bugzilla/show_bug.cgi?id=55145
Bug ID: 55145
Summary: #VALUE! error in RANK formula
Product: POI
Version: 3.9
Hardware: PC
Status: NEW
Severity: major
Priority: P2
Component: HSSF
Assignee: [email protected]
Reporter: [email protected]
After executing the code
public static void main(String args[]) throws IOException {
//with #VALUE! error (1)
createExample(new FileOutputStream("1.xls"), new HSSFWorkbook());
//no error (2)
createExample(new FileOutputStream("1.xlsx"), new XSSFWorkbook());
}
private static void createExample(FileOutputStream file, Workbook wb)
throws IOException {
Sheet sh = wb.createSheet("sheet");
Row row = sh.createRow(0);
Cell cell1 = row.createCell(0);
cell1.setCellValue(100);
Cell cell2 = row.createCell(1);
cell2.setCellFormula("RANK(A1,(A1:A1),0)");
wb.write(file);
}
we've got the following result for line (1)
the #VALUE! error in the generated excel file.
This error could be corrected manually if we position the cursor into the
formula bar and press "Enter".
For line (2) there is no error.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
