To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=88492
Issue #|88492
Summary|Calc dont allow to enter formula where first parameter
| as optional.
Component|Spreadsheet
Version|OOo 2.4.0
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|editing
Assigned to|spreadsheet
Reported by|bijugc
------- Additional comments from [EMAIL PROTECTED] Sun Apr 20 15:59:41 +0000
2008 -------
Calc dont allow to enter formula where first parameter as optional.
Steps:-
1. add following list2array macro to "My Macro" module
2. put a break point on "if ismissing(separator) or " .... line
3. come back to Calc to enter formula
4. enter =LIST2ARRAY(;;2)
Result actual:-
Error message prompt
"OpenOffice.org Calc found an error in the formula entered.
Do you want to accept the correction proposed below?"
see attachment: ooo_first_optional.png
Result Expected:-
OpenOffice.org Calc should accept the formula as it is and processes.
As it will valid to have the first parameter missing per the macro declaration.
(PS: related issue 88491)
==== list2array ====
function list2array( _
optional list as string, _
optional separator as string, _
optional max as integer)
if ismissing(list) then
list = ""
end if
if ismissing(separator) or separator = "" or separator = "0" then
separator = ","
end if
dim a()
a = split(list, separator)
if ismissing(max) then
'nothing
elseif max < 1 then
'nothing
else
redim preserve a(max-1)
end if
list2array = a
end function
---------------------------------------------------------------------
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
