Description: There's no IFERROR formula in latest version of libre office calc installed with korean language. Reinstalled with english solved the problem. Steps to Reproduce: 1. Install latest version with korean language. 2. 3. Actual Results: No iferror provided. Expected Results: iferror provided. Reproducible: Always User Profile Reset: No Additional Info: I installed with korean languge only.
LibreOffice Calc function names can be localized, and some languages do translate them, most likely to be consistent with the function names used by Excel. It seems Korean just uses the English names. However, the Korean translator(s) didn't choose to leave the string untranslated, and decided to copy the original English strings to translated Korean strings, and made a mistake for IFERROR -- The Korean translation is ISERROR, IS instead of IF: https://translations.documentfoundation.org/translate/libo_ui-master/formulamessages/ko/?checksum=be6e9e14c0a6a28d I don't have the Weblate permission to change the Korean translation though. Julien, I assume you do, and would you please make the change? Thanks. The workaround, besides re-installation with English UI, is switching to English function names. The option is available at Tools > Options > LibreOffice Calc > Formula > Formula Options > Use English function names.
(In reply to Ming Hua from comment #1) > ... > https://translations.documentfoundation.org/translate/libo_ui-master/ > formulamessages/ko/?checksum=be6e9e14c0a6a28d > > I don't have the Weblate permission to change the Korean translation though. > Julien, I assume you do, and would you please make the change? Thanks. Done! :-)
@Cloph: This ISERROR/IFERROR mismatch is in since at least the initial switch to .po in 2017. Maybe the duplicate check (checking for duplicated function names) could had caught this if the real ISERROR function name wasn't removed with https://git.libreoffice.org/translations/+/a8ebe5d6029f6a61ab29ebfbfe331b8646f6ce7d%5E%21/ on 2020-10-25 for 7.1.0 Or was that a result of a duplicate check? In which case there would be room for improvement like removing both translations from .po to get the original name for both.