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.
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…
@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
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !programmerhumor@lemmy.ml
Post funny things about programming here! (Or just rant about your favourite programming language.)
Rules:
Posts must be relevant to programming, programmers, or computer science.
No NSFW content.
Jokes must be in good taste. No hate speech, bigotry, etc.
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.
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…
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.
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?
deleted by creator
@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
Oh god the fucking Excel formulas.
I live in Quebec, and all the excels are in French.