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
67 stars 46 forks source link

Infinite decimals in text when 2 only in numbers #114

Open Lidyfab opened 1 year ago

Lidyfab commented 1 year ago

The result of an operation can be writed with billions in decimals when the result arrounded in numbers is only with 2 decimals Capture_numbertext

laszlonemeth commented 1 year ago

Hi Lidyfab,

The problem is that the cell content is not rounded, only its formatting. The solution is to use the new number format of LibreOffice 7.5 (https://wiki.documentfoundation.org/ReleaseNotes/7.5#Default_%E2%80%9Cspell_out%E2%80%9D_number_and_currency_formats), or to round the cell content with ROUND, e.g.

=NUMBERTEXT(ROUND(BQ55;2);"fr")

Thanks for the bug report!

Best regards, László