Данные, фильтры и объекты

Фильтры, промежуточные итоги, очистка данных, таблицы, импорт текста, проверка данных, срезы и элементы управления. Операций на странице: 16.

Операции на этой странице — 16

advanced_filter_plan
apply_outline_subtotal
apply_range_filter
commit_delimited_text_import
data_cleanup
evaluate_data_validation_input
finalize_object_selection_pane_package
form_controls
mutate_table_model
open_document_object_creation
read_data_validation_rules
set_data_validation_rules
set_range_filter_enabled
slicer_timeline
sort_filter_index_update
update_table_model

advanced_filter_plan

Операция advanced filter plan.

Request

Поле	Тип TypeScript	Обяз.
operation	“advanced_filter_plan”	да
subsetId	string	да
action	ContractAdvancedFilterAction	да
listRange	CellRange	да
criteriaRange	CellRange \| null	нет
copyToRange	CellRange \| null	нет
uniqueRecordsOnly	boolean	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · advanced_filter_plan

Поле	Тип TypeScript	Обяз.
operation	“advanced_filter_plan”	да
matchedRows	number[]	да
hiddenRows	number[]	да
projectionCells	ContractAdvancedFilterProjectedCell[]	да
outputRange	CellRange \| null	нет
sourceRowCount	number	да
resultRowCount	number	да
criteriaRowCount	number	да
uniqueRecordsOnly	boolean	да
formulaCriteriaUsed	boolean	да

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

{
  "operation": "advanced_filter_plan",
  "subsetId": "<subsetId>",
  "action": "<ContractAdvancedFilterAction>",
  "listRange": "<CellRange>",
  "requestedBackend": "native-desktop"
}

apply_outline_subtotal

Применяет outline subtotal.

Request

Поле	Тип TypeScript	Обяз.
operation	“apply_outline_subtotal”	да
subsetId	string	да
range	CellRange	да
action	ContractOutlineSubtotalAction	да
axis	ContractOutlineAxis \| null	нет
level	number \| null	нет
subtotal	ContractSubtotalOptions \| null	нет
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · apply_outline_subtotal

Поле	Тип TypeScript	Обяз.
operation	“apply_outline_subtotal”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
supportedSubset	string	да
delta	DeltaSummary	да
action	ContractOutlineSubtotalAction	да
didChange	boolean	да
outlineState	ContractOutlineSubtotalState	да
layoutMetrics	ContractLayoutMetricsSubset	да
activeSheet	ContractActiveSheetMeta	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да

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

{
  "operation": "apply_outline_subtotal",
  "subsetId": "<subsetId>",
  "range": "<CellRange>",
  "action": "<ContractOutlineSubtotalAction>",
  "requestedBackend": "native-desktop"
}

apply_range_filter

Применяет range filter.

Request

Поле	Тип TypeScript	Обяз.
operation	“apply_range_filter”	да
subsetId	string	да
range	CellRange	да
action	ContractRangeFilterAction	нет
targetColumn	number \| null	нет
criteria	ContractRangeFilterColumnCriteria[]	нет
headerPolicy	ContractRemoveDuplicatesHeaderPolicy	нет
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · apply_range_filter

Поле	Тип TypeScript	Обяз.
operation	“apply_range_filter”	да
subsetId	string	да
delta	DeltaSummary	да
action	ContractRangeFilterAction	да
criteria	ContractRangeFilterColumnCriteria[]	да
hiddenRows	number[]	да
manualHiddenRows	number[]	да
filterHiddenRows	number[]	да
hiddenRowCount	number	да
visibleRowCount	number	да
workbookHistory	ContractWorkbookHistoryProjection	да
recalcNeeded	boolean	да

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

{
  "operation": "apply_range_filter",
  "subsetId": "<subsetId>",
  "range": "<CellRange>",
  "requestedBackend": "native-desktop"
}

commit_delimited_text_import

Фиксирует delimited text import.

Request

Поле	Тип TypeScript	Обяз.
operation	“commit_delimited_text_import”	да
subsetId	string	да
edits	CellInputEdit[]	да
destination	ContractDelimitedImportDestination	да
expectedRevision	number \| null	нет
readOnly	boolean	нет
cancelled	boolean	нет
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · commit_delimited_text_import

Поле	Тип TypeScript	Обяз.
operation	“commit_delimited_text_import”	да
subsetId	string	да
createdSheet	boolean	да
sheetKey	string	да
appliedEditCount	number	да
mutationCount	number	да
workbookHistory	ContractWorkbookHistoryProjection	да
projection	ComputeResponsePayload	да

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

{
  "operation": "commit_delimited_text_import",
  "subsetId": "<subsetId>",
  "edits": [],
  "destination": "<ContractDelimitedImportDestination>",
  "requestedBackend": "native-desktop"
}

data_cleanup

Операция data cleanup.

Request

Поле	Тип TypeScript	Обяз.	Примечание из контракта
operation	“data_cleanup”	да
subsetId	string	да
action	ContractDataCleanupAction	да
intent	ContractDataCleanupIntent	да
consecutiveDelimitersAsOne	boolean	нет	Collapse adjacent delimiters into one separator for Text to Columns.
locale	string \| null	нет	Locale used by Rust-owned General value classification (for example ru-RU decimal comma).
expectedRevision	number \| null	нет	Central workbook revision observed by Preview; Apply refuses a mismatch before mutation.
previewToken	string \| null	нет
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · data_cleanup

Поле	Тип TypeScript	Обяз.
operation	“data_cleanup”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
delta	DeltaSummary	да
kind	“text_to_columns” \| “remove_duplicates” \| “remove_duplicates_copy”	да
previewToken	string	да
applied	boolean	да
sourceRange	CellRange	да
outputRange	CellRange	да
duplicateCount	number	да
remainingCount	number	да
headerRowCount	number	да
resultRowCount	number	да
resultColCount	number	да
copyOutput	boolean	да
duplicateRowSpans	ContractDataCleanupRowSpan[]	да
audit	ContractDataCleanupAudit	да
tableName	string \| null	нет
tableRef	string \| null	нет
tableDataBodyRef	string \| null	нет
previewRows	ContractDataCleanupPreviewRow[]	да
workbookHistory	ContractWorkbookHistoryProjection	да
changedKeys	string[]	да
dirtyCellCount	number	да
activeSheet	ContractActiveSheetMeta	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да

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

{
  "operation": "data_cleanup",
  "subsetId": "<subsetId>",
  "action": "<ContractDataCleanupAction>",
  "intent": "<ContractDataCleanupIntent>",
  "requestedBackend": "native-desktop"
}

evaluate_data_validation_input

Вычисляет/оценивает data validation input.

Request

Поле	Тип TypeScript	Обяз.	Примечание из контракта
operation	“evaluate_data_validation_input”	да
subsetId	string	да
inputs	ContractDataValidationRawInput[]	да
companionEdits	CellInputEdit[]	нет
programmaticEdits	CellInputEdit[]	нет	Rust expands fill-series/drag-fill before judging every destination.
commit	boolean	нет
expectedRevision	number \| null	нет	OPTIONAL optimistic guard for commit: true. A mismatch refuses with apply-cell-edits-stale-revision before cell/history/revision mutation. The read-only judge (commit: false) does not become a mutation.
continuation	ContractDataValidationContinuation \| null	нет
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · evaluate_data_validation_input

Поле	Тип TypeScript	Обяз.
operation	“evaluate_data_validation_input”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
verdict	ContractDataValidationVerdictKind	да
verdicts	ContractDataValidationVerdict[]	да
continuationToken	string \| null	нет
allowedDecisions	ContractDataValidationDecision[]	нет
committed	ComputeResponsePayload \| null	нет

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

{
  "operation": "evaluate_data_validation_input",
  "subsetId": "<subsetId>",
  "inputs": [],
  "requestedBackend": "native-desktop"
}

finalize_object_selection_pane_package

Завершает object selection pane package.

Request

Поле	Тип TypeScript	Обяз.
operation	“finalize_object_selection_pane_package”	да
subsetId	string	да
sourcePackageBytesBase64	string	да
candidatePackageBytesBase64	string	да
objectProtectionMutations	ContractSheetObjectMutationIntent[]	да
commands	ContractObjectSelectionPanePackageCommand[]	да
drawingTextEdits	ContractDrawingTextEditSemantics[]	да
adoptCurrentSource	boolean	да
requestedBackend	ComputeBackendKind \| null	нет

Success payload · finalize_object_selection_pane_package

Поле	Тип TypeScript	Обяз.
operation	“finalize_object_selection_pane_package”	да
packageBytesBase64	string	да
byteCount	number	да
mutationCount	number	да
authoritativeRevision	number	да
validatedDrawingTextCount	number	да
adoptedCurrentSource	boolean	да

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

{
  "operation": "finalize_object_selection_pane_package",
  "subsetId": "<subsetId>",
  "sourcePackageBytesBase64": "<base64>",
  "candidatePackageBytesBase64": "<base64>",
  "objectProtectionMutations": [],
  "commands": [],
  "drawingTextEdits": [],
  "adoptCurrentSource": false,
  "requestedBackend": "native-desktop"
}

form_controls

Операция form controls.

Request

Поле	Тип TypeScript	Обяз.
operation	“form_controls”	да
subsetId	string	да
intent	ContractFormControlsAction	да
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · form_controls

Поле	Тип TypeScript	Обяз.
operation	“form_controls”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
delta	DeltaSummary	да
action	string	да
status	string	да
controls	ContractFormControlView[]	да
objectInventory	ContractWorkbookObjectInventoryEntry[]	да
linkedCellWrite	ContractFormControlLinkedCellWrite \| null	нет
changedKeys	string[]	да
dirtyCellCount	number	да
activeSheet	ContractActiveSheetMeta	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да

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

{
  "operation": "form_controls",
  "subsetId": "<subsetId>",
  "intent": "<ContractFormControlsAction>",
  "requestedBackend": "native-desktop"
}

mutate_table_model

Изменяет table model.

Request

Поле	Тип TypeScript	Обяз.
operation	“mutate_table_model”	да
subsetId	string	да
mutation	ContractTableModelMutation	да
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · mutate_table_model

Поле	Тип TypeScript	Обяз.
operation	“mutate_table_model”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
delta	DeltaSummary	да
action	string	да
tableMetadata	ContractTableMetadataProjection	да
workbookTableMetadata	ContractTableMetadataProjection	да
activeSheet	ContractActiveSheetMeta	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да
workbookHistory	ContractWorkbookHistoryProjection	да

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

{
  "operation": "mutate_table_model",
  "subsetId": "<subsetId>",
  "mutation": "<ContractTableModelMutation>",
  "requestedBackend": "native-desktop"
}

open_document_object_creation

Открывает document object creation.

Request

Поле	Тип TypeScript	Обяз.
operation	“open_document_object_creation”	да
subsetId	string	да
sheetPath	string	да
creation	ContractOpenDocumentObjectCreation	да
readOnly	boolean	нет
expectedRevision	number \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · open_document_object_creation

Поле	Тип TypeScript	Обяз.
operation	“open_document_object_creation”	да
subsetId	string	да
createdObject	ContractCreatedDocumentObject	да
byteCount	number	да
dirty	boolean	да
undoDepth	number	да
redoDepth	number	да
authoritativeRevision	number	да
historyOwner	“drawing_objects”	да

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

{
  "operation": "open_document_object_creation",
  "subsetId": "<subsetId>",
  "sheetPath": "<sheetPath>",
  "creation": "<ContractOpenDocumentObjectCreation>",
  "requestedBackend": "native-desktop"
}

read_data_validation_rules

Читает data validation rules.

Request

Поле	Тип TypeScript	Обяз.
operation	“read_data_validation_rules”	да
subsetId	string	да
sheetKey	string	да
range	CellRange \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · read_data_validation_rules

Поле	Тип TypeScript	Обяз.
operation	“read_data_validation_rules”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
sheetKey	string	да
dataValidationMetadata	ContractDataValidationMetadata	да

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

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

set_data_validation_rules

Устанавливает data validation rules.

Request

Поле	Тип TypeScript	Обяз.	Примечание из контракта
operation	“set_data_validation_rules”	да
subsetId	string	да
sheetKey	string	да
rules	ContractDataValidationRuleIntent[]	да
sourceLocale	string \| null	нет	Request-local locale used by Rust to validate list Source syntax.
expectedRevision	number \| null	нет	Refuses stale rule authoring before XML, dirty, history, or revision mutation.
requestedBackend	ComputeBackendKind \| null	нет

Success payload · set_data_validation_rules

Поле	Тип TypeScript	Обяз.
operation	“set_data_validation_rules”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
sheetKey	string	да
appliedRuleCount	number	да
dataValidationMetadata	ContractDataValidationMetadata	да
workbookHistory	ContractWorkbookHistoryProjection	да

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

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

set_range_filter_enabled

Устанавливает range filter enabled.

Request

Поле	Тип TypeScript	Обяз.	Примечание из контракта
operation	“set_range_filter_enabled”	да	Excel’s Data ▸ Filter toggle: arm/remove the selected table or worksheet AutoFilter.
subsetId	string	да
range	CellRange	да
enabled	boolean	да
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · set_range_filter_enabled

Поле	Тип TypeScript	Обяз.
operation	“set_range_filter_enabled”	да
subsetId	string	да
delta	DeltaSummary	да
autoFilterRef	string	нет
unhiddenRowCount	number	да
targetKind	“range” \| “table”	да
tableMetadata	ContractTableMetadataProjection	да
workbookTableMetadata	ContractTableMetadataProjection	да
workbookHistory	ContractWorkbookHistoryProjection	да
recalcNeeded	boolean	да

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

{
  "operation": "set_range_filter_enabled",
  "subsetId": "<subsetId>",
  "range": "<CellRange>",
  "enabled": false,
  "requestedBackend": "native-desktop"
}

slicer_timeline

Операция slicer timeline.

Request

Поле	Тип TypeScript	Обяз.
operation	“slicer_timeline”	да
subsetId	string	да
intent	ContractSlicerTimelineAction	да
expectedCacheGeneration	number \| null	нет
requestGeneration	number \| null	нет
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · slicer_timeline

Поле	Тип TypeScript	Обяз.
operation	“slicer_timeline”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
delta	DeltaSummary	да
action	string	да
status	string	да
controls	ContractSlicerTimelineControlView[]	да
changedRows	number[]	да
hiddenRows	number[]	да
refreshTargets	string[]	да
connectedTargets	ContractSlicerTimelineTargetView[]	да
filterConnections	ContractPivotFilterConnectionView[]	да
refreshStatus	ContractPivotRefreshStatusView \| null	нет
dirtyCellCount	number	да
activeSheet	ContractActiveSheetMeta	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да

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

{
  "operation": "slicer_timeline",
  "subsetId": "<subsetId>",
  "intent": "<ContractSlicerTimelineAction>",
  "requestedBackend": "native-desktop"
}

sort_filter_index_update

Сортирует filter index update.

Request

Поле	Тип TypeScript	Обяз.
operation	“sort_filter_index_update”	да
subsetId	string	да
range	CellRange	да
requestedBackend	ComputeBackendKind \| null	нет

Success payload · sort_filter_index_update

Поле	Тип TypeScript	Обяз.
operation	“sort_filter_index_update”	да
delta	DeltaSummary	да
indexVersion	number	да

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

{
  "operation": "sort_filter_index_update",
  "subsetId": "<subsetId>",
  "range": "<CellRange>",
  "requestedBackend": "native-desktop"
}

update_table_model

Обновляет table model.

Request

Поле	Тип TypeScript	Обяз.
operation	“update_table_model”	да
subsetId	string	да
table	ContractTableMetadataEntry	да
requestedBackend	ComputeBackendKind \| null	нет

Success payload · update_table_model

Поле	Тип TypeScript	Обяз.
operation	“update_table_model”	да
subsetId	string	да
stableId	string	да
tableCount	number	да
tableMetadata	ContractTableMetadataProjection	да
workbookTableMetadata	ContractTableMetadataProjection	да

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

{
  "operation": "update_table_model",
  "subsetId": "<subsetId>",
  "table": "<ContractTableMetadataEntry>",
  "requestedBackend": "native-desktop"
}