Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Empty cells are skipped while using SXSSF objects #436

Closed
ikarol opened this issue Oct 12, 2020 · 0 comments · Fixed by #437
Closed

Empty cells are skipped while using SXSSF objects #436

ikarol opened this issue Oct 12, 2020 · 0 comments · Fixed by #437

Comments

@ikarol
Copy link

ikarol commented Oct 12, 2020

Hi,

I'm creating cells based on incrementing index and list with values.
Sometimes(based on the value), the value from the list is getting skipped(and index is still getting incremented) which results in a cell not being created for that value.
When I'm using SXSSF objects, those empty cells are absent and all remaining cells are getting shifted.
Though, with XSSF objects, those empty cells are in place and the data is inserted correctly.

Please see https://github.com/ikarol/npoi-test/blob/main/Program.cs, for a simplified example

Thanks

tony1223 added a commit to tony1223/npoi that referenced this issue Oct 12, 2020
tonyqus added a commit that referenced this issue Dec 8, 2020
	fix issue #436 skipped cell issue
@tonyqus tonyqus added this to the NPOI 2.5.3 milestone Apr 17, 2021
@tonyqus tonyqus changed the title Shifted cells while using SXSSF objects Empty cells are skipped while using SXSSF objects Apr 17, 2021
# for free to join this conversation on GitHub. Already have an account? # to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants