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