NegativeLookBehind@lemmy.world to Technology@lemmy.worldEnglish · 1 day agoMicrosoft Teams is dog shitmessage-squaremessage-square380fedilinkarrow-up11.5Karrow-down151file-text
arrow-up11.45Karrow-down1message-squareMicrosoft Teams is dog shitNegativeLookBehind@lemmy.world to Technology@lemmy.worldEnglish · 1 day agomessage-square380fedilinkfile-text
minus-squareT156@lemmy.worldlinkfedilinkEnglisharrow-up5·edit-223 hours ago And never try to deal with dates and timezones. Or anything that looks like dates. Gene scientists had to revise their whole naming scheme because Excel would see MARCH1 (Membrane-Associated Ring-CH-Finger Type 1), and ‘helpfully’ convert it into a date, rendering it useless (since it uses timestamps on the backend). It’s bad enough that my data science course recommended against opening CSV files in Excel, because it would edit the file to do the conversion, even before you explicitly saving, mangling your data before you could process it.
Or anything that looks like dates.
Gene scientists had to revise their whole naming scheme because Excel would see MARCH1 (Membrane-Associated Ring-CH-Finger Type 1), and ‘helpfully’ convert it into a date, rendering it useless (since it uses timestamps on the backend).
It’s bad enough that my data science course recommended against opening CSV files in Excel, because it would edit the file to do the conversion, even before you explicitly saving, mangling your data before you could process it.