By inserting rows or columns above the row/column of the total, the formula =SUM is not modified correspondingly giving an incorrect result. (see attached test, noting that the decimal separator is comma (IT))
Created attachment 176331 [details] calc sample test
Options->Calc->General; [x] Expand references when new columns/rows are inserted
Well, ok, but the problem did not occur inserting a line for example above the previous line 5 or 6 (referring to the attached test). What is the reason? That option generically says "Expand references when new columns / rows are inserted" and not "... when are inserted above a total line".
(In reply to gmarco from comment #3) When you insert a row in the middle of a range, your range is technically not expanded - in the sense that the specific rows/columns (not their numbers! the rows/columns as entities), that formulas refer to, are unchanged. OTOH, when you insert above the SUM, the range should change: its last row now should become different entity. And that needs changing the internal references, unlike the first case. People will never need the former case to behave differently; but people may want the latter case to behave differently. Hence the preference.
(In reply to Mike Kaganski from comment #4) > (In reply to gmarco from comment #3) > > When you insert a row in the middle of a range, your range is technically > not expanded - in the sense that the specific rows/columns (not their > numbers! the rows/columns as entities), > I adapt to the answer, but to say "that formulas refer to, are unchanged" is hardly understandable (my deficit) because the formula =SUM(x:y) is always adapted to the new range except in the case initially represented.