[Solved] Error in LibreOffice Base Access2Base Module 'Apn'

[Frie]

Today I've upgraded LibreOffice to 5.3.1.2 but now I have Macro's that produce an error.

I have done some programming in Base with Access2Base but now the database connection gives an error in Sub DBOpen as it does not recognize 'ThisDataBaseDocument' any more.

When I try to execute the Access2Base module 'Application' in the editor screen it gives the following error:

BASIC syntax error. Expected: )

and it stops in Function HtmlEncode, where indeed the ")" is missing in line:

sOutput = sOutput & Utils._UTF8Encode(Mid(pvString, l, 1).

Who can help me?

[Villeroy]

The error is obvious, isn't it?
The latest version of LibreOffice seems to have a problem with trailing braces when they are missing. All other versions had no problem with this syntax error.

[Frie]

Thank you, but who is going to solve this? Who should I contact?

[Villeroy]

Thank you, but who is going to solve this? Who should I contact?

The problem is known already: https://bugs.documentfoundation.org/sho ... ?id=106529

[Villeroy]

I attached to bug report https://bugs.documentfoundation.org/sho ... ?id=106529 a zip archive to fix all Basic modules shipped with LO 5.3.1.2.
https://bugs.documentfoundation.org/att ... ?id=132144
Shut down LO completely and run:

Code: Select all

sudo unzip -o ~/Downloads/fixed_basic_modules.zip  -d /opt/libreoffice5.3/share/basic/

where ~/Downloads/fixed_basic_modules.zip is the zip file in the current user's Downloads folder and /opt/libreoffice5.3/share/basic/ is the basic folder in my installation path of LO 5.3.1.2.