Issue 87053

Summary:

Form control buttons not working in opened Excel sheet

Product:

Calc

Reporter:

betterwaremichael <betterware>

Component:

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Severity:

Trivial

Priority:

CC:

amy2008, issues

Version:

OOo 2.3.1

Target Milestone:

---

Hardware:

OS:

Windows XP

Issue Type:

ENHANCEMENT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

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
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.

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.

betterwaremichael