Re: [office-formula] The searched portion of SearchRegion must notinclude logical values or only include logical values.

[Eike Rathke <erack@sun.com>]

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.

PGP signature