Does anybody knows how to reload the active file from the last time it was saved, using macro, in libreoffice Calc? It would be something like clicking on File -> Refresh, but this time without the confirmation window. Thanks in advance.
Reloading is easy. The trick is to ignore changes, and a simple solution is given at http://ooo-forums.apache.org/en/forum....
Sub SilentlyReload
ThisComponent.setModified(False) 'Ignore changes'
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
dispatcher.executeDispatch(document, ".uno:Reload", "", 0, Array())
End Sub
See also http://openoffice.2283327.n4.nabble.c....
Hello how i can add this Macro to my "LibreOffice 5 - Calc" and run it every 10min?
Answers should be answers, not questions. See guidelines for asking.
Asked: 2018-03-01 04:56:22 +0200
Seen: 527 times
Last updated: Mar 04
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
