Description: When I edit the Data Ranges of a certain chart in LibreOffice Calc, its 'Data Range' is '$template.$F$4:$G$54' and the 'Data Series' entries likewise begin with '$template". Part 1: If I remove the $ from just the Data Range field, or both the Data Range and Data Series fields, then when close and reopen Data Ranges the $ signs have returned, though sometimes just one Data Series field doesn't have it. Part 2: If I remove the $ signs from only Data Series, sometimes they stay gone for a while, but then eventually in a new sheet (copied from the template sheet) a chart doesn't reflect the data and I find its Data Ranges point to $template, as do the Data Series fields of the original chart again. I do not know what the earliest version affected by this is--I've seen this problem for a while, but had been updating occasionally hoping that a newer version would fix it. I have not found this bug in Bugzilla by searching for 'sheet dollar chart', though I have seen this issue mentioned at this URL: https://ask.libreoffice.org/en/question/74474/can-i-set-a-charts-data-ranges-relative-to-current-sheet/ Steps to Reproduce: 1. Insert a chart in a LibreOffice Calc spreadsheet. 2. In 'Data Ranges' for that chart, remove the $ signs before the sheet name in the Data Range tab and the Data Series tab. 3. Close and reopen 'Data Ranges' and observe that the deleted $ signs have been replaced. 4. (Optional: Copy the sheet and see that the new sheet's chart refers to the cells in the previous sheet, not the new sheet.) Actual Results: Deleted $ signs are replaced as if they had never been deleted. (If only Data Series $ signs are deleted, then they stay deleted for a while and are later replaced with hard-to-predict timing.) Expected Results: Deleted $ signs should have stayed deleted forever. I do not object to either Data Range or Data Series overriding the other (such as adding or removing $ in Data Range adding or removing it from all Data Series fields), but I do object to all fields reverting to having unwanted $ signs. Reproducible: Always User Profile Reset: No Additional Info: Version: 6.2.5.2 (x64) Build ID: 1ec314fa52f458adc18c4f025c545a4e8b22c159 CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: en-GB (en_GB); UI-Language: en-GB Calc: CL
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Created attachment 153077 [details] The spreadsheet in question, containing a template sheet and the sheet copied from that template sheet. This shows how, with data added in the copied sheet, the chart does not reflect the added data. (A further question: is it possible that the problem is remaining in the file from a previous version, and is not due to the current LibreOffice Calc version itself? Does a new spreadsheet file work as intended, while this one doesn't?)
Bibisected with Linux 43max to https://git.libreoffice.org/core/+/b193123b8e658d2eb25af5debe9de9e1b2386ef8%5E!/ I see it changed a chart-related thing: OUStringBuffer aEntry(::chart::DialogModel::ConvertRoleFromInternalToUI(rRole)); Note: I don't reproduce this with any version: > 4. (Optional: Copy the sheet and see that the new sheet's chart refers to the cells in the previous sheet, not the new sheet.) The copied reference is absolute, yes, but it refers to the new sheet.
Dear multipartite, 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