That's probably the reason why one cannot "open" a CSV file directly in Excel and having it displayed properly; one has to go through the whole "import" process. Yet Windows insists all CSVs should automatically open in Excel.
Both of these things are consistent with trying to keep users in Excel. Make it easy to accidentally open Excel, but don’t make it too convenient to use open data formats when you have a proprietary one.
Maybe... but I wouldn't be so quick as to assume bad intent ("never attribute to malice", etc.)
What's the deal with "copy" for example? Why does the source of the copy have to be highlighted, why is it so fragile, why does it disappear from the clipboard when one presses the Escape key? This has been the case since I think the very first version of Excel, and never changed.
I don't know of any other program that works that way. It didn't make sense then (I think), and it doesn't make sense now.
The OOXML format is heavily oriented around internal details of Office in ways that makes it pretty inconvenient to work with even if it's "open". Also IIRC some more esoteric parts are just binary blobs that aren't actually documented and the specifications just say to do what Office does.
Comments
Both of these things are consistent with trying to keep users in Excel. Make it easy to accidentally open Excel, but don’t make it too convenient to use open data formats when you have a proprietary one.
Maybe... but I wouldn't be so quick as to assume bad intent ("never attribute to malice", etc.)
What's the deal with "copy" for example? Why does the source of the copy have to be highlighted, why is it so fragile, why does it disappear from the clipboard when one presses the Escape key? This has been the case since I think the very first version of Excel, and never changed.
I don't know of any other program that works that way. It didn't make sense then (I think), and it doesn't make sense now.
XLSX is openly documented and free to use without royalty, it's not proprietary
The OOXML format is heavily oriented around internal details of Office in ways that makes it pretty inconvenient to work with even if it's "open". Also IIRC some more esoteric parts are just binary blobs that aren't actually documented and the specifications just say to do what Office does.