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.
Please attach a sample file with the steps to reproduce the issue.
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
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
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
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
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.
Dear dawncoyote, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
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.
Dear dawncoyote, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
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.