Re:The Norway Problem
by imtringued on Sunday April 04, 2021 @01:22PM
(#26691230)
Excel doesn't support CSV files. Anyone who believes that has never used Excel. [0] You're supposed to use spreadsheets as is. Programs that have excel export features should always directly export xlsx files.
[0] The only thing you can safely do with CSV files is to interpret every value as text cell. CSV files always require out of band negotiation on everything, including delimiters, quotation, escape characters, the data type of each column.
Re:The Norway Problem
by blacktriangle on Monday April 05, 2021 @03:36PM
(#26703574)
However....
Users BELIEVE Excel supports CSV file. That's the reality on the ground. Fighting against that is a losing battle.
It's "user error" except that there is no way to set the default import to import as "Text" (as far as I know), so one has to remember to do the three step "Text" import every time instead of the default one step "General" import.