OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

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

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:eike.rathke@oracle.com] 
Sent: Monday, November 08, 2010 03:39
To: office-formula@lists.oasis-open.org
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

> > 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.


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

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]