News for hackers. Stuff that matters.
Re:Cursed Excel: "1/2"+1=45660 by mulmen on Monday April 07, 2025 @01:40PM (#43613982)
Well, no, it isn't because Excel actually changes the underlying data too. It's more like changing the formatting of all the files in the project and deleting all the characters after the 80th column.
Re:Cursed Excel: "1/2"+1=45660 by deepsun on Monday April 07, 2025 @06:00PM (#43616422)
Does it? I think it only affects when you enter the value, it doesn't change the underlying data that someone else stored in a doc.
Re:Cursed Excel: "1/2"+1=45660 by mulmen on Tuesday April 08, 2025 @02:37PM (#43625104)
I just tested it. The setting applies on data entry but opening a CSV or similar delimited file counts as “data entry”. So if you work strictly with xlsx files you are fine but it will irreversibly convert the values on open for delimited files unless you change the defaults.