Hello,
I use Libre Calc 7.0.1.2, on Ubuntu 18.04.1
I have written this formula in my Libre Calc cell :
=SQRT(SUM($C33*(D33-$D$62)²,$C34*(D34-$D$62)²,$C35*(D35-$D$62)²,$C36*(D36-$D$62)²,$C37*(D37-$D$62)²,$C38*(D38-$D$62)²,$C39*(D39-$D$62)²,$C40*(D40-$d$62²,$C41*(D41-$D$62)²,$C42*(D42-$D$62)²,$C43*(D43-$D$62)²,$C44*(D44-$D$62)²,$C45*(D45-$D$62)²,$C46*(D46-$D$62)²,$C47*(D47-$D$62)²,$C48*(D48-$D$62)²,$C49*(D49-$D$62)²,$C50*(D50-$D$62)²,$C51*(D51-$D$62)²,$C52*(D52-$D$62)²)))
(trying to calculate a standard deviance for random variables. no, the “stdev” won’t do here, because i need a different probability for each summand.)
it always gives me Error 508, which - as I have read here Error Codes in LibreOffice Calc - LibreOffice Help means “Error: Pair missing”, i.e. “Missing bracket, for example, closing brackets, but no opening brackets”
So I checked, and yep, it seems like there is one bracket too much at the end (in the formula I put above). However, whenever I try to delete a bracket, LibreCalc automatically puts one back in when I press enter, and then gives me the Error 508.
I have tried the same thing in another cell - it seems as if Libre Calc automatically adds or takes away (un)needed brackets until it has the correct amount. Which is nice normally, I guess, but not when LibreCalc miscounts, forces me to take one bracket too much, and then complains via “Error508” that it has too many brackets.
I have closing and opening LibreCalc, hasn’t helped.
Happy about any input.