[williamstein]

This is amazing and fast. I'm complaining about it actually being easily broken only because I really wished this worked well, so I could build on it. It crashed for me on literally the very first thing I tried. I opened up the demo page, typed in 4 numbers in a column (in positions a5,a6,a7,a8), then typed "=sum(a5:a8)" in position a9, hit enter, and the demo crashed (with canvas all messed up). There's a traceback in the console log that starts "Uncaught TypeError: Cannot read property 'render' of undefined at cell.js:146". I'm using Chrome 71. I refreshed and tried the same test and it crashed again. There is a test suite (https://github.com/myliang/x-spreadsheet/tree/master/test) but the files have mostly not been touched in four months. In any case, awesome work - please make it even better!

[ASalazarMX]

It's also fast because the worksheet is tiny (100 rows x 25 columns), but it's a great proof of concept.

[dartf]

It looks like it's case sensitive. Worked for me with "=SUM(A5:A8)"

[y4mi]

i was about to say the same thing...

to anyone else wondering: you can browse the available function with the button to the right. ( SUM, AVERAGE, MIN, MAX and CONCAT )

[selimthegrim]

Wonder how much demand there will be for SUMPRODUCT

[codetrotter]

For anyone else wondering about that formula.

https://exceljet.net/excel-functions/excel-sumproduct-functi...

All I can say is, I am grateful I don’t have to deal with other people’s spreadsheets.

My jam is programming languages and SQL, not obscure formulas and weird constructs made from surprising ways of using them.

[myliang]

it's fixed, thx