Calc has 3 functions to calculate the modal value. MODE is fully compliant with ODFF1.2 and MODE.SNGL and MODE/MULT are fully compatible with Excel.
Excel does not return the same result in some cases as Calc with the function MODE, both when saved as ods or xlsx.
It would help users when the help text for the MODE functions include text reflecting the first two lines of this description.
Steps to Reproduce:
User Profile Reset: No
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0
@Olivier: sorry, I missed your patch:
*** This bug has been marked as a duplicate of bug 97977 ***