Bug 137564 - EDITING CALC Simple relative references not updated inserting or deleting row(s) directly above
Summary: EDITING CALC Simple relative references not updated inserting or deleting row...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-10-17 18:27 UTC by thomas.wolf.de
Modified: 2020-10-17 19:30 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Demo Insertion/Deletion rows without update of simple relative references (5.37 KB, application/zip)
2020-10-17 18:27 UTC, thomas.wolf.de 		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 thomas.wolf.de 2020-10-17 18:27:47 UTC 
Created attachment 166467 [details]
Demo Insertion/Deletion rows without update of simple relative references

Hi,

The insert or delete of a row directly above a simple relative reference '=xy', does not change that reference.
A relative reference in functions like SUM is adjusted as expected.

I attached a simple demo Calc file.

Best regards,
Thomas
Comment 1 m_a_riosv 2020-10-17 19:30:21 UTC 
If you delete the row or column of a reference cell, the reference it's replaced with !REF# what it's fine the referenced cell doesn't exit anymore.

With functions like SUM the reference it's adapted depending on the status of Menu/Tools/Options/LibreOffice calc/General - Expand references when new columns/rows are inserted.

https://help.libreoffice.org/latest/en-US/text/shared/optionen/01060300.html?DbPAR=SHARED#bm_id3151110

There is not a bug.

Please when new issues like this one, can you go first to https://ask.libreoffice.org/en/questions/