These all strike me as about the semantics of references and belong in the
type description. I wouldn't move any of it.
- Dennis
There is a related question, that Andreas reminds us about, for how
"contiguous sheets" are determined, but that is a host-dependent property
(along with whether or not there are even named sheets available, etc.).
There is a presumed ordering of the sheets (they are numbered, apparently,
although one can't refer to them by their numbers), but it is the hosted
specification or the implementation of a hosted specification that
determines what that is.
-----Original Message-----
From: Eike Rathke [mailto:]
Sent: Monday, November 08, 2010 03:39
To:
Subject: 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.
