https://bz.apache.org/bugzilla/show_bug.cgi?id=58877
Bug ID: 58877
Summary: Cannot get a numeric value from a error formula cell
Product: POI
Version: unspecified
Hardware: PC
OS: Linux
Status: NEW
Severity: major
Priority: P2
Component: HSSF
Assignee: [email protected]
Reporter: [email protected]
try {
if (cell.getCellType() == Cell.CELL_TYPE_FORMULA) {
FormulaEvaluator fe =
workbook.getCreationHelper().createFormulaEvaluator();
String formatCellValue = formatter.formatCellValue(cell,
fe);
System.out.println("FE : " + formatCellValue);
}
} catch (NotImplementedException et) {
System.err.println("ERR : " + et.getMessage());
// String j_username = formatter.formatCellValue(cell);
// System.out.println(j_username);
System.out.println(cell.getNumericCellValue());
>From above code, I could get RSQ function cell(formula cell) value by
cell.getNumericCellValue() but after writing it by output stream, I could not
get cell value from output file.
--
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]
