https://bugs.documentfoundation.org/show_bug.cgi?id=146689
Bug ID: 146689
Summary: calc formula to value (linkvalue, sheetlinkmode)
changed by macro copies first sheet
Product: LibreOffice
Version: 6.4.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 177445
--> https://bugs.documentfoundation.org/attachment.cgi?id=177445&action=edit
spreadsheet - two sheets - embedden python
I want to convert formulas to values in all spreadsheets of a document.
To this end wrote a macro (embedded) to do so. Summary
from com.sun.star.sheet.SheetLinkMode import VALUE as LINKVALUE
for j in range(oSheets.Count):
oSheet = oSheets.getByIndex(j)
oSheet.LinkMode = LINKVALUE
1. reproduce result by running embedded macro.
2. expected result is a document with no formulas present in each sheet
3. produced are sheets with no formulas on it and >>>>
sheet2 is now a copy of sheet1
used: linuxMint 20.2 with distributed LibO
--
You are receiving this mail because:
You are the assignee for the bug.
