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/12/04 02:33:17 UTC
[Bug 121434] New: Does not recognize VBA macro in JAPANESE
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: issues@openoffice.apache.org
Reporter: hmoi@ashisuto.co.jp
CC: issues@openoffice.apache.org
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.
[Bug 121434] Does not recognize VBA macro in JAPANESE
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121434
--- Comment #1 from ashisuto_moi <hm...@ashisuto.co.jp> ---
Created attachment 79993
--> https://issues.apache.org/ooo/attachment.cgi?id=79993&action=edit
Created with Japabese MS Excel 2003. Appache OpenOffice 3.4.1 did NOT
recognize VBA Macro.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121434] Does not recognize VBA macro in JAPANESE
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121434
Yan Ji <ya...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Blocks| |121500
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121434] Does not recognize VBA macro in JAPANESE
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121434
binguo <bi...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |binbjguo@gmail.com
Ever confirmed|0 |1
--- Comment #2 from binguo <bi...@gmail.com> ---
Confirmed it.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.