https://issues.apache.org/bugzilla/show_bug.cgi?id=50384
Summary: Some formulas/macros are giving #VALUE! error on Excel
file(.XLS).
Product: POI
Version: 3.7
Platform: PC
Status: NEW
Severity: critical
Priority: P1
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected]
Code :
cell.setCellFormula(formulaValue);
cell.setCellType(Cell.CELL_TYPE_FORMULA);
formualValues not working :
=+(SUBTOTAL(109,(INDIRECT(ADDRESS(ROW()+2,COLUMN())):INDIRECT(ADDRESS(ROW()+1000,COLUMN())))))
=IF(ISBLANK('Export Data'!B3),"",IF(LEFT('Export
Data'!B3,3)="%%%","",VALUE(TRIM(CLEAN('Export Data'!B3)))))
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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]
