Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

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

nadbm.github.io

Post reply on HN
Print view View original

21–30 of 93 posts

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

#21

Post by clishem »

hive_mind wrote: post #12
euroclydon wrote: post #2

Looks beautiful!! But, I can just imagine running this one by the patent attorneys as an open source library to include in our product.

Why the downvotes? This person is describing a real problem with dealing with staff patent attorneys. This is real life.

If you think it's a constructive comment I'll be writing a bot that scans pages posts on HN, looks on the page for a GitHub link and complains about the license used. Doesn't matter if it's GPL, MIT, Apache, I'll just write some generic comment complaining about each license.

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

#24

Post by degenerate »

sandGorgon wrote: post #23

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.

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

#25

Post by shaneos »

nadimisl wrote: post #16
hultner wrote: post #15

Any data on how this performs on large datasets? I've previously found that most web based data grids get extremely slow on larger data sets in BI applications (100k+ rows)

Definitely not meant for large datasets. I've tried it with about 100rows and pagination. I would work with react-virtualized for datasets that large

If that is the case, then this would have avoided the real problem that needs solving here. Throwing together some rendering and keyboard handling is not game changing. Getting good performance is the hard problem that needs solving.

Perhaps a future version will focus on making sure it scales?

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

#26

Post by tlrobinson »

misiti3780 wrote: post #18

I am working with two separate clients that need excel spreadsheet functionality in a browser. I evaluated all of the existing open source projects (this wasnt available at the time) and ended up going with fix-data-table-2 (fork of facebooks fix-data-table). fix-data-table is performant and easily extendable. I was able to create an editable grid similar to googlesheets in a months worth of work. working on open sou…

React Virtualized is also great: http://www.reactvirtualized.com

We (Metabase) switched from FixedDataTable to React Virtualized and are happier with it. The only major issue with it is doesn't have fixed columns/rows built in, but it's pretty easy to compose a couple Grids with ScrollSync to get that behavior (https://bvaughn.github.io/react-virtualized/#/components/Scr...)

FixedDataTable has performance issues with a larger number of columns because it doesn't "virtualize" columns (https://github.com/facebook/fixed-data-table/issues/49). The DOM it generates is also much heavier (several elements for every cell vs. 1 with React Virtualized)

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

#27

Post by huherto »

captainmuon wrote: post #4

Nice! Looks really polished! One thing I'm wondering about... if this is React based, do you reassign and recalculate the whole grid upon every change? Because the grid is probably a component, and has the table as props. I could imagine that is inefficient... Not to even speak of then rendering the whole component and sending it through DOM reconciliation every time a key is pressed. Well, OTOH I guess it doesn't ma…

Back in the day I did a perl spread sheet. I was only updating the cells that were displayed at the moment. There were also transitive recalcs too if a displayed cell depended on other cells.

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

#28

Post by rudiger »

sandGorgon wrote: post #23

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.

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

#29

Post by [deleted] »

rudiger wrote: post #28
sandGorgon wrote: post #23

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.

[deleted]

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

#30

Post by misiti3780 »

tlrobinson wrote: post #26
misiti3780 wrote: post #18

I am working with two separate clients that need excel spreadsheet functionality in a browser. I evaluated all of the existing open source projects (this wasnt available at the time) and ended up going with fix-data-table-2 (fork of facebooks fix-data-table). fix-data-table is performant and easily extendable. I was able to create an editable grid similar to googlesheets in a months worth of work. working on open sou…

React Virtualized is also great: http://www.reactvirtualized.com We (Metabase) switched from FixedDataTable to React Virtualized and are happier with it. The only major issue with it is doesn't have fixed columns/rows built in, but it's pretty easy to compose a couple Grids with ScrollSync to get that behavior ( https://bvaughn.github.io/react-virtualized/#/components/Scr... ) FixedDataTable has performance issues wi…

Hi,

Thanks for the response. My team fixed those performance issues in the source. It is one of the reasons we want to open source it.

Post reply on HN