[Bug 121316] I am Trying to get the cells to perform mathematical function correctly after assigning a value of (equal to another cell in the same spread sheet), to one more cells in the mathematical equation.

[bu...@apache.org]

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

--- Comment #1 from Rob Weir <ro...@apache.org> ---
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.