https://bugs.documentfoundation.org/show_bug.cgi?id=159807
Bug ID: 159807
Summary: Cell reference not updating with sheet sorting
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
EDITING
hello, just noticing a bug on calc. i have a sheet and when i am sorting,
either through the ascend/descent or autofilter, the references on other sheets
do not update properly
for one example; one page has a list of ingredients, with prices/kg, and other
pages have recipes which link to those ingredients and prices, but if i sort
the ingredients, the prices never change, they still reference the old cells,
where the correct data once was, giving either the wrong prices, or div/0 or
other such parsing errors.
Steps to Reproduce:
1. if using sort ASC/DESC, select fields. if using autofilter, open context
menu select ASC/DESC. list sorts as expected
2. go to other sheets which reference this list, directly or indirectly, and
the cell references are still pointing at pre-sorted locations
Actual Results:
prices/weights of ingredients are scrambled or parse erroring
Expected Results:
cell references across sheets updating to new locations, nothing should be
noticeable directly or indirectly on other sheets.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 2; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-CA (en_CA.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.4
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
