Перейти к содержимому
FastOffice

Форматирование

Ширина колонок и высота строк, объединение ячеек, темы и шрифты, условное форматирование. Операций на странице: 8.

Применяет column width.

Request

Поле Тип TypeScript Обяз. Примечание из контракта
operation “apply_column_width” да
subsetId string да
sheetKey string да
col number | null нет
width number | null нет
columns ContractColumnWidth[] нет
defaultWidth number | null нет
viewport ViewportWindow | null нет
requestedBackend ComputeBackendKind | null нет

Success payload · apply_column_width

Поле Тип TypeScript Обяз. Примечание из контракта
operation “apply_column_width” да
subsetId string да
session ContractSubsetSessionInfo да
supportedSubset string да
delta DeltaSummary да
changedColumns number[] да
dirtyCellCount number да
currentSourceSaveReadiness ContractCurrentSourceSaveReadiness | null нет
activeSheet ContractActiveSheetMeta да
geometry ContractGeometrySubset да
recalcNeeded boolean да
viewport ViewportWindow да
previewCells ContractPreviewCell[] да
layoutMetrics ContractLayoutMetricsSubset да

Минимальный JSON-шаблон

{
"operation": "apply_column_width",
"subsetId": "<subsetId>",
"sheetKey": "<sheetPath>",
"requestedBackend": "native-desktop"
}

Применяет conditional formatting rules.

Request

Поле Тип TypeScript Обяз. Примечание из контракта
operation “apply_conditional_formatting_rules” да
subsetId string да
sheetKey string да
rules ContractConditionalRule[] да
viewport ViewportWindow | null нет
requestedBackend ComputeBackendKind | null нет

Success payload · apply_conditional_formatting_rules

Поле Тип TypeScript Обяз. Примечание из контракта
operation “apply_conditional_formatting_rules” да
subsetId string да
session ContractSubsetSessionInfo да
supportedSubset string да
delta DeltaSummary да
rules ContractConditionalRule[] да
preservedUnsupportedRuleBlockCount number да
activeSheet ContractActiveSheetMeta да
geometry ContractGeometrySubset да
recalcNeeded boolean да
viewport ViewportWindow да
previewCells ContractPreviewCell[] да

Минимальный JSON-шаблон

{
"operation": "apply_conditional_formatting_rules",
"subsetId": "<subsetId>",
"sheetKey": "<sheetPath>",
"rules": [],
"requestedBackend": "native-desktop"
}

Применяет merge cells.

Request

Поле Тип TypeScript Обяз. Примечание из контракта
operation “apply_merge_cells” да
subsetId string да
sheetKey string да
range CellRange да
merge boolean да
mode ContractMergeCellsMode | null нет
viewport ViewportWindow | null нет
requestedBackend ComputeBackendKind | null нет

Success payload · apply_merge_cells

Поле Тип TypeScript Обяз. Примечание из контракта
operation “apply_merge_cells” да
subsetId string да
session ContractSubsetSessionInfo да
supportedSubset string да
delta DeltaSummary да
merge boolean да
mode ContractMergeCellsMode да
mergeRef string | null нет
mergeRefs string[] да
changedMerges string[] да
removedMerges string[] да
dirtyCellCount number да
currentSourceSaveReadiness ContractCurrentSourceSaveReadiness | null нет
activeSheet ContractActiveSheetMeta да
geometry ContractGeometrySubset да
recalcNeeded boolean да
viewport ViewportWindow да
previewCells ContractPreviewCell[] да
layoutMetrics ContractLayoutMetricsSubset да

Минимальный JSON-шаблон

{
"operation": "apply_merge_cells",
"subsetId": "<subsetId>",
"sheetKey": "<sheetPath>",
"range": "<CellRange>",
"merge": false,
"requestedBackend": "native-desktop"
}

Применяет row height.

Request

Поле Тип TypeScript Обяз. Примечание из контракта
operation “apply_row_height” да
subsetId string да
sheetKey string да
row number | null нет
height number | null нет
rows ContractRowHeight[] нет
defaultHeight number | null нет
viewport ViewportWindow | null нет
requestedBackend ComputeBackendKind | null нет

Success payload · apply_row_height

Поле Тип TypeScript Обяз. Примечание из контракта
operation “apply_row_height” да
subsetId string да
session ContractSubsetSessionInfo да
supportedSubset string да
delta DeltaSummary да
changedRows number[] да
dirtyCellCount number да
currentSourceSaveReadiness ContractCurrentSourceSaveReadiness | null нет
activeSheet ContractActiveSheetMeta да
geometry ContractGeometrySubset да
recalcNeeded boolean да
viewport ViewportWindow да
previewCells ContractPreviewCell[] да
layoutMetrics ContractLayoutMetricsSubset да

Минимальный JSON-шаблон

{
"operation": "apply_row_height",
"subsetId": "<subsetId>",
"sheetKey": "<sheetPath>",
"requestedBackend": "native-desktop"
}

Применяет theme fonts patch.

Request

Поле Тип TypeScript Обяз. Примечание из контракта
operation “apply_theme_fonts_patch” да
subsetId string да
patch ContractApplyThemeFontsPatch да
requestedBackend ComputeBackendKind | null нет

Success payload · apply_theme_fonts_patch

Поле Тип TypeScript Обяз. Примечание из контракта
operation “apply_theme_fonts_patch” да
subsetId string да
major string да
minor string да
applied boolean да

Минимальный JSON-шаблон

{
"operation": "apply_theme_fonts_patch",
"subsetId": "<subsetId>",
"patch": "<ContractApplyThemeFontsPatch>",
"requestedBackend": "native-desktop"
}

Применяет workbook theme.

Request

Поле Тип TypeScript Обяз. Примечание из контракта
operation “apply_workbook_theme” да
subsetId string да
presetId string да Id from the shared packages/registry/theme-presets.json catalog (full theme, colours + fonts) — or, when colorsOnly is true, from the colour-only packages/registry/theme-color-sets.json catalog (Page Layout → Colors, #401).
colorsOnly boolean нет #401: apply ONLY the Theme Color Set (rewrites <a:clrScheme>, leaves <a:fontScheme> untouched). Absent/false = the full Themes behaviour (#185, colours + fonts).
customColors ContractWorkbookThemeColorScheme | null нет CLR-003: Rust-owned custom 12-slot scheme; supersedes presetId.
previewOnly boolean нет Reparse and project from a detached Rust session without mutation.
expectedRevision number | null нет Required for custom Save; ignored by a read-only preview.
readOnly boolean нет
protected boolean нет
viewport ViewportWindow | null нет
requestedBackend ComputeBackendKind | null нет

Success payload · apply_workbook_theme

Поле Тип TypeScript Обяз. Примечание из контракта
operation “apply_workbook_theme” да #185: shape-compatible with open_workbook_subset/apply_cell_edits’s core preview fields (subsetId/activeSheet/geometry/viewport/previewCells/ layoutMetrics/recalcNeeded/workbookSheets) so the shell repaints through the SAME __F1RefreshWorkbookWindowFromHost path.
subsetId string да
session ContractSubsetSessionInfo да
appliedPresetId string да
createdThemePart boolean да
previewOnly boolean нет
activeSheet ContractActiveSheetMeta да
workbookSheets ContractWorkbookSheetMeta[] да
geometry ContractGeometrySubset да
recalcNeeded boolean да
viewport ViewportWindow да
previewCells ContractPreviewCell[] да
layoutMetrics ContractLayoutMetricsSubset нет
themeColorPalette string[] нет Same shape/meaning as OpenWorkbookSubset’s themeColorPalette — the workbook’s resolved 12-slot theme colour palette AFTER this apply, so theme-following surfaces (Excel Table styles, #185) can recolour LIVE from the SAME palette the engine just resolved, without a save -> reopen round trip.
workbookHistory ContractWorkbookHistoryProjection | null нет

Минимальный JSON-шаблон

{
"operation": "apply_workbook_theme",
"subsetId": "<subsetId>",
"presetId": "<string>",
"requestedBackend": "native-desktop"
}

Управляет conditional formatting rules.

Request

Поле Тип TypeScript Обяз. Примечание из контракта
operation “manage_conditional_formatting_rules” да
subsetId string да
sheetKey string да
action ContractConditionalFormattingManagerAction да
expectedRevision number | null нет
readOnly boolean нет
protected boolean нет
viewport ViewportWindow | null нет
requestedBackend ComputeBackendKind | null нет

Success payload · manage_conditional_formatting_rules

Поле Тип TypeScript Обяз. Примечание из контракта
operation “manage_conditional_formatting_rules” да
subsetId string да
session ContractSubsetSessionInfo да
action “inspect” | “apply” да
rules ContractConditionalRule[] да
opaqueRules ContractConditionalFormattingOpaqueRule[] да
authority ContractConditionalFormattingManagerAuthority да
didChange boolean да
workbookHistory ContractWorkbookHistoryProjection да
activeSheet ContractActiveSheetMeta да
geometry ContractGeometrySubset да
recalcNeeded boolean да
viewport ViewportWindow да
previewCells ContractPreviewCell[] да

Минимальный JSON-шаблон

{
"operation": "manage_conditional_formatting_rules",
"subsetId": "<subsetId>",
"sheetKey": "<sheetPath>",
"action": "<ContractConditionalFormattingManagerAction>",
"requestedBackend": "native-desktop"
}

Вставляет conditional formatting rules.

Request

Поле Тип TypeScript Обяз. Примечание из контракта
operation “paste_conditional_formatting_rules” да
subsetId string да
clipboardId string да
target CellRange да
viewport ViewportWindow | null нет
requestedBackend ComputeBackendKind | null нет

Success payload · apply_conditional_formatting_rules

Поле Тип TypeScript Обяз. Примечание из контракта
operation “apply_conditional_formatting_rules” да
subsetId string да
session ContractSubsetSessionInfo да
supportedSubset string да
delta DeltaSummary да
rules ContractConditionalRule[] да
preservedUnsupportedRuleBlockCount number да
activeSheet ContractActiveSheetMeta да
geometry ContractGeometrySubset да
recalcNeeded boolean да
viewport ViewportWindow да
previewCells ContractPreviewCell[] да

Минимальный JSON-шаблон

{
"operation": "paste_conditional_formatting_rules",
"subsetId": "<subsetId>",
"clipboardId": "<string>",
"target": "<CellRange>",
"requestedBackend": "native-desktop"
}

Ассистент документации

Ответ собран из документации и может быть неточным — сверяйтесь с источниками.