Re:Use Spreadsheets Everywhere
by tomnipotent on Tuesday August 03, 2021 @02:06PM
(#28052198)
Excel 2013 and later has a columnar database capable of handling millions of rows, but not through the standard sheets interface so it loses a lot of the utility people are used to.
[ Parent
| on HN ]
Re:Use Spreadsheets Everywhere
by jodrellblank on Tuesday August 03, 2021 @05:25PM
(#28054427)
How? Through what interface, or by what feature name to Google?
Excel refers to it as the “Data Model”. It allows joining tables/sheets and referencing them from other tables.
https://www.microsoft.com/en-us/microsoft-365/blog/2012/08/2...
Re:Use Spreadsheets Everywhere
by jodrellblank on Tuesday August 03, 2021 @10:29PM
(#28056544)
Thanks :)