[deleted]
A spreadsheet in fewer than 30 lines of JavaScript, no library used
61–70 of 274 posts
Re: A spreadsheet in fewer than 30 lines of JavaScript, no library used
#62This is truly great as proof of concept and also as a reminder that in software development building 80% of perceived* functionality usually takes only tiny fraction of total development time which is required to build final product. * - this app looks and feels like “almost complete spreadsheet” yet it provides much less than 1% features of even a basic spreadsheet.
And 80% of perceived functionality is what most users — even people who rely on spreadsheets for their work — need.
I'm not saying including the other 20% of functionality isn't a good thing to do, but when you're creating a new product or open source project, you can get by (and thrive) building only the 20% of functionality that's used 80% of the time.
Why? Because 1% of functionality is still better than 0% (never shipping).
You're not Microsoft. You don't have to keep your dominance in the spreadsheet software market like Microsoft has to.
Re: A spreadsheet in fewer than 30 lines of JavaScript, no library used
#63Wow, was this made by the same ondras who made wwwsqldesigner? This guy got me into Javascript a couple years ago thanks to the source code of that tool, and now it pays a good part of my bills. The tool himself helped me quite a bit too. Awesome guy. Nice hack, impressive!
Yes, it is the same Ondřej.
Re: A spreadsheet in fewer than 30 lines of JavaScript, no library used
#64Ondřej Žára. I've seen that name before. Hmm. The guy behind a server side implementation of Javascript. I loved that concept and I still believe it has a huge potential.
Kudos.
Re: A spreadsheet in fewer than 30 lines of JavaScript, no library used
#65My text disappears after I type it in and move on. And why do you call a table an "excel-like" app? Can it so =SUM(); can it do search and replace or the over 9000 other features of excel? No... it's a table, with a editor.
Sure you can, just add the function first:
function SUM() { var sum = 0; for (var i = 0; i Now you can do stuff like =SUM(A1, B1, C2) and it works like expected.
Re: A spreadsheet in fewer than 30 lines of JavaScript, no library used
#66The fact that you can put Javascript code which interacts with the cells is awesome.
For example you can put 10 in A1 and then put "=sum=0;for(i=0;i<A1;i++)sum+=i" in A2 to get the sum from 0 to 10. I really like this.
Re: A spreadsheet in fewer than 30 lines of JavaScript, no library used
#67This is truly great as proof of concept and also as a reminder that in software development building 80% of perceived* functionality usually takes only tiny fraction of total development time which is required to build final product. * - this app looks and feels like “almost complete spreadsheet” yet it provides much less than 1% features of even a basic spreadsheet.
And 80% of perceived functionality is what most users — even people who rely on spreadsheets for their work — need. I'm not saying including the other 20% of functionality isn't a good thing to do, but when you're creating a new product or open source project, you can get by (and thrive) building only the 20% of functionality that's used 80% of the time. Why? Because 1% of functionality is still better than 0% (never…
The problem is that the total economic value (as measured by market price) for the users who only use that 80% of perceived functionality is close to 0 (google docs and OO/LO are free)
The incredibly difficult 20% is what people pay for. It's what the businesses that shell out billions of dollars a year pay for. And it's what a successful product in the space needs to tackle
Re: A spreadsheet in fewer than 30 lines of JavaScript, no library used
#68Are there any more full-featured libraries that people use for this? I've found SpreadJS[0], GelSheet[1], jQuery.Sheet[2], and ZK Spreadsheet, but none seem like thriving open-source projects as far as I can tell. [0] http://wijmo.com/demo/spreadjs/samples/index.html [1] http://www.gelsheet.org/demo [2] http://visop-dev.com/Project+jQuery.sheet [3] http://www.zkoss.org/product/zkspreadsheet
Whilst not focused on being an Excel clone, Backgrid has worked great for me. It's bound to backbone/underscore if you're already using that.
Re: A spreadsheet in fewer than 30 lines of JavaScript, no library used
#69Are there any more full-featured libraries that people use for this? I've found SpreadJS[0], GelSheet[1], jQuery.Sheet[2], and ZK Spreadsheet, but none seem like thriving open-source projects as far as I can tell. [0] http://wijmo.com/demo/spreadjs/samples/index.html [1] http://www.gelsheet.org/demo [2] http://visop-dev.com/Project+jQuery.sheet [3] http://www.zkoss.org/product/zkspreadsheet
I've been a fan of SlickGrid for a while, it handles huge data sets relatively well. If you want excel-style functionality it'll still take a little work.
Re: A spreadsheet in fewer than 30 lines of JavaScript, no library used
#70Expressions did not evaluate for me. Reading the other comments I think I'm the only one though :-(
Broken for me too, on both FF & Chrome. As you say, the formulae are just displayed, not evaluated.