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

81–90 of 93 posts

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

#81

Post by flukus »

josephcooney wrote: post #69
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...

I agree in general, datagrids usually mean "we have absolutely no idea what our users workflows are", but I'm not sure the credit risk example is a good one. If the credit risk is one of dozens of fields on a generic client edit table then it's awful. If it's a much more specific "adjust credit risk" form with relevant information to that specific workflow then it's fine.

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

#82

Post by sandGorgon »

mishoo wrote: post #64
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.

So Handsontable had an open source version that I could try before I bought. I had looked at kendo , but saw that it was packaged as part of a larger suite...Which probably I would overpay for and be useless for me.

Second - we use react and kendo had started exploring react only in oct2016 (we have our react HOT app in production since Nov 2015). I'm Not sure what's the status since googling for a react kendo spreadsheet component does not get me much.

But I would switch If you had a clean pricing for the spreadsheet, clearly showed by comparison where it was superior..And most importantly, react.

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

#83

Post by csharpminor »

csours wrote: post #79
repsilat wrote: post #77

Earlier quoted context omitted.

Spreadsheets are the most intuitive programming environment known to man. Every time you reach for Excel to mung your data, that's opening a repl. The only problem is that Google and Microsoft don't care enough to make them powerful enough to do general purpose computation with, fast enough to build large systems with, versionable enough to enable large teams to use them.

> Spreadsheets are the most intuitive programming environment known to man. Every time you reach for Excel to mung your data, that's opening a repl. I absolutely agree - REPLs are excellent for prototyping and exploring data and ideas, and spreadsheets are excellent in that role. Allow me to ask you this then: when was the last time you shipped prototype code? Unless you live dangerously, you don't ship prototype cod…

You might check out Airtable. They do a good job of this.

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

#84

Post by ceolter »

yawgmoth wrote: post #63
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.

Niall here from ag-Grid - thanks for the nice words about ag-Grid. Yes we support Angular 1, Angular 2+, React, Aurelia, Vue, Web Components, and just plain JavaScript.

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

#85

Post by helb »

rattray wrote: post #52
acemarke wrote: post #48

Earlier quoted context omitted.

I personally recommend against using Immutable.js, for a number of reasons (which I wrote as a Reddit comment a while ago [0] ). There's some additional info on Immutable.js-related perf in my links list [1] FYI, there's also a bunch of other immutable update utility libs besides immutability-helper. I have a list of them in my Redux addons catalog [2]. [0] https://www.reddit.com/r/javascript/comments/4rcqpx/dan_abra…

Interesting, thanks for sharing. I took a look at your list of links recently, actually – it was helpful. I'm considering syntax-level support for `immutability-helper`, which seems like the best all-around solution aside from its syntax. This is for a JS Dialect I'm building called LightScript[0]. Would look something like: store.people[0].friends[0].name~~set("Alice") which would compile to: update(store, { people:…

One thing i like about immutability-helper is their mongo-style syntax. Yeah, MongoDB might kinda suck for multiple reasons, but the query syntax is quite nice IMO.

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

#87

Post by chrishere »

ic4l wrote: post #66
georgewfraser wrote: post #55

Earlier quoted context omitted.

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.

They applied some kind of mixed model in which the entire effort connected with rendering the body of the grid (cells) is being drawn in canvas and the rest of it, including headers, selection and editors, are rendered in a regular way. There is no doubt that Google Sheets keeps almost all of its logic on the back-end side.

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

#88

Post by euroclydon »

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.

Hi. Certainly, my comment would be applicable to any open source library. But my intent was not to say that OSS software is difficult to get by patent attorneys. Rather I was attempting an inside joke with kindred spirits who have submitted OSS libs to their company's attorneys for patent infringement.

What they seem to do is hire a grunt to do a naive word search match on the patent database. So I was saying, "just imagine the number of results that will come back for 'spreadsheet' or 'Excel'".

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

#89

Post by Tomino »

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…

There are projects that try to get into that gap, for example have a look at https://www.ipushpull.com

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

#90

Post by hakanito »

uptown wrote: 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 just refactored our fairly large (15k LoC) redux codebase into MobX for exactly this reason. Result, shaved off 10k LoC and started enjoying dev life again
Post reply on HN