Issue 92580 - Copy sheet operation is suboptimal
Summary: Copy sheet operation is suboptimal
Status: CLOSED DUPLICATE of issue 29848
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.4.0
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2008-08-08 08:01 UTC by korsi
Modified: 2009-09-01 03:52 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description korsi 2008-08-08 08:01:05 UTC

When copying a sheet in Calc that includes a chart based on a table on that
sheet, the references to the data in the chart will point back to the original
sheet in stead of the new sheet created.

I would find it natural that the data references are to the copied sheet.

How to recreate:
1. Create a table with some data inside.
2. Create a chart based on the data in that table.
3. Right click on the sheet tab in the bottom left corner and choose Move/Copy
Sheet ...
4. Choose the existing document to copy to.
5. Insert before: - move to end position -
6. Select copy and press OK.

7. In the newly copied sheet, select the chart and go to Format - Data Ranges.
There you will see that the data ranges reference to the original sheet.

Comment 1 ooo 2008-10-08 10:16:03 UTC
This happens if the cell range references of the chart data contain absolute
sheet addressing, starting with a '$' dollar character such as in $Sheet1. If
the '$' was omitted, relative addressing could be used. However, omitting the
'$' seems not to be possible, when attempting this under "Modify Data Range" it
appears to be automatically reinserted.

@iha: by design or by error?
Comment 2 zinenko 2008-10-27 16:56:11 UTC
I have to create a workbook with lots of sheets that show the same charts for
different data (different scenarios). Because of this bug it takes me 30 minutes
to create a sheet with a new scenario, because I have to go manually through all
the charts.
Like <er> has already mentioned, it will not let me use relative sheet names in
the charts.
Comment 3 kamataki 2009-08-29 09:24:19 UTC
Is this issue a duplicate ? Look at Issue 29848.
Comment 4 zinenko 2009-08-30 16:12:22 UTC
Indeed it is. Looks like nobody is working on this yet. How do we mark it as a
Comment 5 ooo 2009-08-31 10:53:55 UTC
Duplicate, please transfer your votes.

*** This issue has been marked as a duplicate of 29848 ***
Comment 6 ooo 2009-08-31 10:54:34 UTC
Closing dup.