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 22.214.171.124, but also with
the latest available Still version of 6.
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
- [libreoffice-users] Apparent bug in arrotonda (round) function (Calc version 126.96.36.199, also in the last Still) · Comune di Cossato - Andrea Ferraris
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy