5. The alternative approach didn't run for me.

XTransferableSupplier seems not to be implemented for Draw docs, see https://bugs.documentfoundation.org/sho ... ?id=151713

to me it looks like a bug. Wanglong, can you create a minimum Java sample, which generates this error?
Do you work with 32bit or 64bit LO?

... just to be a bit more precise: Hidden documents do support the execution Basic scripts, but not dispatch calls

does viewtopic.php?t=79690 help?

@JPL, thanks for the wiki page. I should do more thorough search before posting ... In an LO forum post https://ask.libreoffice.org/t/java-uno-implementation-of-whole-seet-export-for-calc-pdf-export/94613 , mikekaganski gave also this reference for LO pdf export options: https://help.libreoffice.org...

The PDF export options are not very well documented and difficult to find in the source code. The below macro calls the PDF dialog from a calc document and writes the options you set into the first sheet. The available export parameters are also listed for information for AO and LO. Sub GetFilterdat...

Hi, bitmaps stored in OO document can be extracted by unzipping the document. Their path is an internally given name. To find out which image belongs to which item in the document the below code snippet lists all images with their name and the path in the zip Good luck, ms777 Sub ListStoredImages oD...

Hi, one of the key questions here is if you use your c# program to start AO/LO, or if AO/LO is already started, when you launch your c# program. The former is relatively easy, the latter is quite difficult

P.S. Can you share some of the c# code which works for you?

Hi, I am pretty sure that this is not easily achievable as neither https://www.openoffice.org/api/docs/common/ref/com/sun/star/view/PrintOptions.html nor https://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Printing_Spreadsheet_Documents#Printer_and_Print_Job_Settings nor the dialog ...

I don't understand what's the point : aSettings.setHierarchicalPropertyValue(sNodePath & "/Size", "384,53") ... that was just a hint how to set a configuration value. I was setting some window size parameter. But your way aSettings.getByname("WriterInsertImage").La...

Hi, below some code to change configuration settings as a starter. In my configuration there was no "WriterInsertImage" setting. Maybe you have to create that setting from scratch. Good luck, ms777 Sub Main sNodePath = "org.openoffice.Office.Common/Misc/FilePickerLastDirectory" D...

Hi, parsing pdf into a senseful document format is highly nontrivial. I have made very good experience with the Extract Text function of PDFBOX https://pdfbox.apache.org/ and iText7 https://itextpdf.com/products/itext-7 (license required for commercial application). The former is Java, so it should ...

P5 means that it will never be solved, I suppose. If you don't comment and vote for the issue, you suppose correctly. I added a comment. I did not find a voting button, though. I discovered some strange behavior: If you take the attached LibreOrApache.ods, select all cells, right click on the row h...

Hi,

thanks for the workaround. I am more interested to understand why the formula does not work on first call, and if this is an LO/AO bug or programmer stupidity

I have not coupled the macro to any event. It is just referenced by the user defined function call in A1

ms777

... thanks for the pointer to the AO bug. P5 means that it will never be solved, I suppose. In LO, things are a bit more complex: if I store the python in user, not document, and call by ' oScriptProvider = ThisComponent.getScriptProvider() oScriptProvider = CreateUNOService("com.sun.star.scrip...

Hi, I am trying to use python macros as cell functions with Basic wrappers. My python function, stored in the document (returns the working directory): import os def getWorkingDirectory(): return os.getcwd() g_exportedScripts = (getWorkingDirectory,) My Basic wrapper: function getWorkingDirectory() ...

Hi, So is there a way to programmatically control LibreOffice when both are installed? translated to: Can you specify to call either AO or LO from external programs? My 90% confindence answer: With python: yes Using Windows ActiveX Objects: no The code (I use powershell, C# is very similar) for the ...

... not sure if this is of any help, because it is on MariaDB and uses the sdbc:mysql:jdbc driver In MariaDB I create a stored procedure by delimiter ;; create or replace procedure foo(param1 int UNSIGNED, param2 CHAR(10)) contains sql begin select param1, param2; end;; delimiter ; This is the code ...

... try the below code. The first one requires the cursor being in the multi column section Good luck ms777 Sub Main oDoc = ThisComponent oSection = oDoc.currentSelection.getByIndex(0).TextSection oSection.DontBalanceTextColumns = not oSection.DontBalanceTextColumns msgbox oSection.DontBalanceTextCo...

Hi,

to add the axis descriptions you have to add a line Good luck,

ms777

Hi, the MediaDescriptor passed to the loadComponentFrom Url function allows to specify an XInterActionHandler https://www.openoffice.org/api/docs/common/ref/com/sun/star/document/MediaDescriptor.html#InteractionHandler . Unfortunately, this handler is not called for SAXExceptions. You probably can g...

... that was a tough one ... There were two issues with your code. (i) PixelWidth/PixelHeight is way too large for the GraphicExporter, and (ii) you have to do some forced type conversion when passing the FilterData. See the comments in the code Good luck, ms777 import uno import sys import time imp...

Please post the code you are using

... an update: The below code runs both on LO Win10 64 bit and on AO. If you start from outside LO, you have to modify the Popen line Now the Toolbar can be switched on and off through the Show Toolbars Menu. On LO, there are still some redraw issues Good luck, ms777 import uno import unohelper from...

... the above code is for AO only. LO uses a more up to date Python version. Python seems not to be fully compatible. The below code runs on LO 7.4.0.3 on Win 10 / x64. Some issues: When run from VS Code, an LO process remains alive, which you have to kill manually. Sometimes, you see some black are...

Hi all, the code below allows you do insert custom designed items into the toolbar. As an example, it inserts two selection boxes and one slider into the toolbar. This is a rework of some beanshell / basic code in the old forum. If you are interested in the old code, KamiKanda attached it to a post ...

... i found the solution myself in https://ask.libreoffice.org/t/pyuno-ill ... tion/54089:

Hi, I am trying to generate a ToolbarItem in calc. The Basic code (just copied the relevant lines) works without problem. The python code throws an "Type must be com::sun::star::uno::Sequence< com::sun::star::beans::PropertyValue >" exception. Can somebody help? Cheers ms777 The Basic code...

you have to callData is a 2-dimensional array