News for hackers. Stuff that matters.
Re:Excel formulas in JavaScript by brudgers on Thursday April 24, 2014 @10:36AM (#7640499)
Every time I read some comment about how people shouldn't use excel for complex calculations and should use relational databases or Python or whatever else, I'll know why it will never happen.

It's really easy to implement the easy parts of spreadsheets, getting the hard parts right is why Excel continues to dominate the space.

Re:Excel formulas in JavaScript by clxl on Thursday April 24, 2014 @10:46AM (#7640573)
There is a good reason why no one has unseated excel: it's easy to build the really easy 80%, but the last 20% is incredibly difficult and time consuming.
Re:Excel formulas in JavaScript by e12e on Thursday April 24, 2014 @10:59AM (#7640680)
It's a shame Scheme in a grid appears to be abandoned (if anyone manages to build it under, say, the latest Debian Stable, please let me know):

http://siag.nu/siag/

Re:Excel formulas in JavaScript by nhebb on Thursday April 24, 2014 @12:06PM (#7641129)
Most spreadsheets I've dealt with don't hold relational data. Are there people who use them as such? Sure. But I don't think that's the typical use case.
Re:Excel formulas in JavaScript by recursive on Thursday April 24, 2014 @02:19PM (#7641935)
I would say relational data is the dominant use case for spreadsheets. It's a natural fit given the rows and columns. What other kind of data do you see in spreadsheets? Hierarchical data is not a great fit for spreadsheets.
Re:Excel formulas in JavaScript by Pxtl on Thursday April 24, 2014 @11:52AM (#7641042)
Ironically, Excel fails miserably at implementing the easy parts of a database.

Seriously, how much does doing a simple "Select Distinct" suck in Excel?

Re:Excel formulas in JavaScript by stevepike on Thursday April 24, 2014 @01:45PM (#7641729)
So much that I wrote this: http://scpike.com/uniqify/

(I know you can do filter => unique only => copy somewhere) but it's stupidly slow.

Re:Excel formulas in JavaScript by Pxtl on Thursday April 24, 2014 @02:35PM (#7642033)
Either way, filters aren't a solution if you're constructing a reusable spreadsheet that somebody else is populating.