Excel warriors who save governments and companies from spreadsheet errors

Re:Excel warriors who save governments and companies from sp... by jasode on Saturday October 17, 2020 @05:52AM (#24808849)

>, and doesn't do secret magic guessing of whether a value is a date or not.

This Libre Office question&answer[1] in 2020 says it guesses that the users want leading zeros removed from numbers. This behavior is similar to other software tools I looked at.[2]

This means that if a csv has "02142021" as a date for Valentine's Day with a leading zero, it will be imported as number "2142021" -- unless one takes extra steps to prevent the default behavior.

[1] https://ask.libreoffice.org/en/question/246295/how-can-i-imp...

[2] https://news.ycombinator.com/item?id=24696732

[ Parent | on HN ]

Re:Excel warriors who save governments and companies from sp... by n4r9 on Saturday October 17, 2020 @08:00PM (#24814477)

Ok, it might try to deduce the data type, but you can set it in the import options that appear when you open a CSV file. Excel will automatically convert a string like "2-4" to "02-Feb" upon opening a CSV file. No import options appear when you open the file. If you then save the file it then uses that new string. As far as I can tell there's no way to stop it doing this.

[ Parent | on HN ]