[Libreoffice-bugs] [Bug 141337] New: Python doc.Sheets.copyByName(existingname, newname, position) does not update references in chart when copying sheets

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=141337

            Bug ID: 141337
           Summary: Python doc.Sheets.copyByName(existingname, newname,
                    position) does not update references in chart when
                    copying sheets
           Product: LibreOffice
           Version: 7.0.5.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: sdk
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: nib70776 at sjuaq.com

Created attachment 170821
  --> https://bugs.documentfoundation.org/attachment.cgi?id=170821&action=edit
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210330/b1a375d1/attachment.htm>