Created attachment 177927 [details] bugdoc 1. Open attached spreadsheet. sheet1 has a sum formula which references the "aaa" range. sheet2 has the same sum formula. 2. Copy sheet1 to a new sheet "sheet1_2". Expected: The sum formula on sheet1_2 would copy the "aaa" range so that it references the cells on sheet3. When you change something on sheet1, only the sum formulas on sheet1 and sheet2 are updated. Actual: sheet1_2 still references the "aaa" range. Updating the values on sheet1_2 does not change the sum on sheet1_2. Instead, updating the values on sheet1 updates the sum on all three sheets.
PS: After the fix for bug 145054, the range is already copied when copying the sheet. What is missing, is that the formulas are updated to reference the new range.
I set New. So, there would be 2 "aaa" ranges. Now when LO imports from XLSX or XLS, it doesn't read Database Range as it should. But formula behaves properly on change and sheet copy.