[Libreoffice-bugs] [Bug 131216] New: function RANK should show equal rank but does not (rare occurrence)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 131216
           Summary: function RANK should show equal rank but does not
                    (rare occurrence)
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jake.zwart at sympatico.ca

Created attachment 158490
  --> https://bugs.documentfoundation.org/attachment.cgi?id=158490&action=edit
Worksheet should open to problem area described above

Function Rank is not giving same rank for identical numbers, intermittent
problem.

Worksheet "Ind ScoreYTD" Cell B111 and C111 have identical numbers to the
precision displayed.  Cell F111 confirms they are identical.

Cell B112 and C112 were copied and pasted as values from the cells above.

Cells B113 and C113 had their values typed in.

Cells B114 to C116 show the results from the function rank.

The value should be 15 in each of these cells.  This is not the case.

Tested with an older version of LibreOffice which gave slightly different but
also anomalous problems.  Tried to recreate the problem in a much simpler
spreadsheet but could not duplicate the problem.

As we were discussing the problem internally we suspected that the variable may
have extremely minor differences that are not visible when the cell is
displayed and that Rank pick up but the boolean = function does not.  However
this does not explain why we could not recreate this bug in another
spreadsheet.  There are some differences in behaviour but still a problem on
the same spreadsheet running on a slightly older version of LibreOffice on a
different Win 10 computer (x64).  This made us suspect minor differences in the
compiler or optimization level.

Version: 6.3.4.2 (x64)
Build ID: 60da17e045e08f1793c57c00ba83cdfce946d0aa
CPU threads: 12; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: en-CA (en_CA); UI-Language: en-US
Calc: threaded

-- 
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/20200308/ac32b277/attachment.htm>