Apache OpenOffice (AOO) Bugzilla – Issue 87053
Form control buttons not working in opened Excel sheet
Last modified: 2013-01-29 21:39:28 UTC
Hi, at Betterware we have electronic order sheets designed in Excel which have control buttons for navigating round the rather large workbook. I have just loaded one of these and discovered that these buttons don't work, all of them returning the error: "A Scripting Framework error occurred while running the Basic script vnd.sun.star.script:Standard.Search?language=Basic&location=document Message: BasicProviderImpl:getscript: no script!" Our IT department has just recommended Open Office Calc to the Betterware sales team as an alternative to Excel so it is important to us that this issue is fixed. I am attaching a copy of the file, however, the VB code in the sheet is passworded. Should you require the password I will have to email the IT department for it.
Created attachment 52116 [details] Betterware electronic Order form in Excel format
Can reproduce it in OOo300_m3_EN on WinXP. Thank you very much, betterwaremichael. Li Meiying
There is the help for Macros in Microsoft Office and OOo-dev. 'Microsoft Office and OOo-dev cannot run the same macro code. Microsoft Office uses VBA (Visual Basic for Applications) code, and OOo-dev uses Basic code based on the OOo-dev API (Application Program Interface) environment. Although the programming language is the same, the objects and methods are different. If you use macros in one of the applications and want to use the same functionality in the other application, you must edit the macros. OOo-dev can load the macros that are contained within Microsoft Office files and you can then view and edit the macro code in the OOo-dev Basic IDE editor.' In this way, you should edit your macro code to make it work up to now.
Thank you for your comments amy2008 I will inform our IT department. betterwaremichael