Bug 136544 - formulas get corrupted when deleting columns
Summary: formulas get corrupted when deleting columns
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.4.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Formula
  Show dependency tree / graph
 
Reported: 2020-09-07 10:42 UTC by vsoler
Modified: 2020-12-15 12:53 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
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 vsoler 2020-09-07 10:42:59 UTC 
Description:
when deleting a colums, the formulas of cells based on them get changed and mistaken

Steps to Reproduce:
in cell A1 enter 2
in cell B1 enter 3
in cell C1 enter =A1*B1

now, delete column B and watch the formula next to it, which has becomed =A1*A1 which is completely wrong

Actual Results:
=A1*A1

Expected Results:
=A1*#ref


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: es
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 Oliver Brinzing 2020-09-13 15:04:43 UTC 
> Actual Results:
> =A1*A1

i can *not* reproduce it with:

Version: 6.4.6.2 (x64)
Build-ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115
CPU-Threads: 4; BS: Windows 10.0 Build 19041; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: 

Version: 7.0.1.2 (x64)
Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc:
Comment 2 BogdanB 2020-09-13 15:09:12 UTC 
I can NOT confirm
In my case is =A1*#REF!1
Comment 3 BogdanB 2020-09-13 15:09:39 UTC 
What version do you use?
Comment 4 BogdanB 2020-09-13 15:10:37 UTC 
Go to Help - About LibreOffice to find your version and copy the text from there.
Comment 5 zcrhonek 2020-12-07 22:12:23 UTC 
I cannot reproduce with Version: 7.2.0.0.alpha0+
Build ID: 7673b027daed248d1be4dd1a773bfc0334a00c53
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

Go to Help - About LibreOffice to find your version and copy the text from there.
Comment 6 Justin L 2020-12-15 12:53:07 UTC 
Several reports where it cannot be reproduced in any of the supported versions of LibreOffice. Closing due to lack of response from OP.