COLUMN in Collabora Office: Column Numbers, Relative Positions and Array Entry

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

=COLUMN([Reference])

Reference can be a cell or area. When it is omitted, COLUMN uses the cell containing the formula. Collabora says it automatically sets that reference to the current cell.

A column coordinate is different from a count of columns. For C5:F8, the first column number is 3, while the range spans 4 columns. COLUMNS performs the count.

Examples use English names and semicolon separators when formulas have multiple arguments. Array entry is stated explicitly rather than assumed to spill automatically.

Evaluate these in separate free cells:

The row portion of a reference does not change its column coordinate. D2 and D100 both belong to column D and therefore identify column 4.

An ordinary range call returns the first column number under the dedicated function’s rule. It does not total 3+4+5+6 or count the values inside C5:F8.

Place =COLUMN() in H2. Its expected result is 8. Enter the same formula in K9, and its expected result is 11.

The formula’s location matters only because Reference was omitted. =COLUMN(C5) placed in H2 still gives 3, because the explicit reference points to C5.

These controls are useful when a template derives positions from its layout. They also reveal why copying a location-dependent formula to another column can change its output without changing its visible text.

Suppose a table occupies C5:F8. In C3 enter:

=COLUMN(C5)-COLUMN($C$5)+1

Fill horizontally through F3. Expected positions are 1, 2, 3 and 4. The source coordinates are 3, 4, 5 and 6; subtracting the anchored starting coordinate 3 and adding one makes the first position 1.

These relative positions can be compared with a separately documented INDEX column selector. They are not the absolute worksheet column numbers.

The anchor prevents the starting coordinate from moving while the first reference advances. Without that anchor, both references could move together and leave every difference equal to zero.

Select a free one-row, four-column output range, such as J2:M2. Enter this as an array formula:

=COLUMN(C5:F8)

The complete expected output across J2:M2 is 3, 4, 5, 6. The source spans four rows, but COLUMN returns one result for each column, not one for every source cell.

The Collabora array-entry instructions require the Function Wizard’s Array option or direct entry with Ctrl+Shift+Enter; on macOS the documented modifier is Command+Shift+Enter. Do not type the surrounding array-formula braces manually.

Entered normally in one cell, the same function call returns 3. That difference is documented for COLUMN and should not be treated as evidence of a broken range reference.

=COLUMN(B2:B7) gives 2 in ordinary or array form because the range has only one column. A multirow source does not automatically imply a multirow output for this function.

The referenced cells need not contain numeric observations: the function concerns their coordinates. It does not measure how many are filled or identify which column contains a header value.

Invalid references, noncontiguous unions and cross-sheet array behavior are not established by these controls. Use ADDRESS when you need text built from coordinates, and preserve the distinction between that text and a resolved reference.

• Collabora Office 26.04: COLUMN.
• 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.