[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [office-formula] Treatment of argument separators
Current drafts of part 2 don't seem to specify how to handle optional parameters when the preceding argument separator is used or not. For example, using VLOOKUP with its optional 4th parameter, Excel produces the same result when an argument separator is used prior to an optional argument as when it is not. Calc produces different results. In Excel Formula Result =VLOOKUP(2,{1,"a";2,"b";3,"c"},2,) b =VLOOKUP(2,{1,"a";2,"b";3,"c"},2) b In Open Office Calc VLOOKUP(2;{1;"a"|2;"b"|3;"c"};2;) Err:511 VLOOKUP(2;{1;"a"|2;"b"|3;"c"};2) b Should we call this out as implementation dependent? -Eric
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]