Product: Spreadsheet
Type: new
Title: Infix Operator Reference Range (":")
Posted by: [EMAIL PROTECTED]
Affected: sc
Effective from: cws odff
*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [x]
Performance test [ ]
Translation [ ]
UI relevant [ ]
*Description*
-------------
Summary: Computes an inclusive range given two references
Syntax: Reference Left : Reference Right
Returns: Reference
Semantics: Takes two references and computes the range, that is, a
reference to the smallest 3-dimensional cube of cells that include
both Left and Right. Note that Left and Right need not be a single
cell. For an expression such as B4:B5:C5 the resulting range is B4:C5.
In case Left and/or Right involve a reference list (result of operator
reference union), the range is computed and extended for each element
of the list(s). For example, (a,b,c,d denoting one reference each)
(a~b):(c~d) computes a:b:c:d
determining the outermost front-upper-left and rear-lower-right corners.
Note that Left and Right may also be defined names or the result of a
function returning a reference, such as INDIRECT.
Description taken from the ODFF specification draft available at
http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula
Send feedback to [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
