Try using Excel in another language than English. You have to hope someone, that speaks your language had exactly the same problem as you, because all the formulas get translated and Excel doesn’t recognize the English version when your language isn’t set to English.
@hstde@Spore Even better, the alphabetical index of function names was generated in English first and then translated, meaning the documentation looks like a scrambled mess in any other language because it is alphabetized according to what the English equivalent would be. #excel
Just wait until you’re working with different time/date formats, like, god forbid, sharing such documents to someone who has their Windows time/date format set differently than you have.
So true… Not only sometimes it makes it hard to find the translated function name (especially since they are adding a lot of new functions) but there are quite often longer… For instance in French you go to a simple ifs to si.conditions…
Try using Excel in another language than English. You have to hope someone, that speaks your language had exactly the same problem as you, because all the formulas get translated and Excel doesn’t recognize the English version when your language isn’t set to English.
God. Damnit.
This is so bullshit that EVERY major datasheet application works the same way. Google Sheets, Microsoft Excel, LibreOffice Calc…
All of them have their functions translated and it makes me have to search for tables of equivalency between them. Fuck that.
Even LibreOffice? Is there any variant which uses a sane format?
Oh god the fucking Excel formulas.
I live in Quebec, and all the excels are in French.
@hstde @Spore Even better, the alphabetical index of function names was generated in English first and then translated, meaning the documentation looks like a scrambled mess in any other language because it is alphabetized according to what the English equivalent would be. #excel
I’ve learned excel in middle and high school in my native language, I absolutely fucking hate the translations… excel-translator.de coming in clutch.
Just wait until you’re working with different time/date formats, like, god forbid, sharing such documents to someone who has their Windows time/date format set differently than you have.
Or try having numbers or strings that look like they could be dates.
That would be unfortunate!
So true… Not only sometimes it makes it hard to find the translated function name (especially since they are adding a lot of new functions) but there are quite often longer… For instance in French you go to a simple ifs to si.conditions…