Bypass or skip popup message in LO macro

Creating a macro - Writing a Script - Using the API

Bypass or skip popup message in LO macro

Postby tiger » Thu Nov 10, 2016 3:03 pm

Hello Folks, I am creating macro and It will work through (linux service) atomized service , and Input file is downloaded from Google drive, when I run macro Its getting one popup "This file contains links to other files.Should they be updated?" If I click yes or no then macro will run successfully
How Can I skip this message and run macro without any poppup box, Do we can any changes in libreoffice to avoid this kind of messages
Note : File has VLOOKUP already in one column within file, If I remove that lookup then message will not comes up but unfortunately I can't do that because that column data is very crucial and I really don't know from where it's taking that data
So It would be good that any expert can help here to resolve this issue
please check attached file and snapshop of popup message
Than You in advance
Attachments
file.xlsx
Data File
(39.23 KiB) Downloaded 65 times
poppup.png
poppup message
poppup.png (4.73 KiB) Viewed 1278 times
LibreOffcie 5.1.3.2 on Window 10
tiger
 
Posts: 15
Joined: Thu May 21, 2015 1:02 pm

Re: How to bypass or skip any popup massage in libreoffice m

Postby Zizi64 » Thu Nov 10, 2016 4:11 pm

1.: Check the link in the Edit - Links menu item.
2.: Be sure, that you do not need the data linked from the another file.
3.: Check the cells what referenced to the another file, modify the formulas to local data.
3.: Delete the link/s/.
4.: Save your document into the native, International Standard ODF (.ods) fileformat.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8354
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: How to bypass or skip any popup massage in libreoffice m

Postby Villeroy » Thu Nov 10, 2016 5:04 pm

Edit>Links is disabled for foreign file formats.
An option under Tools>Options>Calc>General controls this behaviour (update links always|never|ask).
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27221
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How to bypass or skip any popup massage in libreoffice m

Postby EU-Import » Tue Aug 06, 2019 11:18 pm

The answers try to prevent the dialog box to appear, but that wasn't the question. The question is: how is it possible to skip or bypass this popup? Does anyone has the answer to that?

Thanks!
OpenOffice 4.1,6 on Windows 7 64bit
EU-Import
 
Posts: 1
Joined: Tue Aug 06, 2019 11:14 pm

Re: How to bypass or skip any popup massage in libreoffice m

Postby RusselB » Wed Aug 07, 2019 2:20 am

Once the pop-up/message is on your screen, I don't believe there's any way around it, since the file you are trying to open for viewing and/or editing won't know if the links that are in the file need to be updated or not unless you respond to the question.
OpenOffice 4.1.7 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5502
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Bypass or skip popup message in LO macro

Postby RoryOF » Wed Aug 07, 2019 10:47 am

Check ExternalDocLinks in the API; also a Forum search for that term might be helpful.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29578
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Bypass or skip popup message in LO macro

Postby JeJe » Wed Aug 07, 2019 3:43 pm

EU-Import - you might have to resort to an external application to simulate a press on one of the two buttons - as you're on Windows something like AutoIt perhaps.

You can use Windows Api calls to simulate a mouse click or key press from OOBasic - but the problem would be whether or not all macro code stops executing when the message box is shown. If so you wouldn't be able to do it - even if the code to make the mouse click or keypress was run on a timer.
Openoffice 4.1.2
Windows 8
JeJe
Volunteer
 
Posts: 584
Joined: Wed Mar 09, 2016 2:40 pm

Re: Bypass or skip popup message in LO macro

Postby Villeroy » Wed Aug 07, 2019 4:08 pm

May be this thread suffers from a misunderstanding. It is impossible to stop OpenOffice from asking questions about updating external links, regardless of what you set in Tools>Options>Calc>General>Update Links. Every time you open a spreadsheet document with certain types of links, you will be prompted.

The Calc component of https://libreoffice.org/ does not show this behaviour. LibreOffice does not show any prompt on loading when you set the option to "always" or "never".
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27221
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Macros and UNO API

Who is online

Users browsing this forum: MSN [Bot], oonk and 8 guests