Листы и печать · часть 2

Жизненный цикл листов, копирование между книгами, видимость, закрепление областей, параметры страницы и разбиение на страницы. Операций на странице: 11.

Домен разбит на несколько страниц: часть 1 · часть 2.

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

preview_chart_sheet_print
redo_sheet_lifecycle_bounded
rename_sheet_bounded
reorder_sheet_bounded
set_chart_sheet_print_bounded
set_sheet_code_name_bounded
set_sheet_right_to_left_bounded
set_sheet_tab_color_bounded
set_sheet_visibility_bounded
undo_delete_sheet_bounded
undo_sheet_lifecycle_bounded

preview_chart_sheet_print

Формирует preview для chart sheet print.

Request

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

Success payload · preview_chart_sheet_print

Поле	Тип TypeScript	Обяз.
operation	“preview_chart_sheet_print”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
delta	DeltaSummary	да
chartSheet	ContractActiveSheetMeta	да
workbookSheets	ContractWorkbookSheetMeta[]	да
settings	ContractChartSheetPrintSettings	да
preview	ContractChartSheetPrintPreview	да
nativeChartsheetClaim	“live_verified”	да
printPreviewClaim	“live_verified”	да
macroSheetParityClaim	“no”	да
dialogSheetParityClaim	“no”	да

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

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

redo_sheet_lifecycle_bounded

Повторяет sheet lifecycle bounded.

Request

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

Success payload · redo_sheet_lifecycle_bounded

Поле	Тип TypeScript	Обяз.
operation	“redo_sheet_lifecycle_bounded”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
supportedSubset	string	да
delta	DeltaSummary	да
action	string	да
sheetName	string	да
activeSheet	ContractActiveSheetMeta	да
sheetCount	number	да
workbookSheets	ContractWorkbookSheetMeta[]	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да
layoutMetrics	ContractLayoutMetricsSubset \| null	нет
sheetLifecycleRedoClaim	“live_verified”	да
redoScope	“last_undone_current_workbook_sheet_move_or_copy_snapshot_current_session”	да

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

{
  "operation": "redo_sheet_lifecycle_bounded",
  "subsetId": "<subsetId>",
  "requestedBackend": "native-desktop"
}

rename_sheet_bounded

Переименовывает sheet bounded.

Request

Поле	Тип TypeScript	Обяз.
operation	“rename_sheet_bounded”	да
subsetId	string	да
sheetKey	string	да
newName	string	да
expectedRevision	number \| null	нет
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · rename_sheet_bounded

Поле	Тип TypeScript	Обяз.
operation	“rename_sheet_bounded”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
supportedSubset	string	да
delta	DeltaSummary	да
renamedSheet	ContractActiveSheetMeta	да
activeSheet	ContractActiveSheetMeta	да
sheetCount	number	да
workbookSheets	ContractWorkbookSheetMeta[]	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да
layoutMetrics	ContractLayoutMetricsSubset \| null	нет
workbookHistory	ContractWorkbookHistoryProjection	да
sheetRenameClaim	“live_verified”	да
formulaReferenceAutoUpdateClaim	“live_verified”	да
formulaReferenceBehavior	“updated_truthfully”	да

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

{
  "operation": "rename_sheet_bounded",
  "subsetId": "<subsetId>",
  "sheetKey": "<sheetPath>",
  "newName": "<string>",
  "requestedBackend": "native-desktop"
}

reorder_sheet_bounded

Меняет порядок sheet bounded.

Request

Поле	Тип TypeScript	Обяз.
operation	“reorder_sheet_bounded”	да
subsetId	string	да
sheetKey	string	да
targetIndex	number	да
expectedRevision	number \| null	нет
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · reorder_sheet_bounded

Поле	Тип TypeScript	Обяз.
operation	“reorder_sheet_bounded”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
supportedSubset	string	да
delta	DeltaSummary	да
movedSheet	ContractActiveSheetMeta	да
previousIndex	number	да
targetIndex	number	да
activeSheet	ContractActiveSheetMeta	да
sheetCount	number	да
workbookSheets	ContractWorkbookSheetMeta[]	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да
layoutMetrics	ContractLayoutMetricsSubset \| null	нет
workbookHistory	ContractWorkbookHistoryProjection	да
sheetReorderClaim	“live_verified”	да
reorderScope	“same_workbook_sheet_order_only”	да
sheetIdentityPreservedAfterReorder	true	да
formulaReferencePositionRewriteClaim	“no”	да
formulaReferencesRemainIdentityBased	true	да
sheetCopyClaim	“live_verified”	да

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

{
  "operation": "reorder_sheet_bounded",
  "subsetId": "<subsetId>",
  "sheetKey": "<sheetPath>",
  "targetIndex": 0,
  "requestedBackend": "native-desktop"
}

set_chart_sheet_print_bounded

Устанавливает chart sheet print bounded.

Request

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

Success payload · set_chart_sheet_print_bounded

Поле	Тип TypeScript	Обяз.
operation	“set_chart_sheet_print_bounded”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
delta	DeltaSummary	да
didChange	boolean	да
chartSheet	ContractActiveSheetMeta	да
workbookSheets	ContractWorkbookSheetMeta[]	да
settings	ContractChartSheetPrintSettings	да
preview	ContractChartSheetPrintPreview	да
nativeChartsheetClaim	“live_verified”	да
printPreviewClaim	“live_verified”	да
macroSheetParityClaim	“no”	да
dialogSheetParityClaim	“no”	да

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

{
  "operation": "set_chart_sheet_print_bounded",
  "subsetId": "<subsetId>",
  "sheetKey": "<sheetPath>",
  "settings": "<ContractChartSheetPrintSettings>",
  "requestedBackend": "native-desktop"
}

set_sheet_code_name_bounded

Устанавливает sheet code name bounded.

Request

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

Success payload · set_sheet_code_name_bounded

Поле	Тип TypeScript	Обяз.
operation	“set_sheet_code_name_bounded”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
supportedSubset	string	да
delta	DeltaSummary	да
changedSheet	ContractActiveSheetMeta	да
previousCodeName	string \| null	да
codeName	string	да
activeSheet	ContractActiveSheetMeta	да
sheetCount	number	да
workbookSheets	ContractWorkbookSheetMeta[]	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да
layoutMetrics	ContractLayoutMetricsSubset \| null	нет
workbookHistory	ContractWorkbookHistoryProjection	да
sheetCodeNameClaim	“live_verified”	да
codeNameScope	“same_workbook_worksheet_sheetPr_codeName”	да

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

{
  "operation": "set_sheet_code_name_bounded",
  "subsetId": "<subsetId>",
  "sheetKey": "<sheetPath>",
  "codeName": "<string>",
  "requestedBackend": "native-desktop"
}

set_sheet_right_to_left_bounded

Устанавливает sheet right to left bounded.

Request

Поле	Тип TypeScript	Обяз.
operation	“set_sheet_right_to_left_bounded”	да
subsetId	string	да
sheetKey	string	да
rightToLeft	boolean	да
expectedRevision	number \| null	нет
viewport	ViewportWindow \| null	нет
requestedBackend	ComputeBackendKind \| null	нет

Success payload · set_sheet_right_to_left_bounded

Поле	Тип TypeScript	Обяз.
operation	“set_sheet_right_to_left_bounded”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
supportedSubset	string	да
delta	DeltaSummary	да
changedSheet	ContractActiveSheetMeta	да
previousRightToLeft	boolean \| null	да
rightToLeft	boolean	да
activeSheet	ContractActiveSheetMeta	да
sheetCount	number	да
workbookSheets	ContractWorkbookSheetMeta[]	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да
layoutMetrics	ContractLayoutMetricsSubset \| null	нет
workbookHistory	ContractWorkbookHistoryProjection	да
sheetRightToLeftClaim	“live_verified”	да
rightToLeftScope	“same_workbook_worksheet_sheetView_rightToLeft”	да

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

{
  "operation": "set_sheet_right_to_left_bounded",
  "subsetId": "<subsetId>",
  "sheetKey": "<sheetPath>",
  "rightToLeft": false,
  "requestedBackend": "native-desktop"
}

set_sheet_tab_color_bounded

Устанавливает sheet tab color bounded.

Request

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

Success payload · set_sheet_tab_color_bounded

Поле	Тип TypeScript	Обяз.
operation	“set_sheet_tab_color_bounded”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
supportedSubset	string	да
delta	DeltaSummary	да
changedSheet	ContractActiveSheetMeta	да
previousTabColorRgb	string \| null	да
tabColorRgb	string \| null	да
activeSheet	ContractActiveSheetMeta	да
sheetCount	number	да
workbookSheets	ContractWorkbookSheetMeta[]	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да
layoutMetrics	ContractLayoutMetricsSubset \| null	нет
workbookHistory	ContractWorkbookHistoryProjection	да
sheetTabColorClaim	“live_verified”	да
tabColorScope	“same_workbook_worksheet_sheetPr_tabColor_rgb”	да

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

{
  "operation": "set_sheet_tab_color_bounded",
  "subsetId": "<subsetId>",
  "sheetKey": "<sheetPath>",
  "rgb": "<string>",
  "requestedBackend": "native-desktop"
}

set_sheet_visibility_bounded

Устанавливает sheet visibility bounded.

Request

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

Success payload · set_sheet_visibility_bounded

Поле	Тип TypeScript	Обяз.
operation	“set_sheet_visibility_bounded”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
supportedSubset	string	да
delta	DeltaSummary	да
changedSheet	ContractActiveSheetMeta	да
previousVisibilityState	ContractSheetVisibilityState	да
visibilityState	ContractSheetVisibilityState	да
activeSheet	ContractActiveSheetMeta	да
sheetCount	number	да
workbookSheets	ContractWorkbookSheetMeta[]	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да
layoutMetrics	ContractLayoutMetricsSubset \| null	нет
workbookHistory	ContractWorkbookHistoryProjection	да
sheetVisibilityClaim	“live_verified”	да
visibilityScope	“same_workbook_visible_hidden_very_hidden”	да
veryHiddenClaim	“live_verified”	да
lastVisibleSheetHideClaim	“blocked_truthful_boundary”	да

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

{
  "operation": "set_sheet_visibility_bounded",
  "subsetId": "<subsetId>",
  "sheetKey": "<sheetPath>",
  "visibilityState": "<ContractSheetVisibilityState>",
  "requestedBackend": "native-desktop"
}

undo_delete_sheet_bounded

Отменяет delete sheet bounded.

Request

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

Success payload · undo_delete_sheet_bounded

Поле	Тип TypeScript	Обяз.
operation	“undo_delete_sheet_bounded”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
supportedSubset	string	да
delta	DeltaSummary	да
restoredSheet	ContractActiveSheetMeta	да
restoredIndex	number	да
activeSheet	ContractActiveSheetMeta	да
sheetCount	number	да
workbookSheets	ContractWorkbookSheetMeta[]	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да
layoutMetrics	ContractLayoutMetricsSubset \| null	нет
sheetUndoDeleteClaim	“live_verified”	да
undoDeleteScope	“last_unreferenced_bounded_sheet_current_session”	да
undoDeletePersistenceClaim	“save_reopen_after_restore_live”	да
formulaReferenceDeleteRewriteClaim	“no”	да

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

{
  "operation": "undo_delete_sheet_bounded",
  "subsetId": "<subsetId>",
  "requestedBackend": "native-desktop"
}

undo_sheet_lifecycle_bounded

Отменяет sheet lifecycle bounded.

Request

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

Success payload · undo_sheet_lifecycle_bounded

Поле	Тип TypeScript	Обяз.
operation	“undo_sheet_lifecycle_bounded”	да
subsetId	string	да
session	ContractSubsetSessionInfo	да
supportedSubset	string	да
delta	DeltaSummary	да
action	string	да
sheetName	string	да
activeSheet	ContractActiveSheetMeta	да
sheetCount	number	да
workbookSheets	ContractWorkbookSheetMeta[]	да
geometry	ContractGeometrySubset	да
recalcNeeded	boolean	да
viewport	ViewportWindow	да
previewCells	ContractPreviewCell[]	да
layoutMetrics	ContractLayoutMetricsSubset \| null	нет
sheetLifecycleUndoClaim	“live_verified”	да
undoScope	“last_current_workbook_sheet_move_or_copy_snapshot_current_session”	да

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

{
  "operation": "undo_sheet_lifecycle_bounded",
  "subsetId": "<subsetId>",
  "requestedBackend": "native-desktop"
}