When a single sheet is copied, chart refers to the copied sheet. This is fine, and working as expected. However, when multiple sheets are copied at once, copied Chart refers to its original sheet. And this is "Sheet copy" and not "Chart copy" just to clarify. Reproduced with LO 3.3.0 - 3.5.4 on Win 7 and XP. Steps to reproduce: 1. Start a new Calc file 2. Create a chart on a sheet(Call it "Sheet1") 3. Copy Sheet1(Call it "Sheet1_2") and notice its chart refers to Sheet1_2 4. Select both Sheet1 and Sheet1_2 to copy 2 sheets simultaneously (Call these "Sheet1_3" and "Sheet1_2_2") 5. Notice Sheet1_3 and Sheet1_2_2 still still refers to Sheet1 and Sheet1_2 Excpected: No difference in behaviour when coping single sheet or multiple sheets. All charts should refer to its sheet upon sheetcopy. For those who do not know how to check the data range for charts, Double click on a chart -> right click on the chart -> select "Data range" Also, I mean "Sheetcopy" as in "Selecting sheet(s) at the sheet tab and drag & drop while pressing down Ctrl key."
Having trouble reproducing this. Please supply a sample document that demonstrates the problem.
Created attachment 66754 [details] Bugdoc created on 3.6.1
Open the attached bugdoc and follow the steps below. Case A) 1:Hold down Ctrl key, place cursor over the sheet name "Sheet1" at the sheet tab and hold down left mouse button. Drag the sheet tab to the right and release the mouse button to make a copy of Sheet1. The copied sheet would be named "Sheet1_2" The chart on Sheet1_2 refers to Sheet1_2 as it should. 2:Select Sheet1_2. Hold down Ctrl key, place cursor over the sheet name "Sheet1" at the sheet tab(*) and hold down left mouse button. Drag the sheet tabs to the right side of Sheet1_2 and release the mouse button. The copied sheets would be named "Sheet1_3" and "Sheet1_2_2" (*) Keep holding the Ctrl key and do not lift it at this point. The chart on Sheet1_3 refers to Sheet1 and the chart on Sheet1_2_2 refers to Sheet1_2. Case B) 1:Hold down Ctrl key, place cursor over the sheet name "Sheet1" at the sheet tab and hold down left mouse button. Drag the sheet tab to the right and release the mouse button to make a copy of Sheet1. The copied sheet would be named "Sheet1_2" The chart on Sheet1_2 refers to Sheet1_2 as it should. 2:Select Sheet1. Hold down Ctrl key, place cursor over the sheet name "Sheet1_2" at the sheet tab(*) and hold down left mouse button. Drag the sheet tabs to the right side of Sheet1_2 and release the mouse button. The copied sheets would be named "Sheet1_3" and "Sheet1_2_2" (*) Keep holding the Ctrl key and do not lift it at this point. The chart on Sheet1_3 refers to Sheet1_3 as it should but the chart on Sheet1_2_2 refers to Sheet1_2.
Created attachment 66756 [details] The ending result of Case A)
Created attachment 66757 [details] The ending result of Case B)
Further information has been provided as requested. Removed NEEDINFO status and set back to UNCONFIRMED.
Confirmed with: LO 4.0.0.1 Build ID: own W7 debug build Windows 7 Professional SP1 64 bit All cases confirmed.
*** This bug has been marked as a duplicate of bug 43175 ***