Bug 141337 - Python doc.Sheets.copyByName(existingname, newname, position) does not update references in chart when copying sheets
Summary: Python doc.Sheets.copyByName(existingname, newname, position) does not update...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: sdk (show other bugs)
Version:
(earliest affected)
7.0.5.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro-Python
  Show dependency treegraph
 
Reported: 2021-03-30 09:26 UTC by nib70776
Modified: 2021-08-27 04:06 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
calc document with sample charts (33.77 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-03-30 09:26 UTC, nib70776
Details

Note You need to log in before you can comment on or make changes to this bug.
Description nib70776 2021-03-30 09:26:58 UTC
Created attachment 170821 [details]
calc document with sample charts

Libreoffice calc:
Python doc.Sheets.copyByName(existingname, newname, position) does not update references in chart when copying sheets.

def copysheet(*args):
    # chart refernces not updated
    doc = XSCRIPTCONTEXT.getDocument()
    sheetstocopy = doc.Sheets['Sheet1']
    for case in range (5,0,-1):
        nameBGx = 'd1-' + str(case)
        if nameBGx in doc.Sheets:
            doc.Sheets.removeByName(nameBGx)
    for case in range (5,0,-1):
        nameBGx = 'd1-' + str(case)
        nosheets = doc.Sheets.Count
        doc.Sheets.copyByName(sheetstocopy.Name, nameBGx, nosheets)
    return None

Reference of all chart data remains at Sheet1.
Comment 1 Eleonora Govallo 2021-08-26 16:09:35 UTC
Hello!
No repro in Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: 008f28c9e01114e731f785e9e238236a1ed069d2
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: ru-RU (ru_RU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-08-22_15:17:36
Calc: threaded

In provided document i copied first sheet and checked the data in the chart and the data was from copied sheet not from the first sheet.
Please update to the latest version ant try to reproduce the bug.
Also please add your version information (Help - About Libre office).