Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | After save a xls file contain marco in AOO, macor can't run in MS excel. | ||||||||
---|---|---|---|---|---|---|---|---|---|
Product: | App Dev | Reporter: | binguo <binbjguo> | ||||||
Component: | vba | Assignee: | issues@vba <issues> | ||||||
Status: | CLOSED FIXED | QA Contact: | |||||||
Severity: | Normal | ||||||||
Priority: | P3 | CC: | issues, lijiany, lijianyuan1983, louqingle, sunying | ||||||
Version: | 3.3.0 or older (OOo) | ||||||||
Target Milestone: | 4.0.0 | ||||||||
Hardware: | All | ||||||||
OS: | All | ||||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||
Developer Difficulty: | --- | ||||||||
Attachments: |
|
I am investigating this issue. Background: In MS, there are two kinds of controls: Form control(TBX) and ActiveX control(OCX). Root cause: AOO exports the two as the same one TBX. Controls in sample file are OCX. Resolution: Differentiate the two kinds when import and export them individually. There is key points -- object ID which will impact the running of exported OCX controls. Handle it when import and export. Created attachment 79578 [details]
Patch for this issue
Limitation: The fix only focus on the command running. patch looks good and reivewed. Committed in revision 1389715. Fixed. verified on Win7, Mac 10.7 and suse 11 against trunk build 1404513, pass |
Created attachment 79568 [details] sample file Build: Aoo_Trunk\Aoo_Trunk_20120914.1800 Setps: 1. Launch AOO, Tools| Options... 2. Extend OpenOffice.org, select Security, click Macro Security button and check Low on Macro Security dialog. Click OK. 3. Extend Load/Save, select VBA Preperites, Check Executable code. 4. Open the sample file AOO, and click the button on sample file. 5. Input some text in the sample file. 6. Click "File -> Save" to save this file. 7. Close the file and open in MS Excel. 8. Click the button on sample file. Defect: There is no response, Macro can't be run.