https://issues.apache.org/ooo/show_bug.cgi?id=121434
Bug ID: 121434
Issue Type: DEFECT
Summary: Does not recognize VBA macro in JAPANESE
Classification: Application
Product: spreadsheet
Version: AOO 3.4.1
Hardware: All
OS: Windows, all
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: open-import
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Created attachment 79992
--> https://issues.apache.org/ooo/attachment.cgi?id=79992&action=edit
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.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
