Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: React Spreadsheet 2

rowsncolumns.app

Post reply on HN
Print view View original

1–10 of 144 posts

Re: Show HN: React Spreadsheet 2

#4

Post by rowsncolumns »

torunar wrote: post #3

Is it able to handle tables with 1,000,000+ rows?

I think the question can be will a user wants to see 1M rows at a time. Probably no.

Spreadsheet uses virtualisation to display data, ie only data viewable in a Row x Column viewport is displayed. This improves rendering performance.

Data performance can be improved by 1. Lazy loading data or Infinite scrolling. We have a built-in async hook that does this. 2. Only save pointers to data that is being displayed. So if you have 1M rows, on the JavaScript side, you only load 100 rows in memory and when user scrolls, you can replace this rows with new data. This will make the browser happy. 3. Streaming data from the server similar to google sheets.

But to answer your question, we have a Max row limit of 1_048_576 and max column limit of 16_384

Re: Show HN: React Spreadsheet 2

#5

Post by mhitza »

rowsncolumns wrote: post #4
torunar wrote: post #3

Is it able to handle tables with 1,000,000+ rows?

I think the question can be will a user wants to see 1M rows at a time. Probably no. Spreadsheet uses virtualisation to display data, ie only data viewable in a Row x Column viewport is displayed. This improves rendering performance. Data performance can be improved by 1. Lazy loading data or Infinite scrolling. We have a built-in async hook that does this. 2. Only save pointers to data that is being displayed. So if…

I'm checking it out on my phone and scrolling through the interface is pretty choppy, but rather fluid in a Google sheet. Maybe you might be able to further tweak the virtual row rendering?

Props for the fact that when I scroll a bit faster things don't disappear, which I've seen before in SPAs with infinite scroll.

Re: Show HN: React Spreadsheet 2

#7

Post by cdmckay »

mhitza wrote: post #5
rowsncolumns wrote: post #4

Earlier quoted context omitted.

I think the question can be will a user wants to see 1M rows at a time. Probably no. Spreadsheet uses virtualisation to display data, ie only data viewable in a Row x Column viewport is displayed. This improves rendering performance. Data performance can be improved by 1. Lazy loading data or Infinite scrolling. We have a built-in async hook that does this. 2. Only save pointers to data that is being displayed. So if…

I'm checking it out on my phone and scrolling through the interface is pretty choppy, but rather fluid in a Google sheet. Maybe you might be able to further tweak the virtual row rendering? Props for the fact that when I scroll a bit faster things don't disappear, which I've seen before in SPAs with infinite scroll.

Feels pretty smooth on my iPhone 13.

Re: Show HN: React Spreadsheet 2

#9

Post by philipwhiuk »

It crashed:

    139-d48f98f3a9d41491.js:1 TypeError: Cannot read properties of undefined (reading 'rowCount')
    at nI (561-5e048c82ab8ff4d8.js:5:68277)
    at e (452-22edc4adb41de58f.js:1:1090692)
    at rs (2443530c-0641256dae818679.js:9:38883)
    at lg (2443530c-0641256dae818679.js:9:54218)
Post reply on HN