I added a Form Control button to my spreadsheet (version 24.8.2.1 downloaded today), gave it a name, changed it’s background colour, and added a macro I’d recorded to run when the mouse was released. It all seemed to work fine, so I saved my spreadsheet, and it still all worked. However, when I closed the spreadsheet down, and re-opened, the button is still there, with the correct name, but the background colour has defaulted to a kind of standard grey colour, and the macro I added to the control is no longer part of the control. Has anyone else had this issue recently? Interestingly, I’d been having problems earlier today where the button disappeared completely, on the previous version I had (can’t remember the version), so maybe they’ve partially fixed it. Thanks
What file format are you using?
Always use the native, international standard ODF file formats fpr the files containing special features like the Macros, Form control elements.
Thanks for the advice. If I save in .ods, close, then re-open in LibreOffice, you’re correct, the control retains it’s properties, but then when I try and open the file on my phone with Excel, it does open the file but without the controls, and says “Read Only - To make changes, save a copy of this file into a Microsoft Office file format.”. To give some context, I’ve been creating a team handicap generator for a Table Tennis competition I’m running, and I want people to be able to download the spreadsheet to their phone, where they may well have Excel, enter the individual players handicaps, then press a ‘Calculate button’, which uses a lookup grid. Thanks for trying to help
Do not mix editor softwares; and do not change file type and version for your important documents. Maybe the Excel can handle only the older version of ODF (1.2 Extended or other), and maybe it can not handle precisely the ODF file types.
Thanks for the quick reply. I wouldn’t pay for MS Office for my laptop, so used LibreOffice. However, you can install the MS Excel app on an android phone, but it’s no doubt a less functional version, hence my problems, as other people I want to use what I’ve created (on match nights) will probably have Excel on their phones. I’m sure if I paid for MS Office I wouldn’t have these issues, so maybe I can’t go any further with this issue. But thanks once again for offering an opinion, much appreciated
Excel would not execute your macro anyway.
Hi, I’m not technical enough to have realised that. Can I ask why? I was thinking of asking a friend who does have Excel to take the main spreadsheet I designed, and he could then create the form control and macro that it runs, to see if that then also works if I open on LibreOffice. Or, are you suggesting it’s not possible to create form controls with macros on Excel? Thanks
The MS VBA of the Excel and the StarBasic+API of the LibreOffice are not compatible. (API: Application programming Interface)
The LO can run some VBA code (but not all of them), the Excel can not run any LO API marcos.
That all makes sense now. Thanks ever so much for trying to help me guys.