onlyoffice · Tables and ranges · Intermediate
Create and Grow a Formatted Table in ONLYOFFICE
Create a formatted table, use structured references, append records, and verify its range and total row.
Quick answer
Select a clean range, use Home → Format as table, and confirm its header option. Build a structured-reference aggregate outside the table, append a record before adding a total row, and verify the object range rather than relying on its color.
Version and evidence
ONLYOFFICE Desktop Editors 10.0.0 documentation baseline, English desktop interface on Windows/Linux; official help and desktop changelog checked 2026-10-19. No native application execution or screenshots were obtained. Exact installed build, OS behavior and saved-file round trips remain manual verification requirements; hosted and mobile behavior is outside scope. The steps below are a documented procedure with independently calculated checkpoints, not a native test report. Use an editable .xlsx practice copy. Do not treat the online help as proof of every older desktop build.
A table object keeps the meaning of a column attached to its header. Build a compact stock list, total its quantities using a structured reference, and prove that an appended record joins the table. A colored rectangle alone is not enough: the exercise checks the object, its range and its formula.
Prepare a stock list
Create a blank local workbook and rename its worksheet Stock. Save it as stock-table-practice.xlsx. Type this fixture in A1:C5, with numbers entered as numbers, not text:
| Row | A: Item | B: Qty | C: UnitPrice |
|---|---|---|---|
| 2 | Pen | 12 | 2 |
| 3 | Pad | 8 | 5 |
| 4 | Clip | 20 | 1 |
| 5 | Folder | 10 | 3 |
The headers in row 1 are Item, Qty, and UnitPrice. Leave D:F empty. Independently, the quantity total is 50 and stock value is 114: 12*2+8*5+20*1+10*3. These are different measures; summing unit prices would not produce inventory value.
Make the range a real table
On Stock, select A1:C5. Use Home → Format as table, choose a style, and check the range and the Title checkbox because row 1 already contains headers. Confirm. Select B2 inside the new object and locate Table Design. Its presence, together with the table range, is the object check. Earlier interfaces may place these settings in a sidebar; do not substitute a cell-fill command.
The official table guide documents automatic names such as Table1. In this otherwise empty workbook, use the actual assigned name shown by formula autocomplete. In E1, enter Total quantity; in E2, build =SUM(Table1[Qty]), substituting the actual name if different. Type the table name and opening bracket, then select Qty from autocomplete and close the bracket and parenthesis. Expected result: 50. Keep this formula outside the object so growth cannot absorb it accidentally.
Grow first, then add the total row
Keep Total row off. In the active Stock sheet enter Marker in A6, 5 in B6, and 4 in C6. The documented below-table expansion applies when no total row exists. Select B6; Table Design should still identify the same table. Inspect its range: A1:C6. E2 must now be 55. The new inventory value, calculated independently, is 134.
If expansion is disabled, use Table Design → Select Data to resize explicitly to A1:C6; keep the headers on row 1. Then repeat both checks. A changed cell color is not proof of inclusion: autocomplete, the table range and the updated aggregate provide stronger checks.
With the table still selected, enable Total row. It should occupy row 7. Select B7, open its function selector and choose Sum. With no filter applied, both B7 and E2 should read 55. Do not sum B2:B7 to check this total, because it includes the summary itself. The structured reference to Qty is intended to refer to the data column; inspect the formula and result rather than inserting a totals-item reference.
Keep the final workbook and inspect it again
Save stock-table-practice.xlsx, close it and reopen that same file. Activate Stock. Check table range, five detail records, row-7 total, and the literal formula in E2. The final expected quantity remains 55. This is a reader verification procedure, not a claim that the workbook has already been tested in the application.
Advanced case: another record after a total exists
Use Save As to create stock-table-growth-test.xlsx; work only in that copy. Inside the table, select the Marker detail row and use Table Design → Rows & Columns to insert a table row below it, before the summary. Enter Tape, 3, 6 in that new detail row. The quantity should become 58 and stock value 152. Verify that the summary moved down instead of being replaced. Do not type a new record below an existing summary and assume the documented no-total-row autoexpansion rule applies.
For an object-versus-style experiment, make a separate stock-table-range-test.xlsx copy of the saved main file. Select a table cell and choose Convert to range. Inspect the resulting formulas and values; do not assume formula-rewrite details. The style may remain while Table Design is unavailable. Retain the main workbook as the authoritative table version.
Troubleshooting
- A second header appears: the title option was omitted. Rebuild in a fresh practice workbook rather than shifting headers around an uncertain object.
E2stays 50: verify that row 6 belongs to the table, then check that the formula usesQtyfrom the correct table.- A formula is rejected: use autocomplete to confirm the exact table and column spelling; both brackets are required.
- The total changes after filtering: first restore every record and compare 55 again. Visible-row aggregation semantics are a separate check; this exercise deliberately has no active filter.
Defined-name creation and repair is a different workflow. Here the table’s header and object boundary are the important dependencies.