Re: [office-formula] Sections 4.8 Reference and 5.8 References?

From
Eike Rathke <>
Date
2010-11-08T11:47:07+00:00
ID
Thread
Re: [office-formula] Sections 4.8 Reference and 5.8 References?
Hi Patrick,

On Saturday, 2010-11-06 20:43:11 -0400, Patrick Durusau wrote:

> OK, so let me reproduce 4.8 and you say type/not type:
> 
> 
> > A cell strip consists of cell positions in the same row and in one or
> > more contiguous columns.
> 
> If anything, defining "cell strip"? Yes? Delete/move?
> 
> > 
> > A cell rectangle consists of cell positions in the same cell strips of
> > one or more contiguous rows.
> 
> Same question for cell rectangle.
> 
> > A cell cuboid consists of cell positions in the same cell rectangles
> > of one or more contiguous sheets.
> 
> Same question for cell cuboid.
> 
> > A reference is the smallest cuboid that (1) contains
> > specifically-identified cell positions and/or specifically-identified
> > complete columns/rows such that (2) removal of any cell positions
> > either violates condition (1) or does not leave a cuboid.
> > 
> 
> OK, here is the content for a type definition. I think cuboid is well
> known enough to pass without definition.

The definitions are the resolution of
http://tools.oasis-open.org/issues/browse/OFFICE-2334


> > Cell positions in a cell cuboid/rectangle/strip can resolve to empty
> > cells (section 3.7).
> 
> Definitely 5.8 material.

Ok, agreed.


> > The definitions of specific operations and functions that allow
> > references as operands and parameters stipulate any particular
> > limitations there are on forms of references and how empty cells, when
> > permitted, are interpreted.
> > 
> 
> Delete. I think I know what this means but it is a tautology. 
> 
> Operations and functions that allow references, may place limits on the
> forms of those references and if permitted, how references to empty
> cells are interpreted. 
> 
> OK, so operations and functions define their inputs. What's the news in
> that? ;-)

Agreed, at its best it is confusing.

  Eike

-- 
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.