You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/09/19 10:15:00 UTC

[Bug 121045] New: After save a xls file contain marco in AOO, macor can't run in MS excel.

https://issues.apache.org/ooo/show_bug.cgi?id=121045

          Priority: P3
            Bug ID: 121045
                CC: ooo-issues@incubator.apache.org
          Assignee: issues@vba.openoffice.org
           Summary: After save a xls file contain marco in AOO,  macor
                    can't run in MS excel.
          Severity: normal
        Issue Type: DEFECT
    Classification: Code
                OS: All
          Reporter: binbjguo@gmail.com
          Hardware: All
            Status: CONFIRMED
           Version: AOO 3.4.0
         Component: code
           Product: vba

Created attachment 79568
  --> https://issues.apache.org/ooo/attachment.cgi?id=79568&action=edit
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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 121045] After save a xls file contain marco in AOO, macor can't run in MS excel.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121045

--- Comment #2 from Jianyuan Li <li...@gmail.com> ---
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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 121045] After save a xls file contain marco in AOO, macor can't run in MS excel.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121045

Jianyuan Li <li...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |lijianyuan1983@gmail.com

--- Comment #1 from Jianyuan Li <li...@gmail.com> ---
I am investigating this issue.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 121045] After save a xls file contain marco in AOO, macor can't run in MS excel.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121045

--- Comment #6 from Jianyuan Li <li...@gmail.com> ---
Committed in revision 1389715.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 121045] After save a xls file contain marco in AOO, macor can't run in MS excel.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121045

sunying <su...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |sunying@apache.org

--- Comment #5 from sunying <su...@apache.org> ---
patch looks good and reivewed.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 121045] After save a xls file contain marco in AOO, macor can't run in MS excel.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121045

louqle <lo...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|VERIFIED                    |CLOSED

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 121045] After save a xls file contain marco in AOO, macor can't run in MS excel.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121045

louqle <lo...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |VERIFIED
                 CC|                            |louqingle@gmail.com

--- Comment #8 from louqle <lo...@gmail.com> ---
verified on Win7, Mac 10.7 and suse 11 against trunk build 1404513, pass

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 121045] After save a xls file contain marco in AOO, macor can't run in MS excel.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121045

Jianyuan Li <li...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|CONFIRMED                   |RESOLVED
                 CC|                            |lijiany@apache.org
         Resolution|---                         |FIXED

--- Comment #7 from Jianyuan Li <li...@apache.org> ---
Fixed.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 121045] After save a xls file contain marco in AOO, macor can't run in MS excel.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121045

--- Comment #4 from Jianyuan Li <li...@gmail.com> ---
Limitation: The fix only focus on the command running.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 121045] After save a xls file contain marco in AOO, macor can't run in MS excel.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121045

hdu@apache.org <hd...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Target Milestone|---                         |AOO 4.0

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 121045] After save a xls file contain marco in AOO, macor can't run in MS excel.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121045

Jianyuan Li <li...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #79578|                            |review?
              Flags|                            |

--- Comment #3 from Jianyuan Li <li...@gmail.com> ---
Created attachment 79578
  --> https://issues.apache.org/ooo/attachment.cgi?id=79578&action=edit
Patch for this issue

-- 
You are receiving this mail because:
You are on the CC list for the bug.