[Bug 60397] very slow Cell Merge for SXSSFWorkbook

[bu...@apache.org]

https://bz.apache.org/bugzilla/show_bug.cgi?id=60397

--- Comment #4 from Javen O'Neal <on...@apache.org> ---
It would probably be faster for us to read the merged regions into a java List
and discard the CTMergedRegions, operate on the Java List, and then recreate
the CTMergedRegions XML nodes when writing the workbook. Not sure whether this
would improve the speed here, but I'm guessing worksheet.getMergeCells() and
ctMergeCells.addNewMergeCell() are expensive calls since it's creating and
linking XML nodes in a DOM. This work could be deferred to when the workbook is
written out.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org