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
