https://bz.apache.org/bugzilla/show_bug.cgi?id=66607
Bug ID: 66607
Summary: Slow method: XSSFSheet.isCellInArrayFormulaContext
Product: POI
Version: 5.2.3-FINAL
Hardware: PC
OS: Linux
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: x-apa...@xehonk.de
Target Milestone: ---
I'm using the XSSF parser to read a rather large excel sheet with several
thousand array formulas. This takes about 30 seconds with the current code,
because cell.getRowIndex() is rather expensive and called inside a loop for
each array formula.
Simply moving that call out of the loop reduces the time to about 3 seconds.
The handling is still not optimal (looping through each formula for each cell
still), but better already.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
