Description: I'm a user of Calc (Language of User interface - Korean). At Korean Interface, Function IFNA invokes Error of invaild name and Function ISNA invokes the Error(Err:511 - variable missing). At Panel of Functon List, All list has two ISNA and No IFNA. At other language interface(English, japanese and Chinese), this problem does not occur. You can also see this problem on this page. LibreOffice Help(Korean) https://help.libreoffice.org/Calc/Information_Functions/ko#ISNA_2 It(#ISNA_2) should be Function IFNA, not Function ISNA. ISNA is duplicated. Actual Results: At Korean Interface =ISNA(B2) Err:511 - Error : Variable missing =IFNA(B3) #NAME? - Error : Invalid name Expected Results: At Korean Interface, I hope Function ISNA, IFNA works well. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: ko Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no
Thank you for reporting the bug. it seems you're using an old version of LibreOffice. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Xisco: looking at https://translations.documentfoundation.org/ko/translate/#search=vdEm2&sfields=source,target,notes, it seems "IFNA" is still translated ISNA in KOREAN (contrary to https://translations.documentfoundation.org/zh_CN/translate/#search=vdEm2&sfields=source,target,notes)
(In reply to Julien Nabet from comment #2) > Xisco: looking at > https://translations.documentfoundation.org/ko/translate/ > #search=vdEm2&sfields=source,target,notes, it seems "IFNA" is still > translated ISNA in KOREAN > > (contrary to > https://translations.documentfoundation.org/zh_CN/translate/ > #search=vdEm2&sfields=source,target,notes) @Sophie, could you please notify the korean community about this issue?
Xisco: if it can help, I can make the change from IFNA to ISNA on Pootle
(In reply to Julien Nabet from comment #4) > Xisco: if it can help, I can make the change from IFNA to ISNA on Pootle Let's wait for sophie's feedback on this...
I've contacted DaeHyun, he should come back here or to me directly, I'll let you know. Sophie
Now, I check the "ISNA " message on Pootle, and I changed and submitted. Plz, Check it.
@Sophi, I don't fully understand how the translation process work. Would this change make it to 6.2 branch or is it just fixed in master ?
(In reply to Xisco Faulí from comment #8) > @Sophi, I don't fully understand how the translation process work. Would > this change make it to 6.2 branch or is it just fixed in master ? It depends on which projects it was corrected in Pootle, if in 6.2 it will be on both, if only on master it will be in master.
Reminder: see also bug 93992 with its latest attachment (currently http://bugs.documentfoundation.org/attachment.cgi?id=136017 for 5-4 but that covers the IFNA/ISNA case here) that when loaded in a localized UI checks for duplicated function names.