Issue 88493 - Calc dont allow to enter formula where first parameter as optional.
Summary: Calc dont allow to enter formula where first parameter as optional.
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.4.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-04-20 16:59 UTC by bijugc
Modified: 2013-12-26 16:53 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

ooo_first_optional.png (4.39 KB, text/plain)
2008-04-20 17:01 UTC, bijugc
no flags Details
ooo_first_optional.png (correct mime type) (4.39 KB, image/png)
2008-04-20 17:03 UTC, bijugc
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description bijugc 2008-04-20 16:59:59 UTC
Calc dont allow to enter formula where first parameter as optional.

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
   " 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:- 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
  elseif max < 1 then
    redim preserve a(max-1)
  end if 
  list2array = a
end function
Comment 1 bijugc 2008-04-20 17:01:20 UTC
Created attachment 53045 [details]
Comment 2 bijugc 2008-04-20 17:03:31 UTC
Created attachment 53046 [details]
ooo_first_optional.png (correct mime type)
Comment 3 amy2008 2008-08-21 07:25:38 UTC
Can reproduce it in OOo-Dev_OOO300_m3_en-US on WinXP.
Comment 4 Edwin Sharp 2013-12-26 16:53:27 UTC
As given in description.

AOO410m1(Build:9750)  -  Rev. 1551017
Win 7