npoi icon indicating copy to clipboard operation
npoi copied to clipboard

Performance issue when adding copied rows

Open Zt-freak opened this issue 2 years ago • 1 comments

When repeatedly adding copied rows to a table, it causes performance issues. It appears this only happens when copying and adding alternate. When all rows are copied first and then added, this does not cause this issue.

Example code, which causes this issue: image

Most likely the collection of visited objects contributes to this issue.

After adding the 6th copied row, visited contains more than 20000 records.

image

I'm using NPOI 2.6.0

Zt-freak avatar Dec 05 '22 10:12 Zt-freak