Bug 106919 - CALC: moving cell A1 data changes reference of Range Names in chart which doesn't reference cell A1
Summary: CALC: moving cell A1 data changes reference of Range Names in chart which doe...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
5.2.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart-Data
  Show dependency treegraph
 
Reported: 2017-04-02 22:32 UTC by dawncoyote
Modified: 2023-04-01 19:28 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
screen shots of before/after moving cell A1 (89.79 KB, application/zip)
2017-04-02 22:32 UTC, dawncoyote
Details
File which exhibits bug described (40.35 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-04-03 13:24 UTC, dawncoyote
Details

Note You need to log in before you can comment on or make changes to this bug.
Description dawncoyote 2017-04-02 22:32:47 UTC
Created attachment 132306 [details]
screen shots of before/after moving cell A1

I have quoted text as Range Names in a chart. If I select and move cell A1 to another cell (neither referenced by the chart), the Range Names change to references to the destination cell and the text becomes the column names of the charted data. "Undo" moves the data back from the destination cell to A1, but does not undo the change to the chart.
Comment 1 m_a_riosv 2017-04-02 22:48:58 UTC
Please attach a sample file with the steps to reproduce the issue.
Comment 2 dawncoyote 2017-04-03 13:24:56 UTC
Created attachment 132310 [details]
File which exhibits bug described

Here's a file that exhibits the bug I reported. I have found a second mechanism that causes the same behavior.

1) Open the file. Select and move cell A1 to another location. The names of the series displayed on the chart change to
"Column B"
"Column F"
"Column R" and
"Column T"

If there is text in cell A1, this text becomes the series name on the chart.

Pressing Undo restores the A1 cell back to where it started, but doesn't affect the chart.

2) Open the file. Delete the second page "worth". 

The names of the series change in exactly the same way.

Pressing Undo restores the deleted page but leaves the Data Series names as the range $Solar.$A$1:$A$1, where they had been quoted text.

Let me know if there's any additional information you need.

Dave
Comment 3 m_a_riosv 2017-04-03 14:54:41 UTC
Reproducible.
Version: 5.3.2.2 (x64)
Build ID: 6cd4f1ef626f15116896b1d8e1398b56da0d0ee1
CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; Layout Engine: new; 
Locale: es-ES (es_ES); Calc: group
Comment 4 eisa01 2018-03-29 20:18:31 UTC
Still present, also reported on Windows so setting OS to all

In 3.3 the legend show up as "Column B" etc. from the start

Version: 6.1.0.0.alpha0+
Build ID: a488c7ad2763b944713997911c1ddb0315d8c93f
CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2018-03-26_00:38:29
Locale: en-US (en_US.UTF-8); Calc: group
Comment 5 QA Administrators 2019-03-30 06:12:47 UTC Comment hidden (obsolete)
Comment 6 dawncoyote 2019-03-31 19:04:17 UTC
The bug is still present in
Version: 6.2.2.2
Build ID: 2b840030fec2aae0fd2658d8d4f9548af4e3518d
CPU threads: 8; OS: Mac OS X 10.14.4; UI render: default; VCL: osx; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

I tested it on the file included in the email which asked me to re-test. The bug is present. 

I also tested it on the file from which the test file was originally created. Since the creation of the file, I have rearranged the sheets, and the relevant sheet is now Sheet 4. Moving Cell A1 on Sheet 4 doesn't cause the chart titles to change. 
However, moving Cell A1 on Sheet 1 <does> cause the chart titles to change. Moving Cell A1 on Sheets 1 & 2 leaves the chart titles unaffected.
Comment 7 QA Administrators 2021-03-31 03:41:02 UTC Comment hidden (obsolete)
Comment 8 dawncoyote 2021-03-31 15:02:26 UTC
As of today 3/31/2021) and on version 7.1.1.2, Build fe0b08f4af1bacafe4c7ecc87ce55bb426164676, the bug is reproducible in both methods:
i.e. have a chart with a Data Range named using quoted text, and either
1) select and move cell A1 on the first sheet to another location on that sheet, or
2) delete the 2nd sheet

both cases cause the chart Data Range to change from quoted text to something else;
In case 1, the Data Range becomes a reference to the cell located at the destination of the move.
In case 2, the Data Range becomes a reference to cell A1 on Sheet 1.

Hope this helps.
Comment 9 QA Administrators 2023-04-01 03:23:16 UTC Comment hidden (obsolete)
Comment 10 dawncoyote 2023-04-01 19:28:11 UTC
Per email request, I downloaded latest version of LibreOffice (7.5.2.2, gerrit.libreoffice.org / core / 53bb9681a964705cf672590721dbc85eb4d0c3a2) and tested the bug.
The behavior is the same: moving cell A1 elsewhere on the sheet causes a reference on a chart to be changed to the destination cell, and the contents of the relocated cell are now the label on the chart.