Spreadsheets / WickedGrid

Easy & Wicked Fast spreadsheets for the web
http://spreadsheets.github.io/WickedGrid
587 stars 131 forks source link

Status of project #91

Open andybak opened 8 years ago

andybak commented 8 years ago

I looked at a lot of js data-grids and yours seemed superior in many ways.

Are you likely to resume development or are you aware of any worthy successors? I don't have an immediate requirement but I was puzzled to find no mature project existed to fulfill this need.

--- Want to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/30450137-status-of-project?utm_campaign=plugin&utm_content=tracker%2F609152&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F609152&utm_medium=issues&utm_source=github).
robertleeplummerjr commented 8 years ago

Thanks for your interest! We had some funding from the top Bank in the US at the time, but right as we solved the most difficult problems for their MASSIVE spreadsheet, they pulled the plug. In its current state there are some bugs that are to do with UI, but as for the calculations engine, we were pumping in hundreds of meg of json and it was handling it wicked fast. We had 200+mb load in 0.5 seconds. It was outperforming the desktop version. As for it's current state, I guess I was just waiting for the right interest and time to have the final push for the next release. Too, I've just been busy with life. If there was sufficient interest, I'd put time into getting it done.

On Tue, Feb 2, 2016 at 8:54 AM, Andy Baker notifications@github.com wrote:

I looked at a lot of js data-grids and yours seemed superior in many ways

Are you likely to resume development or are you aware of any worthy successors? I don't have an immediate requirement but I was puzzled to find no mature project existed to fulfill this need

— Reply to this email directly or view it on GitHub https://github.com/Spreadsheets/jQuery.sheet/issues/91.

Robert Plummer

alvin101 commented 8 years ago

Please count me in as one of interest....

robertleeplummerjr commented 8 years ago

Nice!

larsinsd commented 8 years ago

Same here. We used your old spreadsheet program in our CRM platform, but it broke with the later versions of jQuery and jQueryUI, so if this were to be re-vitalized, it would be used by several thousand companies globally.

andybak commented 8 years ago

I'm mainly interested in it as a nice fast interface for editing tabular data on the backend - not specifically as a spreadsheet. Is that in scope or is the spreadsheetiness hard to avoid?

robertleeplummerjr commented 8 years ago

Spreadsheet components are managed in their own set of classes, and can easily be turned off.

On Tue, Feb 2, 2016 at 1:57 PM, Andy Baker notifications@github.com wrote:

I'm mainly interested in it as a nice fast interface for editing tabular data on the backend - not specifically as a spreadsheet. Is that in scope or is the spreadsheetiness hard to avoid?

— Reply to this email directly or view it on GitHub https://github.com/Spreadsheets/jQuery.sheet/issues/91#issuecomment-178757940 .

Robert Plummer

robertleeplummerjr commented 8 years ago

There has been a big push to move to native Dom rather than jquery, in pretty Much every way. The default wrapper is still jquery, but the internals are 99% dom only. The speed gained from that move are substantial. On Feb 3, 2016 6:46 PM, "Robert Plummer" robertleeplummerjr@gmail.com wrote:

Spreadsheet components are managed in their own set of classes, and can easily be turned off.

On Tue, Feb 2, 2016 at 1:57 PM, Andy Baker notifications@github.com wrote:

I'm mainly interested in it as a nice fast interface for editing tabular data on the backend - not specifically as a spreadsheet. Is that in scope or is the spreadsheetiness hard to avoid?

— Reply to this email directly or view it on GitHub https://github.com/Spreadsheets/jQuery.sheet/issues/91#issuecomment-178757940 .

Robert Plummer

sandys commented 8 years ago

hi @robertleeplummerjr - this is an awesome project. I want you take a look at Handsontable.com . I just bought a Pro version, but there is a real real need for something like this.

I mean Handsontable doesnt even work with npm or webpack or anything and still there are tons of people who are subscribing. This is a real product need you could fill if you rebrand (seriously I spent a week researching spreadsheets... but Handsontable was the one that people talked about the most. your name gets lost in "jquery"). I would myself buy support you guys !

Second, just a theoretical question:

we have been thinking about building visualizations using a Js spreadsheet and Crossfilter (Square's high performance js based dataset library for filtering and aggregations https://github.com/crossfilter/crossfilter and https://github.com/esjewett/reductio).

The super spectacular dc.js library (https://dc-js.github.io/dc.js/) uses Crossfilter to build out these amazing graphs and visualization without having to write any code. Do you think it makes sense for you guys to look at Crossfilter as the underlying data structure for your spreadsheet ? I mean both what you are doing in terms of performance and Crossfilter is overalapping so much ... that I cant help but think that there might be some way to join forces and build a better overall product. Not sure what your opinion on that is.

Seems to me a large goal of all JS spreadsheets is to replicate Excel formulas... but https://github.com/esjewett/reductio is so powerful a concept that it is hard to go back - think functional programming for Excel Formulas !!

peterc commented 8 years ago

We included it in JavaScript Weekly today - http://javascriptweekly.com/issues/269 (96K readers) - and are mentioning it on @JavaScriptDaily (185K followers) - so if there's any interest, hopefully you'll find out soon! :-)

jtoy commented 8 years ago

+1

felipegtx commented 8 years ago

@robertleeplummerjr @peterc this is also on HN's front page.

hn

peterc commented 8 years ago

It is. That's how I found out about this thread. Not sure where the chickens and eggs are in this situation (or even where I found out about it to mention earlier) but all seems good! :)

robertleeplummerjr commented 8 years ago

I've talked with the dev at HandsonTable, it is a fine product. As far as I can tell though, it doesn't scale to millions of cells, and there is no formula parser. I'll take some time next week and see what I can achieve as for low hanging fruit to achieve beta.

On Fri, Feb 5, 2016 at 2:42 PM, Peter Cooper notifications@github.com wrote:

It is. That's how I found out about this thread. Not sure where the chickens and eggs are in this situation (or even where I found out about it to mention earlier) but all seems good! :)

— Reply to this email directly or view it on GitHub https://github.com/Spreadsheets/jQuery.sheet/issues/91#issuecomment-180515473 .

Robert Plummer

sandys commented 8 years ago

Incidentally - most of the hacker news comments (and my own question) is how hard is it for you to remove jquery dependence ENTIRELY. Maybe provide a jquery shim for those who are expecting a certain integration with jquery. And publish to npm.

I recommend that you rename as well - it is very hard to Google for you.

https://plugins.jquery.com/tag/spreadsheet/

On Feb 6, 2016 01:39, "Robert Plummer" notifications@github.com wrote:

I've talked with the dev at HandsonTable, it is a fine product. As far as I can tell though, it doesn't scale to millions of cells, and there is no formula parser. I'll take some time next week and see what I can achieve as for low hanging fruit to achieve beta.

On Fri, Feb 5, 2016 at 2:42 PM, Peter Cooper notifications@github.com wrote:

It is. That's how I found out about this thread. Not sure where the chickens and eggs are in this situation (or even where I found out about it to mention earlier) but all seems good! :)

— Reply to this email directly or view it on GitHub < https://github.com/Spreadsheets/jQuery.sheet/issues/91#issuecomment-180515473

.

Robert Plummer

— Reply to this email directly or view it on GitHub https://github.com/Spreadsheets/jQuery.sheet/issues/91#issuecomment-180537709 .

robertleeplummerjr commented 8 years ago

What would you like it to be?

On Fri, Feb 5, 2016 at 10:47 PM, Sandeep Srinivasa <notifications@github.com

wrote:

I recommend that you rename as well - it is very hard to Google for you.

https://plugins.jquery.com/tag/spreadsheet/ On Feb 6, 2016 01:39, "Robert Plummer" notifications@github.com wrote:

I've talked with the dev at HandsonTable, it is a fine product. As far as I can tell though, it doesn't scale to millions of cells, and there is no formula parser. I'll take some time next week and see what I can achieve as for low hanging fruit to achieve beta.

On Fri, Feb 5, 2016 at 2:42 PM, Peter Cooper notifications@github.com wrote:

It is. That's how I found out about this thread. Not sure where the chickens and eggs are in this situation (or even where I found out about it to mention earlier) but all seems good! :)

— Reply to this email directly or view it on GitHub <

https://github.com/Spreadsheets/jQuery.sheet/issues/91#issuecomment-180515473

.

Robert Plummer

— Reply to this email directly or view it on GitHub < https://github.com/Spreadsheets/jQuery.sheet/issues/91#issuecomment-180537709

.

— Reply to this email directly or view it on GitHub https://github.com/Spreadsheets/jQuery.sheet/issues/91#issuecomment-180667584 .

Robert Plummer

sandys commented 8 years ago

I think it is the prerogative of the maintainer ;)

P.S. I would personally called it WickedGrid (from your description). Domain is also available!

robertleeplummerjr commented 8 years ago

A quick search for wickedgrid (tried wickedsheet too) shows a few people already using the handle. Perhaps we could think of something more original? But I really appreciate the effort you put into thinking and looking up the domain.

On Sat, Feb 6, 2016 at 1:08 PM, Sandeep Srinivasa notifications@github.com wrote:

I think it is the prerogative of the maintainer ;)

P.S. I would personally called it WickedGrid (from your description). Domain is also available!

— Reply to this email directly or view it on GitHub https://github.com/Spreadsheets/jQuery.sheet/issues/91#issuecomment-180825153 .

Robert Plummer

sandys commented 8 years ago

here's also a comment from some people on HN around funding/donating to open source projects. It ties into why Handsontable is doing it that way.

patio11:

We don't donate to OSS software which we use, because we're legally not allowed to. I routinely send key projects, particularly smaller projects, a request to quote me a commercial license of their project, with the explanation that I would accept a quote of $1,000 and that the commercial license can be their existing OSS license plus an invoice. My books suggest we've spent $3k on this in 2015. My bookkeeper, accountant, and the IRS/NTA are united on this issue: they don't care whether a software license is OSS or not. A $1k invoice is a $1k invoice; as a software company, I have virtually carte blanche to expense any software I think is reasonably required, and I think our OSS is reasonably required. I would do this more often if OSS projects made it easier for me to do so. Getting me to pay $1,000 for software is easy; committing me to doing lots of admin work over the course of a week is less easy. Take a look at what e.g. http://sidekiq.org/ , which is an OSS project with a commercial model, does. Two clicks gets me to a credit card form. If I actually used Sidekiq, Mike would have had my credit card on file the day that form went up."

robertleeplummerjr commented 8 years ago

Very cool! As far as a rebranded name goes: what do you guys think of "AahSheet"?

"Aah" apparently doesn't have a meaning like a normal word but is described instead a multi lingual sound. Of which it is six points in Scrabble. Anagrammer.com describes it: "verb - express admiration and pleasure by uttering ooh' oraah'

Used to express pleasure, satisfaction, surprise, or great joy.

verb - to exclaim in amazement, joy, or surprise"

And sheet, well because it is a sheet.

Also, AahSheet is fun to say, but not too fast ;).

here's also a comment from some people on HN around funding/donating to open source projects. It ties into why Handsontable is doing it that way.

patio11:

We don't donate to OSS software which we use, because we're legally not allowed to. I routinely send key projects, particularly smaller projects, a request to quote me a commercial license of their project, with the explanation that I would accept a quote of $1,000 and that the commercial license can be their existing OSS license plus an invoice. My books suggest we've spent $3k on this in 2015. My bookkeeper, accountant, and the IRS/NTA are united on this issue: they don't care whether a software license is OSS or not. A $1k invoice is a $1k invoice; as a software company, I have virtually carte blanche to expense any software I think is reasonably required, and I think our OSS is reasonably required. I would do this more often if OSS projects made it easier for me to do so. Getting me to pay $1,000 for software is easy; committing me to doing lots of admin work over the course of a week is less easy. Take a look at what e.g. http://sidekiq.org/ , which is an OSS project with a commercial model, does. Two clicks gets me to a credit card form. If I actually used Sidekiq, Mike would have had my credit card on file the day that form went up."

— Reply to this email directly or view it on GitHub https://github.com/Spreadsheets/jQuery.sheet/issues/91#issuecomment-182749978 .

sandys commented 8 years ago

Quirky... +1 Its your choice in case you want to sell pro licenses to banks ;) On Feb 11, 2016 18:38, "Robert Plummer" notifications@github.com wrote:

Very cool! As far as a rebranded name goes: what do you guys think of "AahSheet"?

"Aah" apparently doesn't have a meaning like a normal word but is described instead a multi lingual sound. Of which it is six points in Scrabble. Anagrammer.com describes it: "verb - express admiration and pleasure by uttering ooh' oraah'

Used to express pleasure, satisfaction, surprise, or great joy.

verb - to exclaim in amazement, joy, or surprise"

And sheet, well because it is a sheet.

Also, AahSheet is fun to say, but not too fast ;).

here's also a comment from some people on HN around funding/donating to open source projects. It ties into why Handsontable is doing it that way.

patio11:

We don't donate to OSS software which we use, because we're legally not allowed to. I routinely send key projects, particularly smaller projects, a request to quote me a commercial license of their project, with the explanation that I would accept a quote of $1,000 and that the commercial license can be their existing OSS license plus an invoice. My books suggest we've spent $3k on this in 2015. My bookkeeper, accountant, and the IRS/NTA are united on this issue: they don't care whether a software license is OSS or not. A $1k invoice is a $1k invoice; as a software company, I have virtually carte blanche to expense any software I think is reasonably required, and I think our OSS is reasonably required. I would do this more often if OSS projects made it easier for me to do so. Getting me to pay $1,000 for software is easy; committing me to doing lots of admin work over the course of a week is less easy. Take a look at what e.g. http://sidekiq.org/ , which is an OSS project with a commercial model, does. Two clicks gets me to a credit card form. If I actually used Sidekiq, Mike would have had my credit card on file the day that form went up."

— Reply to this email directly or view it on GitHub < https://github.com/Spreadsheets/jQuery.sheet/issues/91#issuecomment-182749978

.

— Reply to this email directly or view it on GitHub https://github.com/Spreadsheets/jQuery.sheet/issues/91#issuecomment-182856881 .

vnwarrior commented 8 years ago

you are already ranking on top for megatable. maybe you should just call it megasheets. btw, megasheets.com is available.

robertleeplummerjr commented 8 years ago

Guys, wickedgrid was just too simple in the end for me to pass up. Domain purchased.

On Fri, Feb 12, 2016 at 7:33 AM, vnwarrior notifications@github.com wrote:

you are already ranking on top for megatable. maybe you should just call it megasheets. btw, megasheets.com is available.

— Reply to this email directly or view it on GitHub https://github.com/Spreadsheets/jQuery.sheet/issues/91#issuecomment-183305002 .

Robert Plummer

jrgifford commented 8 years ago

YAY! :metal:

sandys commented 8 years ago

+1 btw, you can create a github page and point your domain to it. https://help.github.com/articles/setting-up-a-custom-domain-with-github-pages/

you dont need a separate website host.

robertleeplummerjr commented 8 years ago

And.... rebranded. I will continue work as I get time. I currently work on sprints, the end of which I have 20% time, which I will dump in mad quantities into WickedGrid.

vnwarrior commented 8 years ago

three things I would recommend:

  1. adding WickedGrid to the jsspreadsheets.com page and to Producthunt.
  2. call for volunteers to be given write access. help it grow faster!
  3. A "Pro" paid version - just to make it easy for other people to donate to you (from legal tax perspective). Like sidekiq - http://sidekiq.org/products/pro or sqlite - http://www.hwaci.com/cgi-bin/license-step1
robertleeplummerjr commented 8 years ago

https://github.com/Spreadsheets/WickedGrid/commit/e72cc252889cb3f876024d5303d0ef72898de71e

robertleeplummerjr commented 8 years ago

TNT(jQuery.sheet) -> WickedGrid

robertleeplummerjr commented 8 years ago

As I was working on the project for a number of years I was originally working with very simply jQuery selectors, and making something simple just sort of work. As it progressed some of the practices remained, even though the context changed from simple to extremely complex spreadsheets. By reworking the project as a whole for classes etc, we finally get a platform worthy of the context. This was a massive change to the internals of the project, but was a much needed change in order to scale.

sandys commented 8 years ago

similar project (with a premium version) - https://nxsheet.com/pricing

dnprock commented 8 years ago

I'm a developer of nxsheet.com. If you have any question, please send us an email contact@nxsheet.com.

Thoughtfulmonkey commented 8 years ago

I was very excited to see this project, but the current version on github does not seem to work. After pulling down the source and bower dependencies, it runs without any errors but cells are not selectable, right-click is browser context menu etc. If I swap in some of the old jQuery.sheet files from the demo website then it gets back into a partially working state (although z-indexing on the menus needed adjustment, and zeroclipboard seems to keep repositioning itself in an awkward place).

This is a great project. Are there any short-term plans to get it back into working order after the re-brand?

robertleeplummerjr commented 8 years ago

I've actually been working on it indirectly here. I suppose you guys have pulled my leg enough, I will put it as a top priority to get a release candidate out.

jabbermarky commented 6 years ago

What is your expectation/goal for this project going forward - do you plan to continue or is this project dead - last update > 1 year ago...

thanks, Mark

robertleeplummerjr commented 6 years ago

My time is limited, I don't want to impede the project from growing, let's call for contributors!

robertleeplummerjr commented 6 years ago

https://twitter.com/robertlplummer/status/935175530781069312

robertleeplummerjr commented 6 years ago

Thumb it, retweet, get the word out, let's work together and get a new version out that blows away the competition!

robertleeplummerjr commented 6 years ago

@jabbermarky

What is your expectation/goal for this project going forward

I believe there are a small amount of bugs that prevent the ui from being useful at the moment, which can easily be solved, but I'd like to get a version out the door that resolves this perhaps early next year.

alvin101 commented 6 years ago

I think the one thing that would blow this project sky high is to offer a simple infrastructure that would allow users to load these scripts on a server and start to use them like google sheets.

I believe this would increase your user base 10 fold...

robertleeplummerjr commented 6 years ago

Like an open source vanilla container for running it? I can dig it.