Issue 87053

Summary: Form control buttons not working in opened Excel sheet
Product: Calc Reporter: betterwaremichael <betterware>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: amy2008, issues
Version: OOo 2.3.1   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
Betterware electronic Order form in Excel format none

Description betterwaremichael 2008-03-15 18:55:19 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 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.
Comment 1 betterwaremichael 2008-03-15 18:57:23 UTC
Created attachment 52116 [details]
Betterware electronic Order form in Excel format
Comment 2 amy2008 2008-09-03 06:30:27 UTC
Can reproduce it in OOo300_m3_EN on WinXP.
Thank you very much, betterwaremichael.

Li Meiying
Comment 3 amy2008 2008-09-03 06:54:51 UTC
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. 
Comment 4 betterwaremichael 2008-09-03 16:22:54 UTC
Thank you for your comments amy2008

I will inform our IT department.