5 ms·
I can open a 20 year old excel file on a random pc and it will run perfectly. I will be able to reproduce results and inspect the exact equations generating th
by whatever1 4y ago
I can open a 20 year old excel file on a random pc and it will run perfectly.
I will be able to reproduce results and inspect the exact equations generating these.
Try that with 20yo code (python,c++ whatever)
As a fresh grad I used to hate excel, but now I can totally see why it will never die.
- thrown_22 4y ago>Try that with 20yo code (python,c++ whatever) I regularly compile 35 year old C code. Standards are great like that.
- whatever1 4y agoI fail to compile 1 year old code if I don’t have the exact compiler and library versions that the program required at the time of development.
- thrown_22 4y agoYou should write better code. Excel breaks between versions silently. One of my first jobs out of university was to build a pipeline of excel spreadsheet to ensure they were run in the version of excel and windows they were created in. You could not guarantee that you would get the same results otherwise. This was a slight problem for the brokerage I was working at since it had lost them a few million dollars recently.
- croes 4y agoParent said run perfectly not gives the same result.
- thrown_22 4y agoIf you consider 1+1 = 3 to be running perfectly excel sounds like the right tool for any job you have.
- croes 4y agoNot to mention "bugs" like this https://docs.microsoft.com/en-us/office/troubleshoot/excel/wrongly-assumes-1900-is-leap-year https://docs.microsoft.com/en-us/office/troubleshoot/excel/w...
- lancebeet 4y agoI find this statement quite fascinating because despite my limited experience working with excel I've seen countless compatibility issues, caused either by change of version of excel or change of locale. Perhaps this is caused by user error, but then it sure seems easy to make these mistakes.