this post was submitted on 13 Jan 2024
174 points (93.1% liked)
Asklemmy
43731 readers
1269 users here now
A loosely moderated place to ask open-ended questions
Search asklemmy ๐
If your post meets the following criteria, it's welcome here!
- Open-ended question
- Not offensive: at this point, we do not have the bandwidth to moderate overtly political discussions. Assume best intent and be excellent to each other.
- Not regarding using or support for Lemmy: context, see the list of support communities and tools for finding communities below
- Not ad nauseam inducing: please make sure it is a question that would be new to most members
- An actual topic of discussion
Looking for support?
Looking for a community?
- Lemmyverse: community search
- sub.rehab: maps old subreddits to fediverse options, marks official as such
- !lemmy411@lemmy.ca: a community for finding communities
~Icon~ ~by~ ~@Double_A@discuss.tchncs.de~
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
I hate using Excel for this reason. ALMOST all functions are translated, so you're never sure what to look for. If you find a solution for a problem online? Doesn't work, you'd have to rewrite it in your language. And you can't even switch the language in settings, because it's tied to the OS language (maybe you can in recent versions, haven't bothered to check for a while).
This is why I never touch language setting in any OS. It's guaranteed I'll have some problem down the line because I can't search the problem or understand the solution if error crops up someday, because the menus are different.
Error messages are a pain to search for when they are translated too.
This is why it's good to have unique error codes in addition to messages. It also helps with error monitoring as you can aggregate errors by their error code rather than message (which can have variables in it, different languages, etc).
Error codes can be useful but I find that a lot of vendors using them rely on the code too much to classify errors as identical. Usually the variables do matter, e.g. which file couldn't be opened or which action was attempted by whom that got a permission denied error.
Not sure about VBA, but Excel formulas are actually saved in English and translated on file load. It doesn't translate strings though, so EVALUATE only works for users with the same language as the author.