OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[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]