Bug 144265 - Relative referencing anomaly
Summary: Relative referencing anomaly
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.0.4 release
Hardware: All All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Add-Delete
  Show dependency tree / graph
 
Reported: 2021-09-02 09:32 UTC by Elmar
Modified: 2023-05-20 02:37 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
before inserting rows (26.40 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-09-02 09:35 UTC, Elmar 		Details
after inserting rows (23.80 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-09-02 09:35 UTC, Elmar 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Elmar 2021-09-02 09:32:05 UTC 
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
Comment 1 Elmar 2021-09-02 09:35:09 UTC 
Created attachment 174724 [details]
before inserting rows
Comment 2 Elmar 2021-09-02 09:35:39 UTC 
Created attachment 174725 [details]
after inserting rows
Comment 3 raal 2021-09-03 09:15:30 UTC 
confirm with Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: 34a9f93018804044b756e0e49c7ea759a65d3dc4
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

and Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Comment 4 m_a_riosv 2021-09-05 11:08:54 UTC 
Confirmed
Version: 7.2.0.4 (x64) / LibreOffice Community
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL
Comment 5 ady 2023-05-20 02:37:07 UTC 
Still repro with LO 7.6.alpha, but only in 1 specific row – the first one in the list. This indeed is a major issue IMHO, because of user expectations and because the behavior is not known nor easily notable by common users.