Infinite decimals in text when 2 only in numbers

[Lidyfab]

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

[laszlonemeth]

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ó