[Libreoffice-ux-advise] [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 #30 from steffan.steffner at gmx.net ---
(In reply to Mike Kaganski from comment #29)

> 
> The proper way when filling "invoices" is not relying on implicit
> general-purpose software rounding rules, but to explicitly define proper
> rounding in proper places (=ROUND(A1/B2;2)), or use pre-made templates from
> your accountants, with such thigs prepared. And no, trying to implement what
> you suggest to make this "special case but not a rare case" is just
> misguided.


I'd agree that probably the "correct" solution is to use the "ROUND" switch for
every cell in the invoice. I can tell you that I use Calc for sending invoices
to my customers, and if they check if everything is correct, they would
probably just get out the calculator and type in what they see. Not that they
would contact me because of 1 Eurocent difference, they might just think that
my work is sloppy overall. 

So actually, for me to make spreadsheets for my invoices without the option
"precision as shown" will make the task much more tedious, because instead of
setting one option, I'll have to go into the details for every single cell. 


> 
> (In reply to steffan.steffner from comment #24)
> > And I would agree with comment #23 that
> > in order to achieve this (=only show if it makes a difference) there is a
> > performance penalty in that you have to do the calculation twice, one time
> > with the normal precision (which is about 15 digits) and a second time with
> > the decimal accuracy as shown. My best bet would be that this could take
> > like 50 milliseconds on an average computer. 
> 
> I laughed when read that. You obviously do not realize what tasks
> spreadsheets are used for. It's common to have hundreds of thousands of
> formulas in a document. Some recalculations may take minutes. What you
> suggest is "dear heavy Calc users, please rest more, waiting while your
> spreadsheet is recalculating".



Before you start thinking to proceed by taking out altogether the option
"precision as shown" from Calc, I would like to mention the following: 
I haven’t seen any post about people being in trouble because they activated
“precision as shown”, and then forgot about. As I just tested, for every new
document you create, the default setting for this option, which is “precision
as shown” *off*, is set again. So, for being in trouble with this option, you
would need to make a template, set this option, and then forget about it when
you use this template.

So, as you can see, I am really defensive now, and as I said, I don’t really
need this tooltip anymore, since I am now an expert, at least for this very
option, and I do agree that the “double calculation” penalty would matter for
heavy users.

So, I’d now make the call to make this bug a “WONTFIX” (before other bad things
happen).

-- 
You are receiving this mail because:
You are on the CC list for the bug.