News for hackers. Stuff that matters.
Re:Excel will allow certain auto data conversions to be turn... by cm2187 on Monday October 23, 2023 @04:12AM (#37982813)
And to all developers: don't use leading zero in a numeric id stored as text unless you are vicious!
Re:Excel will allow certain auto data conversions to be turn... by mbreese on Monday October 23, 2023 @07:08AM (#37984032)
It’s really sad that we all basically have to design code and data fields around the behavior tools like Excel. R will do the same thing for numeric fields (strip leading 0s), so it’s not just Excel here. But in the R case, you rarely read/write to the same file, so it’s less of an issue.

Then again, these issues have been known for decades, so a lot of things like your best practice are around for a reason…

Re:Excel will allow certain auto data conversions to be turn... by uxp8u61q on Monday October 23, 2023 @08:11AM (#37984543)
It's really sad that the tool you design should adapt to its users rather than its users having to adapt to your tools?
Re:Excel will allow certain auto data conversions to be turn... by snarkypig on Monday October 23, 2023 @05:50PM (#37992044)
It's really sad that all the data interop I write has to deal with Excel at some point, even if it's never supposed to interact with end users at all
Re:Excel will allow certain auto data conversions to be turn... by mbreese on Tuesday October 24, 2023 @03:07PM (#38003754)
More like we can’t name things (eg. gene names) the way scientists want because of needing to work with the data in Excel. So instead of OCT4 we get a different name because Excel mangled the name into a date for decades.

Excel is still the easiest way to look at tabular data, even if it isn’t part of the production workflow. And sadly, even if you save the file as txt, Excel would always mangle certain fields.

So yes… users have been working around Excel-isms for years.

Re:Excel will allow certain auto data conversions to be turn... by gertrunde on Monday October 23, 2023 @07:47AM (#37984340)
If you want to be particularly evil, vary the number of leading zeros so that sorting gets completely broken...