News for hackers. Stuff that matters.
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.