Page 1 of 1
[Issue] Calc : disable "update links" when insert sheet
Posted: Fri Jul 20, 2018 9:54 am
by Mr.Dandy
Code: Select all
Sub Main
oDest = thiscomponent.Sheets(2)
ImportSheet("/home/LocalSync/foo.ods", "Sheet1", oDest)
End Sub
Sub ImportSheet(sDoc, sSheet, oSheet)
sURL = convertToURL(sDoc)
oSheet.link(sURL, sSheet, "", "", com.sun.star.sheet.SheetLinkMode.NORMAL)
oSheet.LinkMode = com.sun.star.sheet.SheetLinkMode.NONE
oSheet.LinkURL = ""
End sub
Since 4.1.4, insert sheet from another file displays a warning with an "Update links" prompt.
Is it possible to avoid it?
Re: Calc : disable "update links" when insert sheet
Posted: Mon Jul 23, 2018 11:01 am
by Bidouille
Reported in
https://bz.apache.org/ooo/show_bug.cgi?id=127582
Use com.sun.star.sheet.SheetLinkMode.VALUE is single way to have directly datas without warning.
Re: [Issue] Calc : disable "update links" when insert sheet
Posted: Mon Jul 30, 2018 4:14 pm
by Mr.Dandy
Thanks, fixed with you solution.