News for hackers. Stuff that matters.
Re:React Spreadsheet 2 – Your Own Google Sheets by rowsncolumns on Thursday November 23, 2023 @08:23AM (#38392461)
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:React Spreadsheet 2 – Your Own Google Sheets by mhitza on Friday November 24, 2023 @02:41PM (#38407398)
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:React Spreadsheet 2 – Your Own Google Sheets by rowsncolumns on Friday November 24, 2023 @03:33PM (#38407934)
Could you share which phone you were using? We use virtual rendering at both row and column level.
Re:React Spreadsheet 2 – Your Own Google Sheets by mhitza on Friday November 24, 2023 @04:03PM (#38408307)
I'm on a Fairphone 4 with Firefox, but I guess it would be the same on any midrange phone.
Re:React Spreadsheet 2 – Your Own Google Sheets by rowsncolumns on Friday November 24, 2023 @04:22PM (#38408508)
Got it. I will try to do some performance testing on midrange phones and mobile firefox. Thanks
Re:React Spreadsheet 2 – Your Own Google Sheets by cdmckay on Friday November 24, 2023 @02:55PM (#38407543)
Feels pretty smooth on my iPhone 13.
Re:React Spreadsheet 2 – Your Own Google Sheets by wouldbecouldbe on Friday November 24, 2023 @06:37PM (#38409601)
The beauty of excel is you can load Million rows and do computations on them.
Re:React Spreadsheet 2 – Your Own Google Sheets by leptons on Saturday November 25, 2023 @01:16PM (#38415270)
Excel is probably the wrong tool for that job. At the scale of a million rows or more, this is probably better done by a real database and programming language.