News for hackers. Stuff that matters.
Re:Spreadsheet is a software development paradigm by hhh on Friday April 02, 2021 @09:18AM (#26671173)
During a massive migration to a different device management service I opened my CSV and saved it as xlsx as the site didn't support csv. Instantly 12% of the serial numbers had their leading zeroes removed and needed a corrective action. ~1800 devices.
Re:Spreadsheet is a software development paradigm by blacktriangle on Friday April 02, 2021 @09:19AM (#26671180)
Excel "helpfully" auto formatting zip codes, part numbers, etc with leading 0s into integer columns deserves to replace null references as the billion dollar mistake.
Re:Spreadsheet is a software development paradigm by earthboundkid on Friday April 02, 2021 @12:42PM (#26673081)
They remained a couple of genes because Excel routinely mangles the names into dates. https://www.theverge.com/2020/8/6/21355674/human-genes-renam...
Re:Spreadsheet is a software development paradigm by aketchum on Friday April 02, 2021 @09:50AM (#26671392)
Hexidecimal values will often get converted to scientific notation if there is an "e".