To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113924 Issue #|113924 Summary|Multiple arguments in user-defined function subprogram Component|Spreadsheet Version|OOo 2.0.3 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|FEATURE Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|martingoodman
------- Additional comments from martingood...@openoffice.org Mon Aug 16 18:11:16 +0000 2010 ------- SUMMARY OF ISSUE The Visual Basic programming language included in MICROSOFT EXCEL allows more than one argument (i.e., input variable) to be used in a user-defined function. However, OPENOFFICE.org BASIC apparently allows only one argument in a user- defined macro. Consequently, user-defined MICROSOFT EXCEL Visual Basic functions with more than one variable will not run in OPENOFFICE spreadsheets. STEP-BY-STEP DESCRIPTION 1. Enter a user-defined macro with more than one variable into the macro window of the OPENOFFICE.org spreadsheet. 2. Reference the user-defined macro in the spreadsheet window of OPENOFFICE.org. EXAMPLE 1. Enter the following function in the macro window of a spreadsheet. Function Example(X1, X2, X3) Example = X1 + X2 + X3 End Function 2. Enter the following function call in cell A1 of a spreadsheet: =example(1,2,3) When this is done in MICROSOFT EXCEL, the result “6” appears in cell A1. However, the OPENOFFICE.org spreadsheet yields the following result in cell A1: “ #NAME? “. The preceding deficiency apparently exists even in the most recent versions of the OPENOFFICE.org spreadsheet. Adding multiple-argument capability to user-defined macros would significantly enhance the OPENOFFICE.org spreadsheet. Respectfully, Martin Goodman --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org