Created attachment 138339 [details] LO Calc spreadsheet showing calc errors LO versions 5.4.3.2 and 5.3.7.2 both produce this error. A sample spreadsheet portion is attached. Column O calculates the result of SUM(dX:nX)-MIN(dX:nX) for row numbers X=3 to X=24. Four of the results, in rows 5, 12, 16, and 18 (in blue), are incorrect. The correct ones are shown in column P. Except for row 16, the error is the value in column D: it seems to be ignored.
The Sum()-Min() for Row 16 elements is found to be as calculated (i.e, 21.9-0.0 = 21.9). For all other wrongly calculated sums, the value in column D has an apostrophe(') at the start. You may confirm that by clicking over those particular cells(D5,D12,D18) and see the apostrophe in the formula bar. This may be due to wrongly importing the data or due to human error, whichever the case be. If the problem is still persists, kindly revert back or please do tell if it resolved. Thanks
Created attachment 138340 [details] Selecting D5 and observing an apostrophe in the formula bar The Sum()-Min() for Row 16 elements is found to be as calculated (i.e, 21.9-0.0 = 21.9). For all other wrongly calculated sums, the value in column D has an apostrophe(') at the start. You may confirm that by clicking over those particular cells(D5,D12,D18) and see the apostrophe in the formula bar. This may be due to wrongly importing the data or due to human error, whichever the case be. If the problem is still persists, kindly revert back or please do tell if it resolved. Thanks