Returns the coords as a string address (e.g., 'A1' or 'A1:E5').
Optionalr1c1: boolean
If unspecified returns the environment's default.
The region's anchor (top-left) cell — the read that IS the region's payload.
A region is uniform in the requested features, so the anchor's read describes every cell in
it: the fill of a Fill region, the authored formula of a Formula region. It says nothing
about features that were not requested — for those, the anchor is just a cell.
Unlike ICellRange.getCell this takes no address: reading into the block is a range question, so it goes through getRange.
Returns the number of columns of the range.
The IRange.Coords.
The features this region is uniform in. See ICellRegions.getFeatures.
The same list the parent ICellRegions carries, so a region passed on its own still knows what it is uniform in.
The region as a readable range — the one explicit hop from where to what.
Returns the number of rows of the range.
Whether this region was cut short by the query extent — the block continues past the range that was partitioned.
The default containment: 'intersects' includes straddling blocks clipped to the queried
range, which is the right default: 'fullyContained' would answer a constrained query with
silence whenever the block is bigger than the constraint, and silence reads as "no data
here". The cost of that default is that a member's address can be an artifact of the query
boundary, and every fact derived from it — a row count, a profile, a stats read — then
describes a fragment while presenting as a block. This is the flag that makes the clip
visible instead of silent.
false for 'fullyContained' partitions by construction, and for any region whose edges sit
inside the extent.
Exact for ICellRange.Feature.Contentful, whose blocks are occupancy and therefore
continue or do not. For a payload-identity feature (Fill, Formula) it answers the feature
continues past this edge — the neighbouring block may carry a different color or a different
authored formula and so be a genuinely separate region. Conservative in that direction on
purpose: a spurious "check the edge" costs a glance, a missed clip costs a wrong answer.
Returns the address as a string.
One member of an ICellRegions partition: a rectangle whose cells agree on every feature the call requested.
Remarks
A region answers where. It carries geometry — the facts that are true of it no matter which features produced it — and two bridges to the objects that answer everything else: getCell and getRange.
It is deliberately NOT an ICellRange. A range's reads are honest about a range; on a region they would be honest only for the features that were requested, and the type cannot see that list. So the hop is explicit: you ask for a range, and then you read. The anchor cell's read is the region's payload —
getCell()is the short way to say that.