https://bugs.documentfoundation.org/show_bug.cgi?id=144265
Bug ID: 144265 Summary: Relative referencing anomaly Product: LibreOffice Version: 7.3.0.0 alpha0+ Master Hardware: All OS: Linux (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: rob...@iafrica.com Description: When I add rows above a row, the first row that moved formula does not seem to be adjusted correctly. Steps to Reproduce: 1.create or open a file with formulas 2.add rows above a row 3. Actual Results: in attachment 1 the formula in cell I6 is =IF(F6<>F5,F6&E6&I5,"") after adding 3 rows the formula is =IF(F9<>F5,F9&E9&I5,"") the next row the formula is =IF(F10<>F9,F10&E10&I9,"") Expected Results: It seems to me that F5 should have been F8 and I8, not remained as F5 and I5 Note that this happens in Calc v6.4 as well Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-GB Module: SpreadsheetDocument [Information guessed from browser] OS: Linux (All) OS is 64bit: yes Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: d5ade739771ddf06cc7ee6d4af15672bfcf09ed6 CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-09-01_02:56:07 Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.