LibreOffice UDF Help and Support

[mLipok]

1 hour ago, water said:

If I would start such a project I would

• run a poll to see how many users have the need to automate OO/LO
• Ask people about their priority. Means: Which modules do they need most (Writer, Calc, ...)

 

good point

firstly some cleanup 

 

[donnyh13]

3 hours ago, mLipok said:

firstly some cleanup 

Looking good @mLipok, thank you for your work so far!

[mLipok]

6 hours ago, water said:

I would split this project into multiple files:

• a general file with those functions needed by all modules like copy/paste, formatting, saving/exporting ...
• a file for each module

 

Done. Please take a look :

https://github.com/mlipok/Au3LibreOffice

 

[mLipok]

To all concerned.
Take a look at the new version:

https://github.com/mlipok/Au3LibreOffice/releases/tag/v0.9.0

and
https://github.com/mlipok/Au3LibreOffice/releases/tag/0.9.1
 

We are waiting for your feedback.

Edited October 28, 2023 by mLipok
0.9.0 >> 0.9.1

[mLipok]

@donnyh13
please re-edit topic title

Current:
LibreOffice Writer UDF Version 0.0.0.3

Proposal:
LibreOffice UDF help and support topic

or something like that.

 

EDIT:
Also please consider to add link to GitHub repro
https://github.com/mlipok/Au3LibreOffice

in the opening post.

Edited October 28, 2023 by mLipok

[donnyh13]

Thanks @mLipok, changes look good!

 

[donnyh13]

Hi argumentum,

mLipok and I are looking into making this UDF compatible with the portable version of LibreOffice also, and I was wondering if you have any insight on what it would take/ how to go about accomplishing this? A bit of research would seem to indicate the need to use Registration Free COM Objects? But I’m not exactly sure on the "how" yet?

Any insight or tips would certainly be appreciated if you have any.

Edited March 13, 2025 by donnyh13

[mLipok]

Did you notice that :  _LOWriter_DocSaveAs() and _LOWriter_DocOpen()   can not open/save file to location different than @TempDir ?

[donnyh13]

No, I didn't. I'll look into that. Thank you!

What exactly does it do? return an error? Or just nothing?

Edited January 5, 2024 by donnyh13

[donnyh13]

I just tested Both on my desktop, and both worked.... Do you have an example I could look at?

Perhaps it's a permission issue?

Edited January 5, 2024 by donnyh13

[Belini]

I love Libre-Oficce and this UDF will certainly be very useful!

Edited January 5, 2024 by Belini

[donnyh13]

Thanks, Hope it comes in handy for you! Please let me know if you find any issues.

[JALucena]

Hi everybody

since two weeks ago i have been working with this UDF in several proyects and I think its great! In the past i worked with this UDF:

https://www.autoitscript.com/forum/topic/151530-ooolibo-calc-udf/

which is fantastic too.

I think i have found a bug in the function _LOCalc_DocViewWindowSettings from the library LibreOfficeCalc_Doc.au3. In the line 2161 there is a call to the function __LOCalc_ArrayFill and the fourth and fifth parameters are switched.

where it says

__LOCalc_ArrayFill($abView, $oCurCont.HasColumnRowHeaders(), $oCurCont.HasVerticalScrollBar(), $oCurCont.HasSheetTabs(), $oCurCont.HasHorizontalScrollBar(), _

it must be

__LOCalc_ArrayFill($abView, $oCurCont.HasColumnRowHeaders(), $oCurCont.HasVerticalScrollBar(), $oCurCont.HasHorizontalScrollBar(), $oCurCont.HasSheetTabs(), _

After modified it works fine.

Thank you for your job.

[donnyh13]

2 hours ago, JALucena said:

where it says

__LOCalc_ArrayFill($abView, $oCurCont.HasColumnRowHeaders(), $oCurCont.HasVerticalScrollBar(), $oCurCont.HasSheetTabs(), $oCurCont.HasHorizontalScrollBar(), _

it must be

__LOCalc_ArrayFill($abView, $oCurCont.HasColumnRowHeaders(), $oCurCont.HasVerticalScrollBar(), $oCurCont.HasHorizontalScrollBar(), $oCurCont.HasSheetTabs(), _

Thank you for the report, and for tracking down the bug @JALucena, it's greatly appreciated. I'll change that right away. I must have messed it up in modifying the order of the parameters previously.

Glad to hear you like the UDF, and that it is working well for you. It's nice to know it is a help to somebody, plus we appreciate the bug testing.

Best regards,

Donny

[mLipok]

I did a LibreOffice converter to PDF with such function:

Func _LibreOffice_Writer__ConverFileTo_PDF($s_PDF_FileFullPath, $s_Destination)
    If Not _File_Exist($s_Destination) Then
        Local $oDoc = _LOWriter_DocOpen($s_PDF_FileFullPath, False, True, True)
        If @error Then Return SetError(@error, @extended, $oDoc)


        Local $sPath_PDF = _LOWriter_DocExport($oDoc, $s_PDF_FileFullPath & '.pdf', False)
        If @error Then Return SetError(@error, @extended, $sPath_PDF)

        ; Close the document.
        _LOWriter_DocClose($oDoc, False)
        If @error Then Return SetError(@error, @extended, $oDoc)

        FileMove($sPath_PDF, $s_Destination, $FC_NOOVERWRITE)
    EndIf

    Return SetError(@error, @extended, '')
EndFunc   ;==>_LibreOffice_Writer__ConverFileTo_PDF

You can notice that I used silent mode:

Local $oDoc = _LOWriter_DocOpen($s_PDF_FileFullPath, False, True, True)

and I hit a problem.

When I used it on the workstation where is instaled older LibreOffice version, then some LibreOffice updater shows up.
How to prevent auto updating LibreOffice ?

 

EDIT:
as so far I found
https://ask.libreoffice.org/t/how-do-i-make-automatic-update-permanent/48799
https://ask.libreoffice.org/t/disable-enable-automatic-update/119668

but how to prevent it when I call LibreOffice API ?

 

Edited January 14 by mLipok

[donnyh13]

Sorry for the delay in responding, I just seen this now.  Thanks for the report.

Hmm., I can try to look into that. There should be a way you would think....

Another link to look at.

https://ask.libreoffice.org/t/issue-with-disabling-libreoffice-automatic-background-update-check-in-headless-mode-bundled-portable-installation/130020

And also this (Not ideal, but may work?): https://wiki.documentfoundation.org/Deployment_and_Migration#Post_deployment_configuration

 

Editing in the user profile the following file:

Quote

registrymodifications.xcu

found at:

Quote

C:\Users\Owner\AppData\Roaming\LibreOffice\4\user

And editing the xml line

Quote

<item oor:path="/org.openoffice.Office.Jobs/Jobs/org.openoffice.Office.Jobs:Job['UpdateCheck']/Arguments"><prop oor:name="AutoCheckEnabled" oor:op="fuse" oor:type="xs:boolean"><value>false</value></prop></item>

To false is one mentioned option? Whether it would work though, I'm not sure.

Apparently only recently they made Auto-Update not activate using --headless mode, which should also help when using API?

https://bugs.documentfoundation.org/show_bug.cgi?id=167676

Edited Friday at 01:48 PM by donnyh13

[donnyh13]

@mLipok,

Another option would be to use command line for your pdf exporting instead, though I'm not completely sure it will bypass the updater:

https://help.libreoffice.org/latest/en-US/text/shared/guide/convertfilters.html?DbPAR=SHARED#bm_000writer

https://help.libreoffice.org/latest/en-US/text/shared/guide/start_parameters.html?&DbPAR=SHARED&System=WIN