https://bugs.documentfoundation.org/show_bug.cgi?id=169801
Bug ID: 169801
Summary: calc sort doesn't adjust cell references of the form
x$x
Product: LibreOffice
Version: 25.8.3.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When a spreadsheet is sorted which contains cell references of the form x$x the
cell references are not adjusted to reflect the new location of the referenced
cell. This is about as bad as a bug can get - it silently destroyed a
spreadsheet after sorting it (unlike my simple test case which created more
obvious Err 522).
Steps to Reproduce:
1.Create a spreadsheet:
A B
1 1 =A1*B$3
2 2 =A2*B$3
3 3 =5
2. Sort on column B descending
3. Result is Err 522: because cells B2:B4 references to B$1 weren't fixed-up to
its new location of B$3
Actual Results:
3 Err:522
2 Err:522
1 5
B1 now contains a circular reference: =A1*B$1 which sort should have adjusted
to '=A1*B$3'
Expected Results:
3 15
2 10
1 5
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: yes
Version: 25.8.3.2 (X86_64)
Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster;
VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded
Found in 25.2.7.2
Check for updates said it was up to date but clearly it wasn't. Installed
25.8.3.2 and lost the task bar icon.
Dragging calc from the start menu to the taskbar resulted in a generic
executable icon on the taskbar. I should probably raise separate bug reports
for these.
--
You are receiving this mail because:
You are the assignee for the bug.
