Re: [office-comment] cell-content-is-between

From
<>
Date
2015-02-24T17:23:06+00:00
ID
Thread
Re: [office-comment] cell-content-is-between
Camille Moulin scripsit:

> It is currently quite straightforward [1]:
>
>> cell-content-is-between(value1,  value2): true if the cell's value is
>> between value1 and value2.

I agree that the behavior on non-numeric values is unspecified by the
standard, but what's worse is that it is not specified (a) whether
a cell equal to value1 or value2 succeeds (what do your implementations
do?), and (b) whether only the case value1 < cell < value2 is meant to
be true, or also the case value2 < cell < value1.

-- 
John Cowan          http://www.ccil.org/~cowan        
You are a child of the universe no less than the trees and all other acyclic
graphs; you have a right to be here.  --DeXiderata by Sean McGrath