Apache OpenOffice (AOO) Bugzilla – Issue 92580
Copy sheet operation is suboptimal
Last modified: 2009-09-01 03:52:34 UTC
Hi 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. HÃ¥vard
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?
Hi! 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.
Is this issue a duplicate ? Look at Issue 29848.
Indeed it is. Looks like nobody is working on this yet. How do we mark it as a duplicate?
Duplicate, please transfer your votes. *** This issue has been marked as a duplicate of 29848 ***
Closing dup.