Re:Show HN: React-data sheet, Excel-like spreadsheet component
by toomim on Tuesday April 04, 2017 @12:50PM
(#14034741)
Or you can do what google sheets does: only draw N cells at any time, and just change their contents depending on where you are scrolled to.
[ Parent
| on HN ]
Re:Show HN: React-data sheet, Excel-like spreadsheet component
by georgewfraser on Tuesday April 04, 2017 @02:39PM
(#14035911)
Google sheets uses canvas. The strategy you describe is orthoganal to canvas versus DOM.
Re:Show HN: React-data sheet, Excel-like spreadsheet component
by ic4l on Tuesday April 04, 2017 @05:56PM
(#14037607)
I had to verify this... I cant believe it, they doing all the rendering logic for all the cells in canvas. They are not rendering simple cells either, sheets has may features :O.
Testing would be the easy part, in some cases it would be easier than DOM because you can do image diffs... The harder part is BUILDING IT.
Re:Show HN: React-data sheet, Excel-like spreadsheet component
by chrishere on Wednesday April 05, 2017 @05:43AM
(#14040898)
They applied some kind of mixed model in which the entire effort connected with rendering the body of the grid (cells) is being drawn in canvas and the rest of it, including headers, selection and editors, are rendered in a regular way. There is no doubt that Google Sheets keeps almost all of its logic on the back-end side.