[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [office-formula] The searched portion of SearchRegion must notinclude logical values or only include logical values.
Hi Patrick, On Sunday, 2010-03-28 21:00:45 -0400, Patrick Durusau wrote: > This appears in various forms: > > The searched portion of /SearchRegion/ must not include logical values > or _only_ include logical values. > > > I have reworded it into: > > The searched portion of SearchRegion must not include logical values. > > Reasoning that if it contains logical values that includes containing > only logical values. Yes? No. This was in the Portable Constraints and meant for evaluators that do not have a distinct Logical type. For those, if the sort order was numeric<alpha<logical, having logical mixed with numeric and/or alpha would yield unpredictable results. Hence the original portable constraint that SearchRegion must either not include Logical at all, or only Logical. However, I think that your current text as posted in another mail (SearchRegion must not include Logical, but evaluators may process a SearchRegion that does) suits the needs. IMHO this is a case where portable constraint really made sense, but since we wanted to get rid of them... Eike -- Automatic string conversions considered dangerous. They are the GOTO statements of spreadsheets. --Robert Weir on the OpenDocument formula subcommittee's list.