[Libreoffice-bugs] [Bug 141292] Calc should display hint "internal calculation is done without rounding".

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=141292

--- Comment #34 from steffan.steffner at gmx.net ---
(In reply to Heiko Tietze from comment #31)
> Suggest to put the option into a separate frame and to add an icon at the
> statusbar indicating the setting. Was thinking about to switch between on
> and off but this makes access to the potentially harmful option too easy.
> 
> Steffan: I guess you disagree with the recommendation but otherwise it would
> be helpful to change the summary.

Well, as I said, reporting a bug on this issue was never to serve me per se -
because once you know about Calc using more digits than shown, and that this
can make a difference for your result, you don't really need any hint on this. 

So my idea was, I have been frantically searching for on hour, I want to spare
this to other users of Calc, who might want to quit LibreOffice because they
might think it is not a reliable product. I have to admit, I am one of those
users who do not have an extended knowledge of spreadsheets, but just use it
randomly for minor purposes, which is my case writing invoices to customers.
And my best bet would be, that there are a lot of Non-Expert-Users who might
need some info if they come across such a case.

I would also agree that not every invoice will have to be handled in the way I
describe it, but to me it seems to be the most plausible way for everyday
invoices, because I would probably check if the numbers as shown on paper add
up, if I received one that I had to pay.

And, I certainly think that the hint from Mike to instead use the ROUND
function  is very useful,like in my case e.g ROUND(B19*0,16;2)on only 2 places
in my invoice where I calculate the respective VAT rates, which are the only 2
places that could cause the effect I described.

So, actually I don't have an opinion on this any more. Even if you decided to
scrap the "precision as shown" function, it wouldn't make me quit using
LibreOffice, since there is the ROUND function alternatives that I know now
thanks to the hint from Mike.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210415/bfe0ad67/attachment.htm>