Skip to content
New issue

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

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

Already on GitHub? Sign in to your account

Textbreak (tb) makes Sheet very laggy - Performance Issues Bug #610

Open
Erivess opened this issue Oct 10, 2024 · 4 comments
Open

Textbreak (tb) makes Sheet very laggy - Performance Issues Bug #610

Erivess opened this issue Oct 10, 2024 · 4 comments

Comments

@Erivess
Copy link

Erivess commented Oct 10, 2024

Im encountering significant performance issues when using fortunesheet to render Excel files that have around 40 or more rows and 3-4 containing a lot of text. The spreadsheet becomes quite laggy and impossible to work on. We do not use any editing operations and just use fortunesheet to "view" the excel file.

I'm wondering if there's a way to optimize fortunesheet for better performance with larger datasets - even tho I would not consider 40 rows a "large dataset".

Does fortunesheet support virtualization or any performance enhancements for big data sets?

Happy for any help.

@sanchit3008
Copy link
Collaborator

that should not be happening, i have used this package for sheets with 10k+ rows. you might want to relook at your implementation.

@Corbe30
Copy link
Contributor

Corbe30 commented Oct 28, 2024

Hi @Erivess! Do your cells data have line breaks? If so, it may be linked to #578.
If not, check for accidental re-renders in your implementation.

@Erivess
Copy link
Author

Erivess commented Oct 28, 2024

@Corbe30 @sanchit3008 Yes, we already identified the issue: We defined tb for every single cell and that caused the lag. After removing it from every cell, the lag disappeared.

@Erivess Erivess closed this as completed Oct 28, 2024
@Erivess Erivess reopened this Oct 28, 2024
@Erivess Erivess closed this as completed Oct 28, 2024
@Erivess Erivess reopened this Nov 13, 2024
@Erivess Erivess changed the title Laggy & bad performance with files containing a lot of text? Textbreak makes Sheet very laggy - Performance Issues Bug Nov 13, 2024
@Erivess Erivess changed the title Textbreak makes Sheet very laggy - Performance Issues Bug Textbreak (tb) makes Sheet very laggy - Performance Issues Bug Nov 13, 2024
@Corbe30
Copy link
Contributor

Corbe30 commented Nov 20, 2024

Hi @Erivess, we have fixed the performance issue with tb in the new release v0.19.18! Let me know if you're still facing the issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants