https://bugs.freedesktop.org/show_bug.cgi?id=69068

--- Comment #1 from mariosv <mari...@miguelangel.mobi> ---
Created attachment 85403
  --> https://bugs.freedesktop.org/attachment.cgi?id=85403&action=edit
Original sample modified.

Hi Moleskin, thanks for reporting.

Taking your sample, adding a ROUND() function in column D with decimal places
referred to D1, you can see once the decimal places are beyond the computer
precision RANK() function does not work but works properly with 16 decimal
places or less.

Is needed round to get the formulas works as you want.

More useful information about the problem:
http://en.wikipedia.org/wiki/Floating_point#Accuracy_problems

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to