[Libreoffice-bugs] [Bug 144265] New: Relative referencing anomaly

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: roberg at 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 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210902/2232dbea/attachment.htm>