Apache OpenOffice (AOO) Bugzilla – Issue 120182
When multiple sheets are copied simultaneously, copied Chart refers to its original sheet
Last modified: 2012-10-18 01:27:45 UTC
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 OOo 3.3.0 and AOO 3.4.0 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."
This is probably related to bug 29848 where its status is "Resolved fixed." But I suppose it was only partially fixed for single sheetcopy and not for multiple sheetcopy.
confirmed,can reproduce the defect in AOO_r1359641 steps: 1. Start a new Calc file and select some cells to input some data on "Sheet1" 2. Create a chart bases on these data on same sheet(Call it "Sheet1") 3. Copy Sheet1(Call it "Sheet1_2") and notice its chart data 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's data and Sheet1_2'data Excpected: No difference in behaviour when coping single sheet or multiple sheets. All charts should refer to the data in its sheet upon sheet copy.
Confirmed bug reproducible in AOO 3.4.1 (Build 9593) on Windows 7.
Just to make sure I understand your meaning(I marked the lines): Problem: chart in Sheet1 uses a data range from Sheet1 chart in Sheet1_2 uses a data range from Sheet1_2 *chart in Sheet1_3 uses a data range from Sheet1 chart in Sheet1_2_2 uses a data range from Sheet1_2_2 Expected: chart in Sheet1 uses a data range from Sheet1 chart in Sheet1_2 uses a data range from Sheet1_2 *chart in Sheet1_3 uses a data range from Sheet1_3 chart in Sheet1_2_2 uses a data range from Sheet1_2_2 I'm experiencing Problems result. Am I correct that Problem's result is the problem and Expected is what's expected? Sorry for my strange wording and whatnot.
Thank you for taking your time. That is correct. You clearly described the problem and what is expected. But to be more precise, the result is also inconsistent and may vary depending on the order or the position of sheets selected. Create a file with just 1 sheet. Hold down Ctrl key, drag and drop Sheet1 to the right to create a copy. Now you would have 2 sheets shown at the sheet tab. (Sheet1 is to the left, and Sheet1_2 to the right) Case (A) Select Sheet1 first, then Sheet1_2. Drag and drop to the right side of Sheet1_2 to create a copy each simultaneously. Sheet1_3 refers to Sheet1_3 as expected. Sheet1_2_2 refers to Sheet1_2 when it should refer to Sheet1_2_2. Case (B) Select Sheet1_2 first, then Sheet1. Drag and drop to the right side of Sheet1_2 to create a copy each simultaneously. Sheet1_3 refers to Sheet1 when it should refer to Sheet1_3. Sheet1_2_2 refers to Sheet1_2 when it should refer to Sheet1_2_2. Your result would probably fit into "Case (A)" but I assume that you had Sheet1 to the right, and Sheet1_2 to the left of the sheet tab instead. Hence your result being reversed to that of mine. Regards,