Issue 121434 - Does not recognize VBA macro in JAPANESE
Summary: Does not recognize VBA macro in JAPANESE
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.1
Hardware: All Windows, all
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks: 121500
  Show dependency tree
 
Reported: 2012-12-04 01:33 UTC by ashisuto_moi
Modified: 2012-12-21 10:25 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Created with English MS Excel 2003. Appache OpenOffice 3.4.1 recognized VBA Macro normally. (16.50 KB, application/vnd.ms-excel)
2012-12-04 01:33 UTC, ashisuto_moi
no flags Details
Created with Japabese MS Excel 2003. Appache OpenOffice 3.4.1 did NOT recognize VBA Macro. (13.50 KB, application/vnd.ms-excel)
2012-12-04 01:33 UTC, ashisuto_moi
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description ashisuto_moi 2012-12-04 01:33:17 UTC
Created attachment 79992 [details]
Created with English MS Excel 2003.  Appache OpenOffice 3.4.1 recognized VBA Macro normally.

[Apache OpenOffice 3.4.1, Windows XP SP3, Both of Japanese and English]

(LibreOffice had similar issue too, fdo#49324.)

When trying to execute a VBA macro in AOO341 with VBA Support Option to 1 (and VBA options checked in AOO341 preferences), AOO341 does NOT recognize the VBA macro file which was made with JAPANESE MS Excel 2003.

AOO341 does recognize VBA macro file which was made with English MS Excel 2003, normally.

Steps to reproduce:
1. Open "Book1_enUS_xls2003.xls" with AOO341.
2. Click [Enable Macros] on Security Warning dialog.
3. Tool -> Macros -> Organize Macros -> OpenOffice.org Basic.
4. Choose Macro from Book1_enUS_xls2003.xls - VBAProject - Modules - Module1.
5. Choose Existing in Module1 : test. 
6. Click Edit button. 

7. Now you can confirm the VBA Macro program.
8. Close "Book1_enUS_xls2003.xls" file.

Next,

9. Open "Book1_jaJP_xls2003.xls" with AOO341.
  (AOO opens this file without any warning dialog)
10. Tool -> Macros -> Organize Macros -> OpenOffice.org Basic.
11. Choose Macro from Book1_jaJP_xls2003.xls - VBAProject - Modules - Module1.
12. Nothing in Existing in Module1 box, and Edit button is grayed out.

13. you can not confirm the VBA Macro program.
14. Close "Book1_jaJP_xls2003.xls" file.

In the following steps,

15. Open "Book1_jaJP_xls2003.xls" with AOO341.
16. Click [Enable Macros] on Security Warning dialog
17. Tool -> Macros -> Organize Dialogs.
18. Choose Module1  from Book1_jaJP_xls2003.xls on Mofules tab.
19. Click Edit button.
20. Now you confirm the "Option "VBASupport 1" statement, but there is no more statement.


Please investigate this matter.
Thank you for your help and looking forward to your reply.
Comment 1 ashisuto_moi 2012-12-04 01:33:56 UTC
Created attachment 79993 [details]
Created with Japabese MS Excel 2003.  Appache OpenOffice 3.4.1 did NOT recognize VBA Macro.
Comment 2 binguo 2012-12-21 10:25:50 UTC
Confirmed it.