Bug 51702

Summary:	When multiple sheets are copied simultaneously, copied Chart refers to its original sheet
Product:	LibreOffice	Reporter:	HD <kg_ooohelp>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	bfo.bugmail
Priority:	medium
Version:	3.3.0 release
Hardware:	Other
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Bugdoc created on 3.6.1 The ending result of Case A) The ending result of Case B)

Description HD 2012-07-03 19:21:26 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 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."

Comment 1 Noel Grandin 2012-09-06 14:36:15 UTC

Having trouble reproducing this. Please supply a sample document that demonstrates the problem.

Comment 2 HD 2012-09-07 01:29:10 UTC

Created attachment 66754 [details]
Bugdoc created on 3.6.1

Comment 3 HD 2012-09-07 02:03:29 UTC

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.

Comment 4 HD 2012-09-07 02:34:09 UTC

Created attachment 66756 [details]
The ending result of Case A)

Comment 5 HD 2012-09-07 02:34:44 UTC

Created attachment 66757 [details]
The ending result of Case B)

Comment 6 HD 2012-09-24 05:34:39 UTC

Further information has been provided as requested.
Removed NEEDINFO status and set back to UNCONFIRMED.

Comment 7 bfoman (inactive) 2013-01-21 13:19:41 UTC

Confirmed with:
LO 4.0.0.1
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit

All cases confirmed.

Comment 8 Stephan van den Akker 2013-11-14 20:01:17 UTC


*** This bug has been marked as a duplicate of bug 43175 ***