News for hackers. Stuff that matters.
Re:The Norway Problem by njarboe on Saturday April 03, 2021 @10:35AM (#26681392)
Yes. Excel cells are set to a "General" format that, by default, tries to guess the type of data the cell should be from its content. A date looking entry gets converted to a date type. A number looking string to a number (so 5.80 --> 5.8, very annoying since I believe in significant digits) When you import cvs data, for example, the default import format is "General" so date looking strings will be changed to a date format. This can be avoided by importing the file and choosing to import the data as "Text". People having these data corruption problems forgot to do that.

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.

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.