0

I use the LibreOffice API to convert an Excel file to a PDF. It works well but what is rather bothering me is that when I load the Excel file, I get a pop up dialog that asked for refreshing the file because of links to an external file.

How can I turn off this dialog popping up. I would prefer if I can set this configuration in Java and not in LibreOffice itself.

yemerra
  • 1,352
  • 4
  • 19
  • 44

1 Answers1

2

To skip the prompt, set the option Tools -> Options -> LibreOffice Calc -> General -> Updating / Update links when opening to either "Always" or "Never". It would be easiest to set this option manually.

To set options programmatically, see the code in section 10.7.3 of Andrew Pitonyak's macro document. Andrew notes that the Options dialog is very complicated.

Jim K
  • 12,824
  • 2
  • 22
  • 51