Opening «functions-showcase.xlsx»
Reading the workbook…
0 s
AutoSave
кабинка-ccbd471966c09e5d48910ab6
Home

Clipboard

Paste
Font

Copy, cut, and paste visible cells from the current selection and active cell.

Clipboard
Главная

Шрифт

Абзац

Font, size, colour and borders apply to the current visible selection.

Шрифт
Главная

Выравнивание

Alignment applies to the current visible selection. Extended print layout and automatic row/column resizing remain separate tasks.

Выравнивание
Главная

Перенос и объединение

Wrap

Wrap, shrink to fit and merge apply to the current visible selection; extended print layout remains a separate task.

Перенос и объединение
Home

Number

Number

Basic number, percentage, currency, date, time, and text formats apply to the current visible selection.

Number
Главная

Стили

Conditional formatting applies visible styles to the selected numeric cells.

Стили
Главная

Ячейки

Ячейки

Insert, delete, hide, unhide and autofit work on the visible rows and columns of the current workbook.

Ячейки
Главная

Редактирование

Change Case: select a visible text cell.

Editing

Editing works on the visible cell, the formula bar, clear, cut, copy, paste and filling the selected range.

Редактирование
Paste
Clipboard
Font
Alignment
Paragraph
Cells
Number
Styles
Cells

Change Case: select a visible text cell.

Editing
A1

Choose data source

Choose a data source to connect through Power Query.

12 data sources

Connect to data source

SharePoint Online list

Online services

Learn more

Connection settings

Connection credentials

Sign in with an organizational account to continue.

Рабочая область листа

Сетка, выделение и ввод работают в видимой области текущего листа.

kind=default-ltr-session-placeholder; workbook=ltr; active=ltr; writing=horizontal-tbНаправление листа применяется к текущему виду.

ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBD
1SumOffice — the worksheet functions, and what they actually do
2Every row on the sheets that follow is a real formula over the data on that sheet. Nothing here is a stored answer: open this book in a SumOffice cabin and the engine computes it in front of you. The Expected column holds the answer worked out independently; the Check column compares the two live, where the engine can; and the Status column records what a sweep of this very cabin found, row by row — including the rows the engine does not answer. Nothing is hidden by leaving it out.
3
4Functions catalogued in this book
5Category sheets9
6Verified value-by-value in the cabin (measured)432
7Rows the engine returned no value for (measured)1
8
9SheetFunctionsAgree (live)Disagree (live)
10Math and stats
11Text
12Date and time
13Lookup and reference
14Logical
15Financial
16Information
17Engineering
18Database
19All sheets
20
21What the sweep found, row by rowMeasured 2026-09-14 against the cabin at https://view.sumoffice.com/view/functions/, engine build f1 287a4a62f. These are counts of the Status column on the sheets that follow, not of anything computed here.
22StatusFunctionsWhat it means
23computes410the engine's live value equals the independently computed reference
24computes (more digits)22same value, carried to more decimal places than the reference
25computes (volatile)6value changes on every recalculation; checked by property, not by value
26computes (no reference)2the engine answers, but no second engine reproduced the answer
27differs10the engine answers, and the answer does not match the reference
28no value yet1the engine returns nothing for this row
29
30Where the list comes fromThe spreadsheet engine's own coverage map (docs/collab/calculation-engine-coverage-gap-map.json), commit b7647bbd1917 of 2026-05-12. Every function the map calls live has a row here — including the ones the engine turned out not to answer.
31Why Agree/Disagree is smaller than the Status countsThe Agree/Disagree columns above are live COUNTIFs over the Check column, and the engine only carries two of the four check formulas through to a value: it answers IF(C=D,…) and IF(ISERROR(C),…), and leaves IF(EXACT(C,D),…) and IF(AND(ISNUMBER(C),ABS(C-D)<=…),…) blank. That is a gap in the engine's dependency tracking, not a missing answer — the Live result cells beside them are computed and correct. The Status column is how the whole book was judged.
32What is not here at all9 functions the map calls absent and 2 it blocks at a network boundary are listed, by name and reason, on the Not supported sheet — they are not computed anywhere in this book. That sheet also names every row this sweep found without a value, and every row that differs.
33Volatile rowsNOW, TODAY, RAND, RANDBETWEEN, RANDARRAY and INFO change on every recalculation, so their Expected cell describes the answer instead of fixing it; their Check column tests a property that must hold, and their Status reads "computes (volatile)".
34Manual rowsODDFPRICE and ODDFYIELD (Financial sheet) carry no independently computed reference: their odd-period bond math was not reproduced by a second engine with confidence, so the Check column reads "manual" instead of OK/DIFF and they are excluded from the Agree/Disagree totals. Read the live cell by eye.
35Built2026-09-14 by tools/workbook/build.py
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96

Canvas grid keeps keyboard focus on the visible cell selection. Arrow keys move the active cell inside the visible window. Alt+Up/Down and bottom-bar buttons move through visible read-only surface objects. Escape returns from object selection to cells.

Sheets 11 листов | видимые вкладки
Overview -> xl/worksheets/sheet1.xml
ready n/a live_verified live_verified updated_truthfully
Overview -> xl/worksheets/sheet1.xml
ready n/a live_verified live_verified values_only_same_workbook_sheet no no no no no no live_verified unreferenced_bounded_sheet_only live_verified last_unreferenced_bounded_sheet_current_session save_reopen_after_restore_live blocked_truthful_boundary no live_verified same_workbook_sheet_order_only true no true live_verified same_workbook_visible_hidden_very_hidden live_verified blocked_truthful_boundary live_verified same_workbook_worksheet_sheetPr_tabColor_rgb live_verified same_workbook_worksheet_sheetPr_codeName live_verified same_workbook_unpassworded_sheetProtection_metadata no live_verified active_worksheet_cells_only_preserve_sheet_metadata no

Нижний shell показывает видимые вкладки книги. Переключение листов live только при host bridge; вставка листа остаётся non-live.

Ready InsertingDeletingFittingOpeningSortingFiltering Cell mode
100 %