LibreOffice V7 Documentation Databases

PRJones · April 12, 2021, 11:27am

I’m working through the excellent LibreOffice Base Documentation PDF (Which is based on v6.4), and I have opened up the database ‘Media_with_macros.odb’ in LibreOffice v7.1 (having enabled macros), and get the attached error when I try and open any of the forms:

$C:\fakepath\error.PNG$

Is there something else I need to enable?

Will the documentation be updated for V7 (The other documentation seems to have been updated) - I do fully appreciate the huge amount of work that goes into this type of thing. Do have roles for people who want to offer to proof read draft documentation? I would be happy to help.

Thanks

(inline picture display fixed by ajlittoz)

(Edited by PRJones 12/04/2121 - 17:00 BST to explain that error shows when opening Reader Amissions)

anon73440385 · April 12, 2021, 11:49am

You get that error when doing what (I can open without any problems)?

PRJones · April 12, 2021, 11:54am

I just downloaded the zip of examples, unzipped it and opened it in a fresh installation of LibreOffice 7.1 (Windows 10). All I have done is change the security level to medium. The error pops up when I open the database, then try and open any of the forms.

anon73440385 · April 12, 2021, 11:58am

… all forms open on my system which is a openSUSE Leap 15.2 GNU/Linux system and using LibreOffice

Version: 7.1.2.2 / LibreOffice Community
Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5
Locale: en-US (en_US.UTF-8); UI: en-US, Calc: threaded

PRJones · April 12, 2021, 1:21pm

Thanks, could anyone using the Windows build test please? Cheers. I’m using the 64Bit Build of LibreOffice 7.1.2.2 with JRE version “1.8.0_281”

I have also in the main LO Launcher been to Tools - Options - Advanced and checked that ‘Use JRE’ in ticked and the above version is showing.

anon73440385 · April 12, 2021, 2:21pm

No problem using

Version: 7.1.2.2 (x64) / LibreOffice Community
Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4
CPU threads: 1; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: en-US (en_DE); UI: en-US, Calc: threaded

(using AdoptOpenJDK’s JRE 11.0.9.101 - hotspot)

PRJones · April 12, 2021, 2:34pm

Thanks @anon73440385, but it really needs someone running Sun JRE rather than the Opensource alterative. I appreciate you testing though.

anon73440385 · April 12, 2021, 3:03pm

Sun JRE

There is no such thing (SUN Microsystems has been acquired by Oracle in 2010) and the license from Oracle has changed to prohibit commercial use for free, so I won’t install that.

And btw.: To figure out, whether your installed JRE version is causing the issue, you could install another JRE as well.

PRJones · April 12, 2021, 3:25pm

Thanks, sorry meant Oracle - Was trying to make the point about to test it needs to be the same software installed. Will wait if someone else comes back with Oracle JRE otherwise may spin up a temporary W10 VM on VMWare and test with openjdk - Don’t want to install alongside JRE. I tend to be a pragmatist when it comes to software. Opensource is preferred, but won’t let it be the over-riding factor. I use MS Office for my business activities because I need 100% compatibility with MSOffice, but at home (where these things are not important) I use a mix of proprietary and opensource, so giving Base a go. Best wishes

Ratslinger · April 12, 2021, 3:43pm

Hello,

Have confirmed problem in the sample noted. It is not, however, whenever opening any form. Have gotten the error on the Reader_Admission form when scrolling through the records. This error occurs in both the Win10 and Ubuntu 20 versions. Haven’t looked into the cause. Could be other problems but did not spend a lot of time with it.

I do not believe these samples are tested very often. Have also found errors in the Base documentation. The documentation and samples, like myself, are not by any means perfect.

PRJones · April 12, 2021, 3:51pm

Thanks @ratslinger. My findings are slightly different to yours. It is as soon as I open Reader_Amissions. Its been sometime since I last tried LibreOffice and remember feeling that Base was the module that got the least love (no evidence for that, just a feeling). Is it worth me filing a bug report? I appreciate you confirming the issue. @anon73440385 - Apologies I should have confirmed which forms.

Also, on the Media form if you click on ‘Publisher’ you get ‘A scripting error has occurred’

To be honest, if the foundation are trying to encourage people to move away from Office its not a great advert as many beginners would jump ship at the first error.

<img src=“https://i.ibb.co/wJ8q60h/Publisher.png”

Ratslinger · April 12, 2021, 4:12pm

@PRJones,

Yes got same error on Publisher. You can file a bug report if wanted.

As for attention in Base, there are not people enough to work on it. Also errors are introduced because of changes in other areas and then they don’t get fixed for, in some cases, years.

As for jumping ship on the first error, if that were the case there would be no users of Base. It has a long list of errors.

BTW, I also use Open JDK in both Windows and Ubuntu.

PRJones · April 12, 2021, 4:29pm

Thanks @Ratslinger. Unfortunately there is no way of knowing the number of people who jump ship when encountering errors like this.

Sadly, I will have to bite the bullet and purchase a copy of Access for home. I thought I would give LibreOffice another go.