this post was submitted on 04 Nov 2023
430 points (95.0% liked)

Programmer Humor

32558 readers
703 users here now

Post funny things about programming here! (Or just rant about your favourite programming language.)

Rules:

founded 5 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[–] hstde@feddit.de 56 points 1 year ago (6 children)

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.

[–] new_guy@lemmy.world 24 points 1 year ago (2 children)

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.

[–] Natanael 3 points 1 year ago

Even LibreOffice? Is there any variant which uses a sane format?

[–] isVeryLoud@lemmy.ca 18 points 1 year ago

Oh god the fucking Excel formulas.

I live in Quebec, and all the excels are in French.

[–] barubary@infosec.exchange 15 points 1 year ago

@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

[–] Nahdahar@lemmy.world 9 points 1 year ago

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.

[–] hinterlufer@lemmy.world 7 points 1 year ago (1 children)

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.

[–] hstde@feddit.de 6 points 1 year ago

Or try having numbers or strings that look like they could be dates.

That would be unfortunate!

[–] Matth78@lemmy.world 4 points 1 year ago

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...