[Bug 56440] removeRow in XSSF is much slower than with HSSF

[bu...@apache.org]

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

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |WONTFIX

--- Comment #10 from Dominik Stadler <do...@gmx.at> ---
I tried a few local optimizations, but none really made a difference, the
cleanup of formulas on cell removal is unfortunately deeply intertwined with
Cell removal and there is no easy way to kind of "remember" all the removed
cells and do the operation in bulk at the end. 

So as long as nobody else comes up with a clever way of doing something like
this while still keeping the code in maintainable order I don't think we can do
much, removing many formulas is also likely not something that many people
perform all the time. 

If you want to take a look at improving this then you probably need to look at
starting in XSSFRow.removeRow() which calls XSSFRow.removeCell() and from there
directs to XSSFWorkbook.onDeleteFormula()...

Anyway I am closing this WONTFIX now until there is some code-idea of how it
can be done better.

-- 
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