Live data from Hacker News

Show HN: React-data sheet, Excel-like spreadsheet component

nadbm.github.io

31–40 of 93 posts

Re: Show HN: React-data sheet, Excel-like spreadsheet component

#31

If you can productize this, then you can potentially build a business around this. The most feature filled spreadsheet component today is Handsontable. My company pays for the enterprise version of it...And we wish there was something better.

Link for others: https://handsontable.com/examples.html It's too expensive IMO. But if you are not using it commercially, it's on Github.

You can use the open source version commercially as well, since it is MIT licensed.

Re: Show HN: React-data sheet, Excel-like spreadsheet component

#32
I have spent way too much time building grid components at my company, and I've found that if you have (1) a lot of data, (2) a dense grid, and (3) a grid that occupies most of the screen, THEN the only way to get 30+fps is to use canvas and do all the layout and drawing logic yourself.

Re: Show HN: React-data sheet, Excel-like spreadsheet component

#33

I have spent way too much time building grid components at my company, and I've found that if you have (1) a lot of data, (2) a dense grid, and (3) a grid that occupies most of the screen, THEN the only way to get 30+fps is to use canvas and do all the layout and drawing logic yourself.

canvas would be a pain to have automated test. https://github.com/openfin/fin-hypergrid/issues/540

Re: Show HN: React-data sheet, Excel-like spreadsheet component

#34
Nice!

Lately I have been looking into javascript grid components and have not found a good solution.

What would be a good javascript grid component that satisfies the following: 1. Integrates easily with Vue 2. Has sorting 3. Has grouping 4. Has inline editing (formulas are not required)?

OTOH I would be happy with a software that is basically a web frontend for Postgres that can be customised in a way that a client can only see and edit specific fields based on assigned rights.

Re: Show HN: React-data sheet, Excel-like spreadsheet component

#35

If you can productize this, then you can potentially build a business around this. The most feature filled spreadsheet component today is Handsontable. My company pays for the enterprise version of it...And we wish there was something better.

Link for others: https://handsontable.com/examples.html It's too expensive IMO. But if you are not using it commercially, it's on Github.

no - i dont believe its too expensive. the devs are fairly responsive.

The thing is, it carries too much baggage. It took them many months to even put it on npm. Adding features takes a lot of effort.

Its 149$ for a year - its not at all bad and I love supporting them.

But there's space to innovate - look at Airtable. I would love to have a component that looks like Airtable frontend.

Re: Show HN: React-data sheet, Excel-like spreadsheet component

#36

Nice! Lately I have been looking into javascript grid components and have not found a good solution. What would be a good javascript grid component that satisfies the following: 1. Integrates easily with Vue 2. Has sorting 3. Has grouping 4. Has inline editing (formulas are not required)? OTOH I would be happy with a software that is basically a web frontend for Postgres that can be customised in a way that a client…

> Integrates easily with Vue

IMO grids (and trees, etc.) only work well if they are framework-specific.

Here's a table that could evolve into an editable grid:

http://element.eleme.io/#/en-US/component/table

Re: Show HN: React-data sheet, Excel-like spreadsheet component

#37
post #28

If you can productize this, then you can potentially build a business around this. The most feature filled spreadsheet component today is Handsontable. My company pays for the enterprise version of it...And we wish there was something better.

What's wrong with Handsontable? It looks pretty good to me.

Agreed, I just played with the demo and it's pretty dang slick.

Re: Show HN: React-data sheet, Excel-like spreadsheet component

#39
post #17
post #11

This looks really great, and I've got an immediate use for something like this. I've been using ag-grid for presentation of grid-based data, but this looks ideal for more-interactive views. I look forward to putting it through its paces. Somewhat off-topic, but for those working in React, have you built large systems using Redux? I'm fairly early in what is likely to ultimately be a large-ish application, and while I…

I have made several relatively large systems using Redux, and it has become a necessity in order to handle complexity of new features. Overcoming the initial cognitive load takes a week or two, but as your system grows, your productivity and code organization is greatly improved. I also recommend Immutable for handling the state object and reselect for computing your container state properties. Those technologies tog…

How does https://github.com/kolodny/immutability-helper compare to Immutable in your experience? The latter seems potentially more performant and lighter-weight; curious what its disadvantages might be (the syntax?)

Re: Show HN: React-data sheet, Excel-like spreadsheet component

#40

I have spent way too much time building grid components at my company, and I've found that if you have (1) a lot of data, (2) a dense grid, and (3) a grid that occupies most of the screen, THEN the only way to get 30+fps is to use canvas and do all the layout and drawing logic yourself.

Or you can do what google sheets does: only draw N cells at any time, and just change their contents depending on where you are scrolled to.
Post reply on HN