LibreOffice UDF Help and Support

[mLipok]

  On 9/27/2023 at 7:55 AM, 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, ...)

 

Expand  

good point

firstly some cleanup 

 

[donnyh13]

  On 9/27/2023 at 9:33 AM, mLipok said:

firstly some cleanup 

Expand  

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

[mLipok]

  On 9/27/2023 at 7:55 AM, 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

 

Expand  

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 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]

  On 5/15/2025 at 12:51 PM, 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(), _

Expand  

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