ROWS in Collabora Office: Count Range Height and Build Expanding Counters

• Introduced: the original Collabora release and launch date are not established by the reviewed sources.
• Availability: documented in Collabora Office 26.04 desktop help.
• Platform scope: online and mobile deployment support is not inferred from the desktop documentation.
• Checked: October 14, 2026. Function-specific documentation and independent controls; no native Collabora execution.

=ROWS(Array)

The required argument can be a reference or named area. The official examples include a single cell, a rectangular range and a named range. A single cell has one row.

Do not confuse ROWS with ROW: ROW(D5:F8) entered normally returns the first coordinate, 5, while ROWS(D5:F8) returns the height, 4.

The examples use contiguous rectangles. Multiple-area references, malformed arguments and exact native errors are not established by this short function section.

The endpoints are inclusive. Subtracting 5 from 8 alone gives 3, which counts the gaps between row positions; adding one counts the four included rows.

Changing the number of columns does not change the height. A10:A12 and A10:Z12 each span three rows even though the latter contains many more cell positions.

Enter numbers, labels and blanks anywhere within D5:F8:

=ROWS(D5:F8)
=COLUMNS(D5:F8)

Expected results are 4 and 3. Their product is 12, the number of positions in the rectangle.

Clearing all three cells in one of those rows does not remove that row from the selected reference. ROWS still counts the four-row interval. It does not decide whether the empty row represents a missing record, a separator or an intentionally blank entry.

Use an appropriate value-counting or conditional function for a data-completeness question. Establish the inclusion rule separately before interpreting a structural height as a number of observations.

In C5 enter:

=ROWS($D$5:D5)

Fill through C9. Expected outputs are 1, 2, 3, 4 and 5, because the referenced intervals expand from D5:D5 through D5:D9.

The first endpoint stays anchored while the second moves with the copied formula. If both endpoints moved together, the range could remain one row tall and produce repeated 1s.

This technique is useful for a position column next to a table. It does not preserve a permanent record identifier after insertions, sorting or restructuring; its meaning is the size of the currently specified expanding reference.

Suppose one block occupies A2:D6 and another occupies G10:I14:

=ROWS(A2:D6)=ROWS(G10:I14)

Expected result: TRUE, because both are five rows high. Their widths are four and three, so equal height alone does not establish equal dimensions.

To compare both dimensions:

=AND(ROWS(A2:D6)=ROWS(G10:I14);COLUMNS(A2:D6)=COLUMNS(G10:I14))

Expected result: FALSE. This explicit structural check can expose a mismatched range before it is used in a larger calculation.

Matching dimensions still do not establish matching records, sorting or units. Two equally shaped blocks can represent entirely different data. Retain row identifiers when the next operation depends on alignment.

If ReportBlock is defined as C1:D3, =ROWS(ReportBlock) has expected result 3, following the documented named-area example. If its definition later expands to C1:D5, the expected result becomes 5 even though the formula text remains unchanged.

The result follows the reference definition, not a fixed number embedded in the name. Keep named-range definitions inspectable when they control report dimensions.

Use COLUMNS for width, ROW for a coordinate, and AREAS for the number of distinct grouped reference components. These are complementary structural checks, not interchangeable counts of data values.

• Collabora Office 26.04: ROWS.
• Editorial testing standards.

Complete function-specific documentation reviewed. Worked outputs are independently modeled reference, text or arithmetic controls, not captured native application results. Unverified entry, conversion and error boundaries retain their stated scope.