Re:Show HN: X-spreadsheet – A JavaScript canvas spreadsheet ...
by williamstein on Monday January 28, 2019 @10:49AM
(#19018345)
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!
[ Parent
| on HN ]
Re:Show HN: X-spreadsheet – A JavaScript canvas spreadsheet ...
by ASalazarMX on Monday January 28, 2019 @11:03AM
(#19018478)
It's also fast because the worksheet is tiny (100 rows x 25 columns), but it's a great proof of concept.
Re:Show HN: X-spreadsheet – A JavaScript canvas spreadsheet ...
by dartf on Monday January 28, 2019 @11:22AM
(#19018667)
It looks like it's case sensitive. Worked for me with "=SUM(A5:A8)"
Re:Show HN: X-spreadsheet – A JavaScript canvas spreadsheet ...
by y4mi on Monday January 28, 2019 @11:25AM
(#19018700)
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 )
Re:Show HN: X-spreadsheet – A JavaScript canvas spreadsheet ...
by selimthegrim on Monday January 28, 2019 @12:34PM
(#19019294)
Wonder how much demand there will be for SUMPRODUCT
Re:Show HN: X-spreadsheet – A JavaScript canvas spreadsheet ...
by codetrotter on Monday January 28, 2019 @06:54PM
(#19022349)
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.