Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 16 Feb 2017 01:14:14 +0100Libreoffice Calc mode.sngl - err:538https://ask.libreoffice.org/en/question/87744/libreoffice-calc-modesngl-err538/Hello,
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,
Sam
Wed, 15 Feb 2017 21:58:57 +0100https://ask.libreoffice.org/en/question/87744/libreoffice-calc-modesngl-err538/Answer by Gilward Kukel for <p>Hello,</p>
<p>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.</p>
<p>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).</p>
<p>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?</p>
<p>Thanks in advance,</p>
<p>Sam </p>
https://ask.libreoffice.org/en/question/87744/libreoffice-calc-modesngl-err538/?answer=87758#post-id-87758I 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.Wed, 15 Feb 2017 23:01:39 +0100https://ask.libreoffice.org/en/question/87744/libreoffice-calc-modesngl-err538/?answer=87758#post-id-87758Comment by 2trax for <p>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.</p>
<p>You can generate a pivot table of the values and their counts, sorted by the counts.</p>
https://ask.libreoffice.org/en/question/87744/libreoffice-calc-modesngl-err538/?comment=87765#post-id-87765Thanks 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!Thu, 16 Feb 2017 01:14:14 +0100https://ask.libreoffice.org/en/question/87744/libreoffice-calc-modesngl-err538/?comment=87765#post-id-87765