It also has really broken handling of text encodings.
I've taken to importing CSV files using Apple Numbers, and saving as Excel
(i use Numbers primarily, Excel is just when I need to be interoperable with someone else)
Well I would give Excel some cred for acctually following local number conventions. It the beginning there was no internet and interoperability issue.
Usually it is the us-en way or the highway.
Surely the folks programming it are not that short-sighted. It's just a punishment for not using their default format.