I attach the spreadsheet where I get the error, with personal data
canceled, but the fault present. The error's cell is the I2 with yellow
background and the displaied value of 70,00 (in Italy decimal are
separated by comma).
The error vanishes if you change the number of the position to round,
taking it to 1 or to 3, instead of 2 and then also with 2 the calculus
is correct. Saved, closed and reopened the spreadsheet the result is
correct. I've seen that also only filling again the E2 cell, referenced
in the formula of I2, You get the right result.
The big problem is that it caused a mistake in awarding a tender, which,
as you can imagine, is very serious.
I encountered the error with LibreOffice Writer 6.3.3.2, but also with
the latest available Still version of 6.
Greetings,
Andrea Ferraris
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy