Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Given the example, selecting A4:A8 and inserting rows, results in this value in A13:

=SUM(A10:A12) (Expand reference when new rows are inserted option off)

=SUM(A5:A12) (Expand reference when new rows are inserted option on)

This behaviour is consistent across v3.5.7.2, v4.1.6.2, v4.2.5.2, and v4.3.0.2 under GNU/Linux so would appear to be by design.