It does not handle large volumes of data. I cannot get it to process a simple 50MiB CSV file on my desktop without it freezing for a while.
It does not understand timestamps/dates property. It assumes you have a record for every minute, otherwise 14:01 and 14:35 are put next to each other.
It does not properly handle numbers. Internally everything is stores as a IEEE double.
If a cell contains only digits, and assumes it is a number even though it cannot handle it. "000005234523453249587234985" is simply ruined.
It is the main competitor of a lot of specialized software. I work on software for the logistics sector, a big competitor of our business is MS Excel. If you ever wonder why things went wrong with your online order, there is a fair chance some company used Excel, and messed something up.
It is too easy to use, but too hard to use. It's like MS Paint with numbers.
PS, LibreOffice Calc does not solve many of those issues.
PPS, If somebody knows something between MS Excel and R to handle larger data sets to plot some graphs, please tell me.
I see a lot of these as productive compromises rather than bugs, but interesting thoughts in any case. It turns out that all software is built on compromises, even Excel.
If a cell contains only digits, and assumes it is a number even though it cannot handle it. "000005234523453249587234985" is simply ruined.
A quick note on this: If you input '000005234523453249587234985 into the cell it will store as a string and maintain the leading 0's. This is a pain for working with, but does make the numbers display nicely.
I recently found out about this because a user was inputting numbers like this and breaking a formula later on the page 🙃
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Hard disagree. It's over appreciated.
PS, LibreOffice Calc does not solve many of those issues.
PPS, If somebody knows something between MS Excel and R to handle larger data sets to plot some graphs, please tell me.
I see a lot of these as productive compromises rather than bugs, but interesting thoughts in any case. It turns out that all software is built on compromises, even Excel.
A quick note on this: If you input
'000005234523453249587234985into the cell it will store as a string and maintain the leading 0's. This is a pain for working with, but does make the numbers display nicely.I recently found out about this because a user was inputting numbers like this and breaking a formula later on the page 🙃