Libreoffice Calc mode.sngl - err:538


I’m trying to evaluate the mode of a dataset consisting of 105,192 values. The values are a list of decimal degrees, each rounded to the nearest 10 degrees using the formula =ROUND(G1/10,0)*10 where cells G1 to G105192 contain floating point values between 0 and 360. I have set the number format of these cells to ‘general’ with no decimal places and one leading zero.

When I try and calculate the mode.sngl on parts of the list, it works fine. However, if I try to calculate for the whole list, I get Err:538. I can’t see this in the list of standard error codes, so I’m not sure what it means (and am not keen to download the source to find out, though I suppose that is a possibility if no-one here happens to know).

Other functions such as min, max and average work fine on the list. I was wondering if perhaps there is a maximum number of values that mode.sngl will accept in a range?

Thanks in advance,


I tried it. It seems that 100,000 is the maximum number of values that mode.sngl accepts.
In the statusbar there is a description of the error value.

You can generate a pivot table of the values and their counts, sorted by the counts.

Thanks Gilward - hadn’t noticed the message in the status bar.
I’ll see if I can contribute to the help documentation so that this limitation is made clear, it might save other users an hour or two of frustration!