Created attachment 117014 [details] Test file Win7x64 Version: 5.0.0.2 (x64) Build ID: a26d58f11b99b6aeddf7f7884effea188cc6e512 In test file. Inserting one column in column A. The beginning of the formulas in rows: 7 - 11 - 18 -22 is not updated remains as column A. Regression from: Version: 4.4.4.3 Build ID: 2c39ebcf046445232b798108aa8a7e7d89552ea8 of course Entire references are imported in 4.4 with the rows number.
Same happens with entire rows references. Happens when the beginning and the end of the reference is different. (References having more than one column/row).
I noticed in 5.1 all "is beginning equal" conditions evaluate to TRUE on opening, but in 4.4 rows 9 & 11 evaluate to FALSE. After inserting a column before A, the "Formula" column row 7 has: =SUM(B7:C7) in both 5.1 and 4.4. What exactly am I looking for here?
All of the Formula column rows after inserting: =SUM(B5) =SUM(B7:C7) =SUM(B:B) =SUM(B:C) =SUM($B15) =SUM($B17:$C17) =SUM($B:$B) =SUM($B:$C) Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+ (x64) Build ID: 8b788891796ff0571f779cdbe8ce809c35c42754 TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2015-07-02_23:09:27 Locale: fi-FI (fi_FI)
Thanks @Beluga, reviewing again, seems fortunately it's already solved with: Version: 5.0.0.1.0+ (x64) Build ID: df06ddf79cf0b5aca037630504a07dd8b2341a43 TinderBox: Win-x86_64@62-TDF, Branch:libreoffice-5-0, Time: 2015-06-25_23:33:45 and in master 5.1