Re: [libreoffice-users] Suggestion: 3D spreadsheets

On 2020/11/24 14:45, PaddleS wrote:
> Something new an that would be really great is to add implementation for 3 (and potentially more) 
> dimensional spreadsheets.

A long time ago I used a 5-D spreadsheet My experience was that
incredibly badly designed spreadsheets were the norm. Errors were
standard, and debugging was literally impossible.

Memory hungry, and very slow calculations were the most common complaints.

I did not encounter a use case for which a spreadsheet was more suitable
than a database. More pointedly, every use-case presented as a rational
for n-D spreadsheets, was for more appropriate for SQLite or MongoDB
database engine and R programming language.

All that said, if you are learning how to write software, a useful
exercise is to create an n-dimensional spreadsheet, using SQLite as the
database engine.

jonathon

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy