I have not selected Expand reference when new rows are inserted still Calc expand cell references in sum formula here is an example:
I have a table as below:
| | A |
--------------------------
| 4 | Particulars |
| 5 | 2 |
| 6 | 3 |
| 7 | 1 |
| 8 | =sum(A5:A7) |
I am inserting 5 new rows with following steps:
- Selecting cell area A4 to A8
- Right click on selected cell area and press insert - entire row
- Result is 5 new rows inserted and exiting table shifted below normally
- But in sum formula at A13 =sum(A5:A12) auto cell reference expend happen and i have not enable this feature
It should not consider Expand reference in this case, normally 5 rows must be inserted with no formula change. This is general practice users copy the tables by inserting rows above or under the existing tables.