News for hackers. Stuff that matters.
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.
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?
Re:Use Spreadsheets Everywhere by easton on Tuesday August 03, 2021 @08:36PM (#28055956)
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 :)