Description: Inserting a row just above a cell with a column sum, does not include this row in the SUM. Steps to Reproduce: 1. cell D101 contains =SUM(D20:D100) 2. insert a new row between row 100 and row 101 Actual Results: cell D102 =SUM(D20:D100) Expected Results: cell D102 = SUM(D20:101) Reproducible: Always User Profile Reset: No Additional Info: Versie: 6.2.8.2 (x64) Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee CPU-threads: 4; Besturingssysteem: Windows 10.0; UI-render: GL; VCL: win; Locale: nl-NL (nl_NL); UI-taal: nl-NL Calc: CL
Not a bug. If you want range references to expand when you insert a column or row at their outside edge then activate option Tools -> Options -> Calc -> General, Expand references when new columns/rows are inserted.
This behavior seems correct. If we insert a row between the last number of chosen range (in an example above: D100) and the SUM (D101), the range does not expand automatically. Meanwhile, if we insert any row inside the range, f. ex. between D80 and D81, the SUM will include the new row - it will expand the range automatically: from D20 to D101. Tested on: Version: 6.3.4.2 (x64) Build ID: 60da17e045e08f1793c57c00ba83cdfce946d0aa CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: pl-PL (pl_PL); UI-Language: en-US Calc: threaded
It is not a bug in the way that it is an option. Many casual users don't know this and can be confronted with wrong output without being aware of it. Happily the solution is easy: Make the activation true by default; See Eike Rathke: activate option Tools -> Options -> Calc -> General, Expand references when new columns/rows are inserted.