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: [email protected]
          Reporter: [email protected]

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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to