Page 1 of 1
Bypass or skip popup message in LO macro
Posted: Thu Nov 10, 2016 3:03 pm
by tiger
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
Re: How to bypass or skip any popup massage in libreoffice m
Posted: Thu Nov 10, 2016 4:11 pm
by Zizi64
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.
Re: How to bypass or skip any popup massage in libreoffice m
Posted: Thu Nov 10, 2016 5:04 pm
by Villeroy
Edit>Links is disabled for foreign file formats.
An option under Tools>Options>Calc>General controls this behaviour (update links always|never|ask).
Re: How to bypass or skip any popup massage in libreoffice m
Posted: Tue Aug 06, 2019 11:18 pm
by EU-Import
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!
Re: How to bypass or skip any popup massage in libreoffice m
Posted: Wed Aug 07, 2019 2:20 am
by RusselB
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.
Re: Bypass or skip popup message in LO macro
Posted: Wed Aug 07, 2019 10:47 am
by RoryOF
Check ExternalDocLinks in the API; also a Forum search for that term might be helpful.
Re: Bypass or skip popup message in LO macro
Posted: Wed Aug 07, 2019 3:43 pm
by JeJe
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.
Re: Bypass or skip popup message in LO macro
Posted: Wed Aug 07, 2019 4:08 pm
by Villeroy
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".