AutoSave
кабинка-de10faa9a69338243b8266c3
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.

11 data sources

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

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

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)384
7Rows the engine returned no value for (measured)54
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-03 against the cabin at https://view.sumoffice.com/view/functions/, engine build f1 29487aa61. These are counts of the Status column on the sheets that follow, not of anything computed here.
22StatusFunctionsWhat it means
23computes362the engine's live value equals the independently computed reference
24computes (more digits)22same value, carried to more decimal places than the reference
25computes (volatile)5value changes on every recalculation; checked by property, not by value
26differs8the engine answers, and the answer does not match the reference
27no value yet54the engine returns nothing for this row
28
29Where 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.
30Why 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.
31What 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.
32Volatile 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)".
33Manual 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.
34Built2026-09-03 by tools/workbook/build.py
35
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.

ReadyInsertingDeletingFittingOpeningSortingFiltering Cell mode
100 %