Live data from Hacker News

Show HN: React Spreadsheet 2

rowsncolumns.app

81–90 of 144 posts

Re: Show HN: React Spreadsheet 2

#81
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…

The beauty of excel is you can load Million rows and do computations on them.

Re: Show HN: React Spreadsheet 2

#82

Genuine question: Why would anyone purchase this for $299, without the ability to use it commercially? For open-source projects?

Best question, right here. I suspect, someone is relying on there being a Marketplace for "pluggable react components". I know you know...it's a mess...

Re: Show HN: React Spreadsheet 2

#84

Earlier quoted context omitted.

You mentioned physical size of monitors. Does it affect performance in your tests? I would be very, very surprised if performance on 27" 4k monitor was any different than on 42" 4k monitor. Maybe I'm not aware of some quirk?

I have tested on 32" 4K and 27" 4K and there was no performance issues. Slight degradation on Dell 42" 4K, could be because of the ppi or the pixel ratio, which might be causing canvas/row/cell/ dimensions to be not rounded to whole numbers (this can affect perf).

Interesting. Can you elaborate how you measure performance? What's perfoemance? Framer ate, cpu/gpu usage, mem, scroll speed?

Re: Show HN: React Spreadsheet 2

#85

The frequency with which this page crashes with JS errors does not encourage me to use components from this source.

We do not sync the state with a back-end server. Hence when we have collaboration enabled, there can states that go out of sync

You can try single user mode here - https://www.rowsncolumns.app/demo?collab=false

Re: Show HN: React Spreadsheet 2

#87

Earlier quoted context omitted.

Nothing persists. All the diffs are sent over using Supabase and received by all other clients. The diffs are then applied to create the new state.

Seems like it's just being spammed with slurs currently. Might want to add a filter or censoring.

Created a single user demo for peaceful browsing

https://www.rowsncolumns.app/demo?collab=false

Re: Show HN: React Spreadsheet 2

#90
post #74

Earlier quoted context omitted.

Yeah, I am currently in the US, using a MacBook with Japanese locale set.

Awesome. I have fixed this issue for you.

Cool, real-time debugging and deploying a fix in minutes. We've come a long way since the days of shrinkwrapped spreadsheet software sold in a store.
Post reply on HN