search

Numbertext / libnumbertext

Number to number name and money text conversion libraries in C++, Java, JavaScript and Python & LibreOffice Calc Extension
BSD 3-Clause "New" or "Revised" License
68 stars 47 forks source link

LibreOffice 6.1 - could not get to work #37

Closed edmundlaugasson closed 5 years ago

edmundlaugasson commented 6 years ago

Using 64-bit DEB-version of LibreOffice 6.1.0.3, locale in Estonian language. Checked also https://ask.libreoffice.org/en/question/32783/how-to-use-numbertext-or-moneytext-functions/ Tested also https://ask.libreoffice.org/en/question/1194/convert-numbers-to-english-words/ macro code - did not work in LibreOffice 6.1, quotation marks around cell address, language code or number did not help in formula.

Tried to enter either directly with number or using cell address - always getting error: =NUMBERTEXT(5) gives #VALUE! or =NUMBERTEXT(A1,en) where in A1 is located e.g. number 5, gives Err:501 Well, checked at https://help.libreoffice.org/Calc/Error_Codes_in_Calc and understood that this function does not respect my separator (comma) and requires semicolon regardless of what is my locale. When used semicolon, will get: #NAME? ... seems that does not recognize the function. Same happens with moneytext function. Also very uncomfortable is to enter language codes when the beginning is same with any other function's beginning. Also did not find the list of used language codes. To be honest, that =numbertext("help") did not work either - so could not get help.

laszlonemeth commented 5 years ago

1) You can use the NatNum12 modifier in custom number formatting in LibreOffice, see

https://wiki.documentfoundation.org/ReleaseNotes/6.1#New_.E2.80.9Cspell_out.E2.80.9D_NatNum_modifier https://help.libreoffice.org/Common/Number_Format_Codes#NatNum_modifiers (NatNum12 hasn't listed, yet).

2) or install and use NUMBERTEXT LibreOffice extension from https://extensions.libreoffice.org/extensions/numbertext-1/1.0 (in this release, without Estonian support, yet, so it will return with fall-back language English).

Note: LibreOffice and Numbertext extension will have Estonian support soon, but you can install its datafile (https://github.com/Numbertext/libnumbertext/blob/master/data/et.sor) manually, too, in the LO_installation/share/numbertext path, to get working Estonian number to number name conversion in LibreOffice.

edmundlaugasson commented 5 years ago

[NatNum12 €]0 gave me e.g. € 12 into cell. Probably did not completely understand that NatNum system. No words. Sounds interesting but hard to understand for me. That extension seems to be for LibreOffice 6.0 but not for 6.1.

laszlonemeth commented 5 years ago

Try [NatNum12 EUR]0 in 6.1.1 or above, or open this file: http://numbertext.org/tmp/numbertext_estonian.ods

Screenshot in LibreOffice 6.2: numbertext_estonian

edmundlaugasson commented 5 years ago

To be honest, the "euroa" is in Finnish language. In Estonian it should be "eurot". In singular is "euro" and it is correct. Similarly in case of U.S. dollar in plural it is "dollarit" and in singular it is "dollar". Actually it would be nice to choose where the currency value locates: before or after. In Estonian language we usually use after. Also we use often just € and not EUR. Sometimes (e.g. in banks) they might want to use before as banks are often not Estonian ones but resides in Estonia. My result in LibreOffice 6.1.1 is different: libreoffice_6-1-1_result

edmundlaugasson commented 5 years ago

... and after adding the numbertext extension, the result is: libreoffice_6-1-1_result-with-numbertext Shall I use 6.2.x development version?