in 6.3 version every time is called the same macro script the same warning dialog appears asking permission to execute it.
It's very annoying to confirm it every time is activated for example a form control linked to the same basic macro in the same file.
I have found the same problem with 6.3.0-1 6.3.1-1 and 6.3.2-1 x86_64 arch linux packages opening the same base file (actually a managing software in basic), still working good with 6.2.5-1 version.
I beg you to fix, thanks a lot.
Thank you for reporting the bug.
To be certain the reported issue is not
related to corruption in the user profile, could you please reset your
Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and
If the problem still exists, please attach a sample document, as this makes it easier for us to verify the bug.
(Please note that the attachment will be public, remove any sensitive information before attaching it.
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the issue is still present
Created attachment 155119 [details]
File with one form "Autores" that call to another form "Biblioteca"
I have the same problem. When trying to open a form from a button with a macro from another form there is a warning message on the existing macro. This started to appear when I moved to LO 184.108.40.206 and it exists too in 220.127.116.11. My previous version 6.0 work fine and the security level was set to high. Now I have to set it to medium and to click on allow macros in order to use the database. I have reset the user profile with no changes in the behavior. It is quite annoying having to click on tis warning message every time I open a form.
I attach a file so that you can see the problem.
Thanks and best regards
- open Biblioteca.odb - the *.odb file itself does not contain macros.
- select Forms -> Autores
- select button [Biblioteca]
but get an error:
A Scripting Framework error occurred while running the Basic script vnd.sun.star.script:Standard.Module1.openFormByTag?language=Basic&location=application.
Message: The following Basic script could not be found:
to make it work, you need also a macro in My Macros/Standard/Module1, e.g.:
REM ***** BASIC *****
MsgBox "Hello World"
now i can confirm, with:
Version: 18.104.22.168 (x64)
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win;
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
and Security Level:
- Very High/High
warning: "This document contains macros. Macros may contain viruses.
Execution of macros is disabled due to the current macro security setting"
-> but macro will be excuted, cause it is located in trusted zone "My Macros"
warning, with an option to activate macros
-> macro will be executed, does not matter if one disables macros in dialog,
cause it is located in trusted zone "My Macros"
-> macro will be executed
*not* reproducible (no warnings) with:
Version: 22.214.171.124 (x64)
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard;
Gebietsschema: de-DE (de_DE); Calc:
btw: another problem with base and Macro Security Level:
Bug 97694 - Base macros cannot be digitally signed
I wonder if there is a way to declare My Macros as a trusted zone or it comes declared by default.
I declared the directories where I save the databases as trusted origin but it does not seem to work; the warning message on macros and viruses keeps showing. In the other hand, I cannot set up My Macros there (I do not know the route)
(In reply to Pedro from comment #5)
> I wonder if there is a way to declare My Macros as a trusted zone or it
> comes declared by default.
"My Macros" is in trusted zone by default, as mentioned above, with security level "Medium", it does not matter if you disable macros, your macro from "My Macros" will be executed.
> I declared the directories where I save the databases as trusted origin but
> it does not seem to work; the warning message on macros and viruses keeps
This works for me:
Add a Macro Module to the *.odb file and set security level to "Medium" or "Very high" and add the directory where the *.odb file is stored to trusted zone.
I assume that there is no need to declare the database files to the trusted zone since the macros are already in the trusted zone by default.
Created attachment 157652 [details]
odb file asking for macro permission every time a form is asked to be opened
I have tried creating a new profile, re-created macro libraries and then erased my macros. I have changed my db source from mysql jdbc connection to a fake spreadsheet file (see attachments "soffice.ods").
The confirmation is asked every time I try to open a new form window although the security macro level is set to "medium".
The problem is independent from DB connection or specific macros, as from personal profile.
I suspect the problem is inside the odb file (attached).
Could you verify as well?
Thanks a lot
Created attachment 157653 [details]
fake source ods file