3 ms·
E.g. Excel does that still.
by rightbyte 3y ago
E.g. Excel does that still.
- hulitu 3y agoYes. The best is when you get an Excel file from Japan and the formulas are in Japanese. Who needs encryption or obfuscation.
- deleted 3y ago[deleted]
- Kwpolska 3y agoNo? Formulas are stored in a language-independent way, you should see English formulas in that file.
- zinekeller 3y agoThe missing part of that story is probably the file is a .xlsm (or even an older .xls with macros) and therefore has VBA scripts, which is not saved in a language-independent way.
- COM2323 3y agoProbably someone manipulating with formulas with VBA and improperly using FormulaLocal property. Formulas are stored in language neutral way and it shouldn't be a problem under normal circumstances.
- pezezin 3y agoBut is it Shit-JIS, or are you lucky enough to get UTF-8?
- netsharc 3y agoSo obnoxious, although apparently in newer versions you can modify what language you want. I remember seeing the dictionary to translate between German and English function names[1], one time I googled for "Excel German translation" and Google proudly showed the Translate interace pre-filled with "English: excel / German: übertreffen" [1] https://www.perfectxl.com/excel-glossary/what-is-excel-function/translations-german-english/ https://www.perfectxl.com/excel-glossary/what-is-excel-funct...
- arp242 3y agoThe feature itself isn't that crazy – it's even a good thing, especially considering that Excel (and to lesser degree, VBA) were designed for ordinary people and that in the 80s/90s English was less common than it is today. Where it went wrong is that as soon as you choose a language you were stuck with that. It should have been a display option.