This works wonderfully.
Definitely the most punch I've seen per line of code.
You can use javascript functions in your excel formulas. In a 30 line of code program this is a feature.
= alert("I love it.");
A spreadsheet in fewer than 30 lines of JavaScript, no library used
11–20 of 274 posts
Re: A spreadsheet in fewer than 30 lines of JavaScript, no library used
#12Probably the most misleading article name in the history.....
Re: A spreadsheet in fewer than 30 lines of JavaScript, no library used
#13Aside from losing input when tabbing out, works a treat in Opera. Can think of a couple of places that a fork of this might come in handy in my work this week. Clever, thanks for sharing
Re: A spreadsheet in fewer than 30 lines of JavaScript, no library used
#14A dangerously awesome feature: eval means it probably would support anon funcs.
Re: A spreadsheet in fewer than 30 lines of JavaScript, no library used
#15My 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.
These comments freak me out. Guys, come on... It's just 30 lines... Great job author, fascinating.
Re: A spreadsheet in fewer than 30 lines of JavaScript, no library used
#16Crash it with
=DATA[$.id]Re: A spreadsheet in fewer than 30 lines of JavaScript, no library used
#17Probably the most misleading article name in the history.....
How so? Even some formulas work!
Re: A spreadsheet in fewer than 30 lines of JavaScript, no library used
#18Just like Excel, this version allows you to program almost anything inside a cell. Try inserting =alert("foobar") in a cell :)
Re: A spreadsheet in fewer than 30 lines of JavaScript, no library used
#19Very cool and a great springboard for others to develop from. Bug/feature: only uppercase works in formulas (A4 works but a4 does not).
Neat idea, lowercase fixed!
Re: A spreadsheet in fewer than 30 lines of JavaScript, no library used
#20First thing I tried was "=alert()". While it worked, its tendency to block, recalculate, and persist with localStorage made it a bad idea, personally.