Excel formulas in JavaScript
github.com
Excel formulas in JavaScript
1–10 of 57 posts
Re: Excel formulas in JavaScript
#2Well done, but I fail at seeing how that could be useful?
Re: Excel formulas in JavaScript
#3Well done, but I fail at seeing how that could be useful?
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
Re: Excel formulas in JavaScript
#4very nice thanks
Re: Excel formulas in JavaScript
#5What licence is this under please? (MIT preferred!)
Re: Excel formulas in JavaScript
#6Is there a demo?
Re: Excel formulas in JavaScript
#7What licence is this under please? (MIT preferred!)
It is included in the js file [1] and seems to be under MIT and Apache.
[1] https://raw.githubusercontent.com/sutoiku/formula.js/master/...
Re: Excel formulas in JavaScript
#8Cool! Pretty similar to what www.phpexcel.net does for PHP.
Re: Excel formulas in JavaScript
#9Any support for i18n?
(For English-only speakers: Excel's translation to other languages goes as far as translating function names, thus rendering non-English Excel users' knowledge useless when confronted with an English Excel. E.g., IF(ROUND(A1)=1,B1,C1) in English Excel is JEŻELI(ZAOKR.DO.CAŁK(A1)=1,B1,C1) in Polish Excel -- yes, with all those funky non-ASCII letters.)
Re: Excel formulas in JavaScript
#10Any support for i18n? (For English-only speakers: Excel's translation to other languages goes as far as translating function names, thus rendering non-English Excel users' knowledge useless when confronted with an English Excel. E.g., IF(ROUND(A1)=1,B1,C1) in English Excel is JEŻELI(ZAOKR.DO.CAŁK(A1)=1,B1,C1) in Polish Excel -- yes, with all those funky non-ASCII letters.)
This also includes changing argument separators according to the locale. In France, for instance, where commas are used as decimal separators, function arguments must be separated by semicolons. Faithful i18n should take both into account.