COLUMN Function in ONLYOFFICE Spreadsheet Editor: Syntax and Examples

=COLUMN(D7) is expected to return 4, because D is the fourth worksheet column. =COLUMN() entered in F12 is expected to return 6; its reference argument is optional. These are independently reasoned expected results, not observations from a live ONLYOFFICE installation. The current ONLYOFFICE COLUMN reference was checked October 13, 2026.

COLUMN answers “what is the worksheet column number for a cell reference?” It helps locate a field, verify a layout assumption and build positional calculations. It does not count how many columns occur in a range; that task belongs to COLUMNS.

=COLUMN([reference])

• reference (optional): reference is an optional cell reference. Omitting it returns the column number of the cell selected to display the function result, as described in the official ONLYOFFICE function article. The no-argument result must be interpreted in the formula’s location; there is no separate number default.
• Required arguments: none. Documented optional arguments: one. Argument order: only reference, when supplied.
• Result: a one-based worksheet column number for the referenced cell (or the formula’s position if the argument is omitted).
• Array status: the ONLYOFFICE article identifies this as an array formula and links the array-entry procedure. This does not authorize assuming that all Excel 365 dynamic-spill behavior is available.
• Regional formula considerations: one-argument formulas need no parameter delimiter. The English documentation uses function names shown here; nested IF uses English-formula commas in this guide. Local formula language and punctuation may differ.

Primary source: ONLYOFFICE COLUMN, Syntax and Notes (accessed 2026-10-13).

The current English ONLYOFFICE Spreadsheet Editor catalogue contains COLUMN under Lookup and Reference Functions. The Formula tab guide depicts both online and desktop interfaces. These common help pages do not state a minimum release number that guarantees identical COLUMN results in Docs/web versus Desktop Editors. The documentation version is unversioned; no exact Desktop Editors or Docs build was installed or executed. Platform parity, localized names, and imported-file edge cases therefore remain unverified.

ONLYOFFICE Advanced Settings documents Formula Language and Region controls. Our examples use English names, A1 references and commas inside the two-argument/three-argument IF expression. Verify the formula autocomplete and syntax tooltip in your own localized editor. Region-specific number display separators and function-argument delimiters should not be conflated without local testing.

Open a blank worksheet. Enter the following sample; the numbers and order IDs are teaching data, not a downloaded workbook or native-test fixture. Put formula outputs in unused cells outside A1:D7, except the clearly specified optional array destination.

An empty A5 still has a physical location: row 5, column A. A formula that reports its position does not tell you whether the cell contains text.

For the line annotated “entered in F12”, type only =COLUMN() in F12; the bracketed placement note is not part of the formula. Every outcome above is a predictable expected coordinate calculation. Native ONLYOFFICE desktop and browser execution were not performed, so do not use the table as a test report.

Explicit single-cell reference versus a range

To ask which worksheet column contains a given cell, use a single reference such as =COLUMN(D7) (expected 4). A range such as B2:D7 spans three columns; for the width of that rectangle, use =COLUMNS(B2:D7) (expected 3). The official COLUMN article describes its optional argument as a cell reference, and flags array-formula use; it does not specify every scalar behavior for a multi-cell reference.

Array use to list column positions

Select F2:H2 as three empty cells. Enter =COLUMN(B2:D2) using the formula bar and press Ctrl+Shift+Enter. According to the ONLYOFFICE array-formula instructions, the editor uses the preselected output range and adds array braces automatically. Expected results F2, G2, H2 are 2, 3, 4 from left to right. This is a source-supported procedure with independently reasoned expected values, not a native execution. Never type {=COLUMN(...)} into a cell as literal braces.

Detect a moved field in a known worksheet layout

=IF(COLUMN(D1)=4,"Status is in D","Review columns") is expected to return Status is in D. It verifies that the referenced address is D, not that the text in D1 says Status. A robust import-validation flow also checks the header content separately; a formula with COLUMN(D1) cannot tell whether someone renamed or replaced that header.

Derive inclusive width from endpoint locations

=COLUMN(D2)-COLUMN(A2)+1 is expected 4; =COLUMNS(A2:D2) is also expected 4. This relationship works for a contiguous rectangle in A1 reference mode. For unions, named ranges or sheet-spanning references, this guide does not claim parity without native validation.

• COLUMNS versus COLUMN. COLUMN(D7) returns D’s one-based position (expected 4), while COLUMNS(B2:D7) counts three column positions.
• Omitted reference. COLUMN([reference]) declares the argument optional. =COLUMN() entered in cell F12 is expected 6 (F is the sixth column). If another location gives a different result, check the formula cell, not the last selected input value.
• Confusing zero-based programming indexes. Column A maps to 1 in spreadsheet A1 notation, not 0. B maps to 2, C to 3 and D to 4.
• Array output appears truncated. The official guide says to select the output range before using Ctrl+Shift+Enter. Recheck F2:H2 and the array formula bar; a scalar result alone is not proof that the multi-cell demonstration ran.
• Part of an array cannot be changed. The array guide warns that editing one cell of an existing array can fail. Select the whole array output before editing or deleting it.
• Manually typed curly brackets. These are inserted automatically by the editor; remove them and redo the entry method.
• Quoted address instead of cell reference. =COLUMN("D7") passes text, not the documented cell reference. Exact native error response was not tested.
• Imported sheets and alternate reference styles. The vendor Advanced Settings provides formula-language choices and may affect how a workbook is viewed. A reference from a different spreadsheet system needs platform-specific testing; do not assume all Excel array-spill or naming behavior matches.

Microsoft’s Excel COLUMN documentation confirms a matching basic signature COLUMN([reference]) and describes the one-based worksheet position, while also detailing range/array behavior that varies with Excel editions. ONLYOFFICE’s own COLUMN documentation is the authority for THIS guide. In particular, the vendor’s Insert Array Formulas explicitly documents selecting an output block and using Ctrl+Shift+Enter. Excel for Microsoft 365 can use newer dynamic-array entry behavior; do not assume that ONE keyboard workflow or all spill cases transfer perfectly between the products. No native parity checks were run. This page makes no blanket compatibility claims about LibreOffice, Google Sheets, OpenOffice, Apple Numbers or mobile editors.

• ONLYOFFICE COLUMN official reference — 2026-10-13; exact syntax, optional argument, geometric result and array-function identification.
• ONLYOFFICE Insert Array Formulas — 2026-10-13; selection of output range, Ctrl+Shift+Enter, automatic array braces and editing restrictions.
• ONLYOFFICE Insert Functions catalogue — 2026-10-13; category and function availability in the unversioned English help index.
• ONLYOFFICE Formula tab — 2026-10-13; shows online/desktop interfaces, not minimum builds or runtime parity.
• ONLYOFFICE Advanced Settings — 2026-10-13; regional and formula-language options.
• ONLYOFFICE ROW, ROWS, COLUMN, COLUMNS, IF — 2026-10-13; official checked reference links for example derivations and related topics.
• Microsoft Excel COLUMN — 2026-10-13, cross-compatibility context only; do not attribute Excel-specific array behaviors to ONLYOFFICE without testing.

Verification: All coordinate calculations are independent expectations. Native Desktop/web scalar and array execution, localized parsing, historical versions and workbook interchange were not tested.