Hacker News new | ask | show | jobs
by nuclearcookie 3081 days ago
That's what they do with formulas in Excel. There it sucks HARD. Try googling for documentation on StackOverflow for example. Anything you want to copy paste doesn't work because Excel is expecting the commands in a different language.
3 comments
zbentley 3081 days ago
That sounds like there's a demand for a code-help service that is syntactically aware enough to perform translations into the viewer's native language. I'm sure it would be harder to implement than a basic text-only + syntax highlighting site, but imagine how nice it would be to have your user's language preference (or, if not logged in, with a dropdown "pick $human_language for this $programming_language snippet"). You could also optionally integrate Google Translate or similar for the non-programming-language parts (obviously with less accuracy, but still better than nothing).

Searchability would be tricky, since google etc. might detect the very-similar-but-for-code-snippets links as duplicate/spam and bury them, but there are hopefully ways around that--up to and including asking google to somehow improve their algorithm; it seems like they might be sympathetic (because they're programmers and because there's money to be made) to a request to accommodate such search patterns.

Not only would that solve the problem you posed (googling for stuff on SO is tricky for you as a (presumably) English speaker if it's in another language), but it would also address a far wider-reaching problem with big implications: the relative inaccessibility of programming, especially at the early-beginning stages, to people who are not fluent English speakers.

link
Retra 3081 days ago
Sure, you can solve almost any problem without a budget...
link
dx034 3081 days ago
If you google in your native language you'll get results in that language. I agree that it takes a bit to relearn all formulas (and I find it too confusing to use different versions at the same time) but when I was still using a non-English version I had no problems finding solutions.

I think it was exactly the right thing to do. Excel formulas are often used by people with little knowledge of programming who aren't aware that "if" is a common keyword. Using the local variant makes formulas much easier to understand (and to get people closer to actual programming).

link
nuclearcookie 3081 days ago
I agree it's a good move from Microsoft to make Excel more accessible. It's just not something I was expecting the first time I stumbled upon the problem.

I have a programming background so I'm used to searching everything in English, even though that's not my native language.

I inserted sqrt() in my non-English Excel and it didn't work. I thought I had a completely broken version of the program. Took a while to figure out it was a language problem!

link
Nullabillity 3081 days ago
And now you need to maintain hundreds of variants of each SO answer.
link
pjmlp 3081 days ago
It only sucks for us, that are used to English as "programming language".

Many Office users only speak their native tongue, are quite happy with the translations and don't even know that StackOverflow exists.

They rather buy books, https://www.fca.pt/en/catalogue/computer-science/office/page...

link