more than 3 conditional formats in openoffice calc

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. Pull down Format -> Conditional Formattingĥ.NUMBERTEXT and MONEYTEXT are spreadsheet functions for number to number name and currency name conversion proposed for OpenFormula standard. Take note of the row number of the bottom of your selection (in my example I will use row 7)Ĥ. Take note of the letter of the column which you would like to compare the conditional against (in my example I will use Column A)ģ. Drag from the top left to bottom right so that the active cell in the selection is the last cell of the last row.Ģ. Highlight entire range you'd like to format. Once you have your styles created ( I will use the examples Green, Yellow, Red1, Red2, Red3 below), you can create unlimited conditional formatting as follows:ġ. There are several ways to do this, the easiest one in my opinion is to style a sample cell the way you want and then create a style from that cell. The first step is to create the styles that you want to be able to apply, and name them. I have figured out how to do this, and will put the solution here for future google users so that the title of this thread as 'Solved' is actually accurate. Thanks, but 'install a different program' is equally unhelpful.

More than 3 conditional formats in openoffice calc