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

111–120 of 144 posts

Re: Show HN: React Spreadsheet 2

#111

Post by rowsncolumns »

eek2121 wrote: post #109
rowsncolumns wrote: post #45

Earlier quoted context omitted.

The demo does not use a back-end service. We are agnostic to back-end frameworks. Some users have used Prisma + Graphql, NoSQL databases etc. The Sheet data structure on the UI can be flexible too. It can come from streaming data source, lazily loaded on-demand or all stored in browser memory

Admittedly, I haven't clicked on the link, but you appear to have avoided their question altogether. You offer product demos. Those demos source data from something, be it a JSON file, REST API, etc. Where is the demo data sourced from?

The demo data is sourced partially from US Covid database.

Re: Show HN: React Spreadsheet 2

#112

Post by jraph »

bugsmith wrote: post #77

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

Open source licenses allow commercial use so probably not fit for Open Source. If your project is NC it can't be open source.

So yeah, I don't know who would be the target, probably very niche.

Re: Show HN: React Spreadsheet 2

#113

Post by doix »

mklepaczewski wrote: post #41
rowsncolumns wrote: post #24

Earlier quoted context omitted.

Yes it is. The Spreadsheet is powered by ReactJS and Konva. React and Konva provides a Profiler and Devtools to measure performance and to prevent any un-necessary re-renders. We also measure the Canvas FPS to make sure rendering is at max 60fps. The bottleneck we have identified is with scrolling large amounts of text, especially in large 42 inch 4K monitors, where FPS limits to 55-60fps. We do have some workaround…

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?

It's usually the scaling. If you're on 27" at 4k, you probably have some scaling enabled, anywhere from 1.25x to 2x, so less stuff fits on the screen. Since less stuff fits on the screen, less stuff gets rendered and performance should be better.

At 42" 4k, there's probably no scaling, so more stuff fits on the screen.

Re: Show HN: React Spreadsheet 2

#116

Post by larodi »

This absolutely looks amazing. But I also love this process of reinventing the electronic table (spreadsheet), and the columnar-text altogether. 10 more years and we're back in 1982.

I would say that the spreadsheet-like data view is a must-do in the career of the UI person. But then this all, without proper back-end wired to it, means very little to the overall product experience. In fact - proper back-end with not-so-cool UI may deliver quite the experience...

Re: Show HN: React Spreadsheet 2

#117

Post by RyanHamilton »

jz391 wrote: post #23
The_Colonel wrote: post #13

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.

I've used Slickgrid (open source, https://slickgrid.net/ ) with some success.

Slick grid is awesome https://www.timestored.com/data/slick-grid-review

Re: Show HN: React Spreadsheet 2

#118

Post by mattlondon »

rowsncolumns wrote: post #2

Create your own Google sheets like Spreadsheet UI in your application using RowsnColumns Spreadsheet 2. Declaratively render cells, embed external content, use custom formulas, collaborate with other users all using composable ReactJS UI components. https://www.rowsncolumns.app/

Curious: since you are rendering everything via canvas, how do you do accessibility?

Re: Show HN: React Spreadsheet 2

#119

Post by rowsncolumns »

mattlondon wrote: post #118
rowsncolumns wrote: post #2

Create your own Google sheets like Spreadsheet UI in your application using RowsnColumns Spreadsheet 2. Declaratively render cells, embed external content, use custom formulas, collaborate with other users all using composable ReactJS UI components. https://www.rowsncolumns.app/

Curious: since you are rendering everything via canvas, how do you do accessibility?

For screen readers, we are planning to add table element with plain text content, with aria regions.

We offer support for keyboard shortcuts and navigation, and our platform is natively compatible with both light and dark modes.

We also provide the option for developers to customise themes, ensuring optimal accessibility for users with low/tunnel vision.

Re: Show HN: React Spreadsheet 2

#120

Post by eviks »

baz00 wrote: post #51
_istanbul_ wrote: post #28

Earlier quoted context omitted.

I don't understand your comment. It's not far fetched to have millions of rows to handle. I myself have about 12 million rows (notes mainly), although I don't load everything at the same time, so maybe you're referring to that aspect?

It's pushing the boundaries of a spreadsheet's practical usability to be honest. I would not use it for more than a few hundred at most. In fact I just checked my largest sheet is 292 rows. Anything larger goes in anything else! Usually I use SQLite for local storage data like that now. A funny problem I had a few years back was a company with users keeping 200 meg+ Excels sheet on their desktops. It took them foreve…

How to you get immediate feedback while doing edits/calculations and also collaborate after you stash your data in anything else?
Post reply on HN