search

x2rider / OMISS-Awards

Excel and LibreOffice template to calculate OMISS award standings based on imported contact logs
GNU General Public License v3.0
4 stars 1 forks source link

Libreoffice 7.x broken #15

Closed magpiper closed 1 year ago

magpiper commented 1 year ago

Macros fail to work worked fine under 6.x version. Apologize for the lack of technical details.

x2rider commented 1 year ago

I've never used 6.x, all development has been done using 7.x. I would check your security settings to make sure the scripts are enabled.

x2rider commented 1 year ago

Check the security section of the video here: https://www.youtube.com/watch?v=EBXyA3ZQAcg&t=1051s

magpiper commented 1 year ago

Tools, options, security - Adjust Macro Security to MEDIUM

image

x2rider commented 1 year ago

Ok, that should be fine. In windows explorer right click on the file, select Properties. Does it show this? If so, check the box where it says Unblock and click OK. image

also... When you open the file, does it ask you to Enable Macros, image

and does it show image with a button to "Allow Updating"?

magpiper commented 1 year ago

Only receive the ENABLE MACROS prompt after setting MACRO security to MEDIUM (which is fine with me). I do receive the external links MSG but am able allow it after changing MACRO setting.

I left UNBLOCK unchecked as referenced above. I don't know if Libreoffice uses that attribute or not.

On Mon, Jan 2, 2023 at 7:39 PM Paul Reedy @.***> wrote:

Ok, that should be fine. In windows explorer right click on the file, select Properties. Does it show this? If so, check the box where it says Unblock and click OK. [image: image] https://user-images.githubusercontent.com/2914558/210290257-139446e4-ad44-40df-a1c5-442cd7f32680.png

also... When you open the file, does it ask you to Enable Macros, [image: image] https://user-images.githubusercontent.com/2914558/210290062-a95502f5-7e42-4aed-b3e1-803d5eff313a.png

and does it show [image: image] https://user-images.githubusercontent.com/2914558/210290123-df4574af-2bad-4a4d-b06a-ed3695ef622b.png with a button to "Allow Updating"?

— Reply to this email directly, view it on GitHub https://github.com/x2rider/OMISS-Awards/issues/15#issuecomment-1369314407, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABF7SBT4HGT42JUO5HOYPCTWQN7MVANCNFSM6AAAAAATPFRNDI . You are receiving this because you modified the open/close state.Message ID: @.***>

x2rider commented 1 year ago

If you don't unblock it, the script will not run.