Description: A page with data and an embedded chart is copied. This entire page is then pasted into a new sheet on the same workbook. The chart on the pasted page SILENTLY refers to the data on the original sheet; this is not available for editing ie the only way to get a chart for the new sheet is to delete the old chart and re-make it. This is not user-friendly when copy/pasting sheets with comlex charts, eg for a "Before/After" analysis with changes to data made on the second sheet. Presently, the editor for the DataRanges is silent about which sheet it refers to (user confusion: the cells etc shown make sense for the duplicate page - but are not the duplicate page!) Suggestion: DataRange editor should: a) show the sheet to which the cells cited refer, and b) allow the sheet only to be changed - so that the chart is now drawn from the current sheet (the duplicate, not the original). :) Actual Results: Confusion - the ranges look right, why does this chart not draw my data??? Expected Results: Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36 OPR/43.0.2442.1144
Not reproduced. Here's my new data range after pasting: $Sheet2.$A$1:$B$3 Arch Linux 64-bit, KDE Plasma 5 Version: 5.4.0.0.alpha0+ Build ID: 54f9a81a1c041c18d209d7eb4659ac18a3ca76dd CPU threads: 8; OS: Linux 4.10; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on March 25th 2016
Hi, And reproduced again - now with further clarification. Here is the sequence: 1) boot into Windows. I'm seeing this on Windows 7. 2) start LO Calc. Open a s/s with a chart; I'm using 3 columns of data points with a line chart. 3) <image held, do not see a means to upload...> Note on the Source sheet the Data Range icon (3 coloured columns with a stack of discs in front) is visible in the title bar (well, on mine it is). Next to it is grey'ed out DataTable icon 4) make a new sheet, go back to source sheet and grab it all by clicking in top left square; Copy. Click on the new sheet A1 and Paste. Double-click the Chart. 5) on my machine, the Data Range icon mentioned in (3), on the copy, is now Greyed out. Next to it is a DataTable icon, of two blobs on a sheet. This is now coloured (but grey on the source sheet) 6) the only option offered by double-clicking around the copy chart (on frame or the data line) is DataTable. DataTable has no data range display, nor means to edit this. Can't use DataRange as: Greyed out and / or not an available option (under any right-click option or menu list that I can find in 20 mins). :) How did you get your data range shown? I can't reproduce what you've shown. Version 5.3.1.2 All good fun!
OK, some images: http://www.srb542.talktalk.net/SourceSheet-DataRangesIssue.jpg that's the source sheet, with the chart clicked. DataRanges (in red circle) coloured. http://www.srb542.talktalk.net/LO-Calc-DataRangesIssue-pic1.jpg Copied sheet (aka 'Sheet9') has DataRanges icon now greyed out; can't access (or via Right-clicks anywhere) http://www.srb542.talktalk.net/Data%20Table-DataRanges-GrayedOut.jpg This is what I see with the only available option, DataTable. No DataRange options or statement here! :)
If you go into edit mode in the new sheet (double-click the chart), is Data Ranges in the right-click context menu greyed out? I think you should attach your document here. Maybe there is something special. And/or try to create a simple one from scratch, just 1,2,3,4 -> chart and try it out.
:) http://www.srb542.talktalk.net/NoDataRanges.jpg No right-click DataRanges option at all, not even greyed out! But, if I make a new chart, same number of columns (3 in each case): http://www.srb542.talktalk.net/NewSpreadsheet.jpg The original spreadsheet with a No-DataRanges chart in Sheet9 www.srb542.talktalk.net/IBS%2bESMUsimplemodel.ods Note - this still has 3 columns (but all overlaid). This is really looking like a bug now, not an enhancement. All good fun!
Created attachment 132167 [details] Problematic spreadsheet I confirm there is some problem with this spreadsheet. The sheet to be copied is ESMU on Recharged IBS. I don't see the data ranges in the pasted version. I do see them in 3.6, so this is a regression. Arch Linux 64-bit, KDE Plasma 5 Version: 5.4.0.0.alpha0+ Build ID: 595e3971b130addbc6e5b749f53fc681fa6bc031 CPU threads: 8; OS: Linux 4.10; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on March 27th 2016 Arch Linux 64-bit Version 3.6.7.2 (Build ID: e183d5b)
I also confirm that in 3.6 the data range of the pasted chart was pointing to the new sheet.
I think this issue is inherited from OOo. In LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4 Format - Data Ranges in greyed out when selecting the chart in sheet9. Not happening with other charts though.
(In reply to Xisco Faulí from comment #9) > I think this issue is inherited from OOo. In > > LibreOffice 3.3.0 > OOO330m19 (Build:6) > tag libreoffice-3.3.0.4 > > Format - Data Ranges in greyed out when selecting the chart in sheet9. Not > happening with other charts though. Please try copying and pasting from the sheet ESMU on Recharged IBS. We can assume the chart in sheet9 is already messed up.
I take it you mean sheet ESMUfied... Same; new Sheet10 with a paste has no Data Range only Data Table option. :(
(In reply to brodders from comment #11) > I take it you mean sheet ESMUfied... > > Same; new Sheet10 with a paste has no Data Range only Data Table option. > > :( We are talking about regression testing and I meant the sheet "ESMU on Recharged IBS", which produces the error in the current versions for me, but not with version 3.6.
** 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
Dear brodders, 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
Hi guys, Have retested this issue on LO 6.4.3.2 (32bit, Win8.1) and can confirm it is no longer present. Thanks!
Excellent news, let's close