clxl

I'm surprised by how many things that aren't that difficult or novel end up on the front page. CSV related projects come to the fore every week.

I explored this a bit (based off of the javascript-based http://sheetjs.com/sexql/) but the biggest difficulty is that people use CSVs and excel files in completely different ways for the same general task. In particular, different people set up budget workbooks in very different ways. There are also input problems and invalid files to deal with, so even if you manage to craft a meaningful integration you'd still have to figure out how to determine the structure and fix subtle non-uniformities

https://github.com/OfficeDev/Open-XML-SDK/pull/3 suggests that there are issues with use in mono

WebSQL is remarkably simple to use, works on the most popular browsers on mobile and desktop, and gives you the power of SQL. In contrast, IME indexed db felt like pulling teeth. The discussions seem to suggest that institutional intransigence by Mozilla pushed the internet back a step. (And yes, SQLite + Emscripten is significantly slower than websql on chrome and iOS Safari)

Substack (yes, that substack) discussed this recently:

a slick web page - this is very often (but not always) a sign of a library that put all of its time into slick marketing but has overly-broad scope and is very likely to become abandoned

http://www.reddit.com/r/javascript/comments/2378xo/the_best_...

Is there any indication that the posted link was already submitted? I would have expected some sort of warning.

Excel supports 32 bit integers, which fit comfortably in IEEE754 doubles (there are 64 bit integers which cannot be exactly represented)

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.

Excel only supports numbers that fit in an IEEE754 double, just like JavaScript.

There is some fancy logic to format numbers, however (including some mess for date codes). http://oss.sheetjs.com/ssf/ is a pretty decent implementation in JavaScript.

It's somewhat confusing. The structure is MIT licenses but the individual implementations have different licenses (for example, many functions were copied from OpenOffice (which is under Apache2 license)

It provides a set of JavaScript functions. It doesn't try to parse formulas. You probably could go back and define aliases for each function

It primarily strings together other libraries. Most of the functions are provided by other libraries like moment.js and numeral.js

I'm actually working on this, although for various reasons I had to reimplement the formula parser (corner cases are a pain). Screenshot (in progress): http://i.imgur.com/snyBhYH.png

I looked at that project but it uses a really strange non-free license that should be avoided. https://github.com/stephen-hardy/xlsx.js/issues/8

Stringing this together with other libraries like http://github.com/warpech/jquery-handsontable and http://github.com/SheetJS/js-xlsx and http://github.com/SheetJS/js-xls could lead to a better web spreadsheet.

EDIT: someone already thought about combining those libraries: http://SheetJS.github.io

If deflation kicked in, why wouldn't the fed fight with increased QE?

Atwood's law in action

This should be an automated post (like whoishiring).

I'm working on a command line spreadsheet app. Screenshot: http://i.imgur.com/snyBhYH.png