Apache OpenOffice (AOO) Bugzilla – Issue 88493
Calc dont allow to enter formula where first parameter as optional.
Last modified: 2013-12-26 16:53:27 UTC
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
Created attachment 53045 [details] ooo_first_optional.png
Created attachment 53046 [details] ooo_first_optional.png (correct mime type)
Can reproduce it in OOo-Dev_OOO300_m3_en-US on WinXP.
As given in description. AOO410m1(Build:9750) - Rev. 1551017 Rev.1551017 Win 7