Apache OpenOffice (AOO) Bugzilla – Issue 121434
Does not recognize VBA macro in JAPANESE
Last modified: 2012-12-21 10:25:50 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.
Created attachment 79993 [details] Created with Japabese MS Excel 2003. Appache OpenOffice 3.4.1 did NOT recognize VBA Macro.
Confirmed it.