https://issues.apache.org/ooo/show_bug.cgi?id=121316

--- Comment #1 from Rob Weir <[email protected]> ---
I'm not seeing a bug here.  

What value do you think D10 should be?

Remember, in a spreadsheet you have the actual value of a cell and then you
have the displayed form, which may be rounded according to the format settings
that the user sets on a cell.

So E1 displays 1.90, but the real value is 1.8965517241.  That more precise
value is what is used in the calculation.

If you want the calculation itself to use rounded numbers, then you need to
actually force it with the ROUND() function.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to