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

61–70 of 93 posts

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

#61

Post by zenlikethat »

clishem wrote: post #21
hive_mind wrote: post #12

Earlier quoted context omitted.

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.

Since the license of this library is MIT and the poster mentions patent attorneys I'd guess they aren't worried about licensing.

They're worried about getting sued by Microsoft, Google, etc. for patent infringement.

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

#62

Post by rch »

kamranasif wrote: post #60
tlrobinson wrote: post #26

Earlier quoted context omitted.

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…

Maintainer of FDT2 here. One of the reasons we decided to maintain this library is that it does virtualize both columns and rows. We use it at Schrodinger for our enterprise platform and have demo'd support of billions of rows. This is possible because we don't use a wrapper DOM element to handle scrolling. Right now we are migrating all the state to Redux for better maintainability and performance and hope to make e…

Virtualized columns is key -- thank you.

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

#63

Post by yawgmoth »

audiotalo wrote: post #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…

We use ag-grid, it supports React/Aurelia/Angular, I think they have Vue support as well. The team is really great.

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

#64

Post by mishoo »

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.

Take a look at Kendo Spreadsheet too: http://demos.telerik.com/kendo-ui/spreadsheet/index

(bias alert: I'm part of the team)

It's not free, but IMO it's the most Excel-like Web-based spreadsheet money can buy. You get support for Excel syntax and formulas, hundreds of Excel functions, XLSX import/export, print-to-PDF, virtual scrolling, OS clipboard integration, etc. — and it all runs in the browser.

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

#65

Post by djfumberger »

miralabs wrote: post #33
georgewfraser wrote: post #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.

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

Maybe that's the compromise for a good user experience?

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

#66

Post by ic4l »

georgewfraser wrote: post #55
toomim wrote: post #40

Earlier quoted context omitted.

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.

Google sheets uses canvas. The strategy you describe is orthoganal to canvas versus DOM.

I had to verify this... I cant believe it, they doing all the rendering logic for all the cells in canvas. They are not rendering simple cells either, sheets has may features :O.

Testing would be the easy part, in some cases it would be easier than DOM because you can do image diffs... The harder part is BUILDING IT.

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

#67

Post by csours »

Anytime I see something that looks like Excel on the web, I cringe.

Unless you are Microsoft or Google and you are putting spreadsheets on a website (SoW), you are almost certainly doing something wrong.

---

Case 1: A co-worker (or yourself) previously wrote an excel-based app and now it's time to put it on the web for wider distribution. You implement the app with a custom gridview/spreadsheet.

Error in Case 1: The UI was copied, but what is almost always needed is an input wizard with validations and workflow along with a reporting backend.

---

Case 2: You have a database that you need to share in a human readable format.

Error in Case 2: Implement export functionality instead, you will never be able to implement all the features of Excel, and at some point someone will need that feature.

---

Case 3: You have a very small and well defined case that actually calls for SoW!

Error in Case 3: Your very small SoW app will grow and grow and strangle you.

---

Case 4: You want to challenge the stranglehold of Google Sheets and MS Office 365.

Error in Case 4: There is no error here, only madness.

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

#68

Post by david927 »

csours wrote: post #67

Anytime I see something that looks like Excel on the web, I cringe. Unless you are Microsoft or Google and you are putting spreadsheets on a website (SoW), you are almost certainly doing something wrong. --- Case 1: A co-worker (or yourself) previously wrote an excel-based app and now it's time to put it on the web for wider distribution. You implement the app with a custom gridview/spreadsheet. Error in Case 1: The…

Error in Case 4: There is no error here, only madness.

Then give me madness. The problem is that spreadsheets are one of the most natural interfaces for data that we humans have, and even with Microsoft and Google's efforts included, current spreadsheets on a website (SoW) suck.

So let's say the y-axis is importance of function and the x-axis is compelling implementation --> voila! Right there, plotted on the graph you can see that this is something that needs to be worked on.

I understand your reasoning: you've created a spreadsheet-styled labeled grid in no time and you're pumping your fist, only to find out later that it this is way less than 1% of the effort you will eventually have to dole out to make a basic, respectable spreadsheet. The landscape is littered with 1% efforts that look good until you start working with it.

My point, though, is that this area is too important to not try harder, to not see more true attempts.

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

#69

Post by josephcooney »

csours wrote: post #67

Anytime I see something that looks like Excel on the web, I cringe. Unless you are Microsoft or Google and you are putting spreadsheets on a website (SoW), you are almost certainly doing something wrong. --- Case 1: A co-worker (or yourself) previously wrote an excel-based app and now it's time to put it on the web for wider distribution. You implement the app with a custom gridview/spreadsheet. Error in Case 1: The…

Agree. Here is a rant from me expressing the same sentiment from a while ago https://jcooney.net/post/2008/06/08/Data-grids-lack-of-imagi...

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

#70

Post by [deleted] »

david927 wrote: post #68
csours wrote: post #67

Anytime I see something that looks like Excel on the web, I cringe. Unless you are Microsoft or Google and you are putting spreadsheets on a website (SoW), you are almost certainly doing something wrong. --- Case 1: A co-worker (or yourself) previously wrote an excel-based app and now it's time to put it on the web for wider distribution. You implement the app with a custom gridview/spreadsheet. Error in Case 1: The…

Error in Case 4: There is no error here, only madness. Then give me madness. The problem is that spreadsheets are one of the most natural interfaces for data that we humans have, and even with Microsoft and Google's efforts included, current spreadsheets on a website (SoW) suck. So let's say the y-axis is importance of function and the x-axis is compelling implementation --> voila! Right there, plotted on the graph y…

[deleted]
Post reply on HN