131–140 of 144 posts
Is it able to handle tables with 1,000,000+ rows?
Oh you’re one of those users. Prepares LART.
Is this related to the react-spreadsheet[1] project? Where does the "React Spreadsheet 2" from the title come from? It's not clear if this is an update to the project, a fork of an existing project, or something brand new. [1] - https://www.npmjs.com/package/react-spreadsheet
Hi, Its not related to that project. Its an update to an already existing project under RownsColumns, hence the name.
Earlier quoted context omitted.
Hi, Its not related to that project. Its an update to an already existing project under RownsColumns, hence the name.
So did you just steal the name of another component?
I once wrote a React app with was essentially a spreadsheet view, except each sheet was a "table", and tables could be related to one another via columns which were belongs to/has many types.
Writing the front end and back end for this was one of the most complicated things I've ever worked on. I'd love to try it again at my current stage of knowledge and experience.
Is there some capable fully open source data grid providing spreadsheet functionality? Commercial / open-core are a no-go for me, since my goal is to integrate it into an open source project.
This one points to https://github.com/rowsncolumns/spreadsheet but it's 404 and I couldn't see the license.
Earlier quoted context omitted.
In-house tools, reports, dashboards.
Let's be real - why would you use anything but excel for this?
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…
The beauty of excel is you can load Million rows and do computations on them.
Scrolling the sheet on my pixel 4a is very laggy. Is this server latency or client side lag?
I will do some testing on Pixel phones soon. This should be a client-side UI lag. No server is used for the demo. Thanks for the feedback
Great work! What about rendering it to SVG instead of canvas, with a buffer area around and let the scroll take care of itself?
Personally I found canvas easier to work with, scroll performance was better, less browser bugs, drawing was cheaper and scales for large content (using virtualisation or multiple canvas layers)