Libre office doesn't save buttons and macros + VB scripts

asked 2018-03-08 07:55:58 +0100

DivineKataroshie gravatar image

updated 2018-03-08 17:59:43 +0100

David gravatar image

I created this file, and these are my settings for VB scripts and macro :

screenshot

and even tho, when I save the file in Microsoft Excel macro-enabled format XML, when I save the file everything except the text disappears.

Any idea on what might be causing the issue ? is there any way to save the file properly ?

edit retag flag offensive close merge delete

Comments

@DivineKataroshie How did you create this Spreadsheet - using MS Excel? It uses a Toggle Button which is an ActiveX control which AFAIK is not supported in LO Calc. It works OK when opened in Excel.

peterwt gravatar imagepeterwt ( 2018-03-09 13:12:12 +0100 )edit

"is there any way to save the file properly?" Yes, in .ods format. And rewrite the macros in LO Basic rather than VBA. However, it is possible to create spreadsheets with macros that work in both suites but takes a great deal of effort. You must become an expert in both languages and both Office suites. Not recommended in most cases.

Jim K gravatar imageJim K ( 2018-03-09 15:02:50 +0100 )edit