It is not necessary to write lead "ноль рублей" when roubles=0 in many financial documents i must write number of thousands when thousands=1:ġ000= одна тысяча, like in english module Thank you for this cool and very useful extention!
Private Function TrysSkaitmenys(strNum3 As String) As Stringĭim d2 As String * 2 'dešimtys ir vienetai SumLT = UCase(Left(strRez, 1)) + LCase(Mid(strRez, 2)) + Right(strSuma, 2) + " ct" Here's a macro for the currency names (MONEYTEXT), I hope you can extrapolate the NUMBERTEXT from it (drop me an email at for any additional help needed in making this happen):įunction SumLT(NumberArg As Double, intCase As Integer) As String For Writer usage, see Linux Libertine G with Numbertext support and Typography toolbar.Īfter restarting, there are two new Calc functions, NUMBERTEXT() and MONEYTEXT(), i.e.:Ĭan you, please, add the Lithuanian language to this excellent extension? For Java jar and JavaScript libraries, see. MONEYTEXT is functionally top-compliant with the ECMA/ISO standard BAHTTEXT function, and supports more than 30 languages: Africaans, Belgian French, Brazilian Portuguese, Catalan, Chinese, Czech, Danish, Dutch, English, Esperanto, Finnish, French, German, Greek, Hebrew, Hungarian, Indonesian, Italian, Japanese, Korean, Luxembourgish, Polish, Portuguese, Romanian, Russian, Serbian (Latin and Cyrillic), Slovenian, Spanish, Swedish, Swiss French, Thai, Turkish and Vietnamese.
NUMBERTEXT and MONEYTEXT are spreadsheet functions for number to number name and currency name conversion proposed for OpenFormula standard.
0 kommentar(er)
