4 ms·
> 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" proce
by tobr 3y ago
> 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.
- tomjakubowski 3y agoXLSX is openly documented and free to use without royalty, it's not proprietary
- resoluteteeth 3y agoThe 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.
- bambax 3y agoMaybe... 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.