Типы: диаграммы и графика

Определения имён из колонки «Тип TypeScript» на страницах операций.

Другие темы словаря: сеанс, книга и листы · ячейки и диапазоны · формулы и вычисления · форматирование · данные и объекты листа · сводные таблицы · диаграммы и графика · печать и разметка страницы · Power Query · VBA и макросы · защита и рецензирование · общие и служебные.

Типы на этой странице — 92

• ContractChartAreaFormatting
• ContractChartAxisFormatting
• ContractChartAxisId
• ContractChartBoundedFamily
• ContractChartBoxWhiskerSettings
• ContractChartBubblePointIdentity
• ContractChartCapabilityRefusal
• ContractChartCustomErrorBarRange
• ContractChartDataLabelPosition
• ContractChartDataLabelsFormatting
• ContractChartDataTableFormatting
• ContractChartErrorBarDirection
• ContractChartErrorBarEndStyle
• ContractChartErrorBarKind
• ContractChartErrorBarsFormatting
• ContractChartFeatureCapability
• ContractChartFormatting
• ContractChartFormattingCapabilities
• ContractChartFunnelSettings
• ContractChartGeographyRegion
• ContractChartGeographySettings
• ContractChartHierarchyBlankPolicy
• ContractChartHierarchyErrorPolicy
• ContractChartHierarchyNode
• ContractChartHierarchySettings
• ContractChartHistogramBin
• ContractChartHistogramSettings
• ContractChartIntervalClosedSide
• ContractChartLegendFormatPosition
• ContractChartLegendPosition
• ContractChartLineDash
• ContractChartManualLayout
• ContractChartMarkerFormatting
• ContractChartMarkerStyle
• ContractChartMissingValuePolicy
• ContractChartModernFormatting
• ContractChartPayload
• ContractChartPointFormatting
• ContractChartQuartileMethod
• ContractChartSeries
• ContractChartSeriesErrorBarCapability
• ContractChartSeriesFormatting
• ContractChartSeriesType
• ContractChartShapeStyle
• ContractChartSheetOrientation
• ContractChartSheetPageMargins
• ContractChartSheetPrintPreview
• ContractChartSheetPrintSettings
• ContractChartStackMode
• ContractChartStatus
• ContractChartStockSeriesRole
• ContractChartStylePreset
• ContractChartSurfaceFormatting
• ContractChartSurfaceView3D
• ContractChartTemplateSelection
• ContractChartTemplateSource
• ContractChartThemeColorSlot
• ContractChartThemeReference
• ContractChartTrendlineFacts
• ContractChartTrendlineFormatting
• ContractChartTrendlineKind
• ContractChartTrendlinePoint
• ContractChartType
• ContractChartWaterfallPoint
• ContractChartWaterfallSettings
• ContractDataAnalysisChartPlan
• ContractDrawingObjectAction
• ContractDrawingObjectImageCrop
• ContractDrawingTextEditSemantics
• ContractImagePayload
• ContractOpenDocumentChartSeries
• ContractSparklineAction
• ContractSparklineFlags
• ContractSparklinePlanMode
• ContractSparklineProjectionEntry
• ContractSparklineStyle
• ContractSparklineType
• ContractXlsxChartCreationPatch
• ContractXlsxChartMutationPatch
• ContractXlsxChartObjectMovePatch
• ContractXlsxChartSeriesUpdatePatch
• ContractXlsxDrawingImageCreationPatch
• ContractXlsxDrawingObjectDeletionPatch
• ContractXlsxDrawingObjectGroupMemberPatch
• ContractXlsxDrawingObjectGroupPatch
• ContractXlsxDrawingObjectImageTransformPatch
• ContractXlsxDrawingObjectMetadataPatch
• ContractXlsxDrawingObjectMovePatch
• ContractXlsxDrawingObjectUngroupPatch
• ContractXlsxDrawingObjectZOrderPatch
• ContractXlsxShapeObjectPatch
• ContractXlsxShapeSheetPatch

ContractChartAreaFormatting

interface ContractChartAreaFormatting {
  style: ContractChartShapeStyle;
  layout?: ContractChartManualLayout | null;
}

ContractChartAxisFormatting

interface ContractChartAxisFormatting {
  axis: ContractChartAxisId;
  title?: string | null;
  visible: boolean;
  minimum?: number | null;
  maximum?: number | null;
  majorUnit?: number | null;
  minorUnit?: number | null;
  numberFormat?: string | null;
  logBase?: number | null;
  showMajorGridlines: boolean;
  showMinorGridlines: boolean;
}

ContractChartAxisId

type ContractChartAxisId = | "primary-category" | "primary-value" | "secondary-category" | "secondary-value";

ContractChartBoundedFamily

type ContractChartBoundedFamily =
  | "bubble"
  | "radar"
  | "radar-markers"
  | "radar-filled"
  | "surface"
  | "wireframe-surface"
  | "contour"
  | "wireframe-contour"
  | "stock-hlc"
  | "stock-ohlc"
  | "stock-volume-hlc"
  | "stock-volume-ohlc"
  | "histogram"
  | "pareto"
  | "waterfall"
  | "funnel"
  | "box-whisker"
  | "treemap"
  | "sunburst"
  | "map";

ContractChartBoxWhiskerSettings

interface ContractChartBoxWhiskerSettings {
  quartileMethod: ContractChartQuartileMethod;
  showMeanLine: boolean;
  showMeanMarker: boolean;
  showInnerPoints: boolean;
  showOutlierPoints: boolean;
  readonly summaries: ReadonlyArray<{
    seriesIndex: number;
    firstQuartile: number;
    median: number;
    thirdQuartile: number;
    mean: number;
    whiskerMinimum: number;
    whiskerMaximum: number;
    outliers: number[];
  }>;
}

ContractChartBubblePointIdentity

interface ContractChartBubblePointIdentity {
  pointIndex: number;
  size: number;
}

ContractChartCapabilityRefusal

type ContractChartCapabilityRefusal =
  | "unsupported-chart-type"
  | "unsupported-series-type"
  | "unsupported-three-d"
  | "unsupported-stock"
  | "unsupported-surface"
  | "incompatible-combination";

ContractChartCustomErrorBarRange

interface ContractChartCustomErrorBarRange {
  formula: string;
  pointCount: number;
}

ContractChartDataLabelPosition

type ContractChartDataLabelPosition =
  | "best-fit"
  | "center"
  | "inside-end"
  | "inside-base"
  | "outside-end"
  | "left"
  | "right"
  | "above"
  | "below";

ContractChartDataLabelsFormatting

interface ContractChartDataLabelsFormatting {
  visible: boolean;
  showValue: boolean;
  showCategoryName: boolean;
  showSeriesName: boolean;
  showLegendKey: boolean;
  showPercentage: boolean;
  separator?: string | null;
  numberFormat?: string | null;
  position?: ContractChartDataLabelPosition | null;
  showLeaderLines: boolean;
}

ContractChartDataTableFormatting

interface ContractChartDataTableFormatting {
  visible: boolean;
  showLegendKeys: boolean;
  showHorizontalBorder: boolean;
  showVerticalBorder: boolean;
  showOutlineBorder: boolean;
  style: ContractChartShapeStyle;
}

ContractChartErrorBarDirection

type ContractChartErrorBarDirection = "x" | "y";

ContractChartErrorBarEndStyle

type ContractChartErrorBarEndStyle = "both" | "plus" | "minus";

ContractChartErrorBarKind

type ContractChartErrorBarKind = "fixed" | "percentage" | "standard-deviation" | "standard-error" | "custom";

ContractChartErrorBarsFormatting

interface ContractChartErrorBarsFormatting {
  direction: ContractChartErrorBarDirection;
  kind: ContractChartErrorBarKind;
  endStyle: ContractChartErrorBarEndStyle;
  noEndCap: boolean;
  value?: number | null;
  plusRange?: ContractChartCustomErrorBarRange | null;
  minusRange?: ContractChartCustomErrorBarRange | null;
}

ContractChartFeatureCapability

interface ContractChartFeatureCapability {
  supported: boolean;
  reason?: ContractChartCapabilityRefusal | null;
}

ContractChartFormatting

interface ContractChartFormatting {
  template?: ContractChartTemplateSelection | null;
  family?: ContractChartBoundedFamily | null;
  bubbleScale?: number | null;
  missingValuePolicy?: ContractChartMissingValuePolicy;
  modern?: ContractChartModernFormatting;
  surface?: ContractChartSurfaceFormatting | null;
  title?: string | null;
  legendPosition: ContractChartLegendFormatPosition;
  legendOverlay: boolean;
  dataLabels: ContractChartDataLabelsFormatting;
  dataTable?: ContractChartDataTableFormatting;

  readonly capabilities?: ContractChartFormattingCapabilities;
  chartArea: ContractChartAreaFormatting;
  plotArea: ContractChartAreaFormatting;
  axes: ContractChartAxisFormatting[];
  series: ContractChartSeriesFormatting[];
}

ContractChartFormattingCapabilities

interface ContractChartFormattingCapabilities {
  combo?: ContractChartFeatureCapability;
  boundedFamilies?: ContractChartFeatureCapability;
  dataTable: ContractChartFeatureCapability;
  errorBars: ContractChartSeriesErrorBarCapability[];
}

ContractChartFunnelSettings

interface ContractChartFunnelSettings {
  readonly points: ReadonlyArray<{ pointIndex: number; value: number }>;
}

ContractChartGeographyRegion

interface ContractChartGeographyRegion {
  readonly inputLabel: string;
  readonly identity: "FRA" | "DEU" | "ITA" | "ESP" | "PRT" | "GBR";
  readonly value: number;
  readonly color: string;
}

ContractChartGeographySettings

interface ContractChartGeographySettings {
  readonly cultureLanguage?: string | null;
  readonly cultureRegion?: string | null;
  readonly attribution?: string | null;
  readonly minimum: number;
  readonly maximum: number;
  readonly regions: ReadonlyArray<ContractChartGeographyRegion>;
}

ContractChartHierarchyBlankPolicy

type ContractChartHierarchyBlankPolicy = "zero";

ContractChartHierarchyErrorPolicy

type ContractChartHierarchyErrorPolicy = "refuse";

ContractChartHierarchyNode

interface ContractChartHierarchyNode {
  readonly nodeId: string;
  readonly parentId?: string | null;
  readonly level: number;
  readonly label: string;
  readonly aggregate: number;
  readonly leafCount: number;
  readonly color: string;
}

ContractChartHierarchySettings

interface ContractChartHierarchySettings {
  readonly blankPolicy: ContractChartHierarchyBlankPolicy;
  readonly errorPolicy: ContractChartHierarchyErrorPolicy;
  readonly rootAggregate: number;
  readonly nodes: ReadonlyArray<ContractChartHierarchyNode>;
}

ContractChartHistogramBin

interface ContractChartHistogramBin {
  readonly binIndex: number;
  readonly lowerBound: number;
  readonly upperBound: number;
  readonly count: number;
  readonly cumulativePercent: number;
}

ContractChartHistogramSettings

interface ContractChartHistogramSettings {
  binCount?: number | null;
  binWidth?: number | null;
  underflow?: number | null;
  overflow?: number | null;
  intervalClosed: ContractChartIntervalClosedSide;
  readonly bins: ContractChartHistogramBin[];
}

ContractChartIntervalClosedSide

type ContractChartIntervalClosedSide = "left" | "right";

ContractChartLegendFormatPosition

type ContractChartLegendFormatPosition = "none" | "top" | "bottom" | "left" | "right";

ContractChartLegendPosition

type ContractChartLegendPosition = "top" | "left" | "right" | "bottom" | "none";

ContractChartLineDash

type ContractChartLineDash = "solid" | "dash" | "dot" | "dash-dot";

ContractChartManualLayout

interface ContractChartManualLayout {
  x: number;
  y: number;
  width: number;
  height: number;
}

ContractChartMarkerFormatting

interface ContractChartMarkerFormatting {
  style: ContractChartMarkerStyle;
  size: number;
  fillColor?: string | null;
  lineColor?: string | null;

  fillThemeSlot?: number | null;
  lineThemeSlot?: number | null;
}

ContractChartMarkerStyle

type ContractChartMarkerStyle = "none" | "circle" | "square" | "diamond" | "triangle" | "x" | "plus";

ContractChartMissingValuePolicy

type ContractChartMissingValuePolicy = "gap" | "zero" | "connect";

ContractChartModernFormatting

interface ContractChartModernFormatting {
  histogram?: ContractChartHistogramSettings | null;
  waterfall?: ContractChartWaterfallSettings | null;
  funnel?: ContractChartFunnelSettings | null;
  boxWhisker?: ContractChartBoxWhiskerSettings | null;
  hierarchy?: ContractChartHierarchySettings | null;
  geography?: ContractChartGeographySettings | null;
  readonly seriesIdentities: ReadonlyArray<{
    seriesIndex: number;
    uniqueId: string;
  }>;
}

ContractChartPayload

interface ContractChartPayload {
  status: ContractChartStatus;
  chartType?: ContractChartType | null;
  stackMode?: ContractChartStackMode | null;
  title?: string | null;
  categoryAxisTitle?: string | null;
  valueAxisTitle?: string | null;
  stylePreset?: ContractChartStylePreset | null;
  legendPosition?: ContractChartLegendPosition | null;
  chartAreaFillColor?: string | null;
  chartAreaLineColor?: string | null;
  plotAreaFillColor?: string | null;
  plotAreaLineColor?: string | null;
  seriesFillColor?: string | null;
  firstDataPointFillColor?: string | null;
  showDataLabels?: boolean | null;
  dataLabelNumberFormat?: string | null;
  valueAxisLineColor?: string | null;
  valueAxisMinimum?: number | null;
  valueAxisMaximum?: number | null;
  valueAxisNumberFormat?: string | null;
  showGridlines?: boolean | null;
  showAxes?: boolean | null;
  showTrendline?: boolean | null;
  showErrorBars?: boolean | null;
  showSecondaryAxis?: boolean | null;
  emptyCellBehavior?: "gaps" | "zero" | "connect" | null;
  pivotSourceName?: string | null;

  pivotLayoutBounds?: ContractSheetObjectBounds | null;

  formatting?: ContractChartFormatting | null;
  series: ContractChartSeries[];
}

ContractChartPointFormatting

interface ContractChartPointFormatting {
  pointIndex: number;
  style: ContractChartShapeStyle;
  marker?: ContractChartMarkerFormatting | null;
}

ContractChartQuartileMethod

type ContractChartQuartileMethod = "inclusive" | "exclusive";

ContractChartSeries

interface ContractChartSeries {
  name?: string | null;
  nameRef?: string | null;
  categoryRef?: string | null;
  valueRef?: string | null;
  categories: string[];

  categoryHierarchy?: string[][];
  values: number[];
}

ContractChartSeriesErrorBarCapability

interface ContractChartSeriesErrorBarCapability {
  seriesIndex: number;
  directions: ContractChartErrorBarDirection[];
  kinds: ContractChartErrorBarKind[];
  reason?: ContractChartCapabilityRefusal | null;
}

ContractChartSeriesFormatting

interface ContractChartSeriesFormatting {
  seriesIndex: number;
  chartType?: ContractChartSeriesType | null;
  secondaryAxis: boolean;
  stockRole?: ContractChartStockSeriesRole | null;
  xRange?: string | null;
  yRange?: string | null;
  bubbleSizeRange?: string | null;
  categoryRange?: string | null;
  valueRange?: string | null;

  readonly bubblePoints?: ContractChartBubblePointIdentity[];
  style: ContractChartShapeStyle;
  marker?: ContractChartMarkerFormatting | null;
  pointOverrides: ContractChartPointFormatting[];
  trendlines: ContractChartTrendlineFormatting[];
  errorBars: ContractChartErrorBarsFormatting[];
}

ContractChartSeriesType

type ContractChartSeriesType = "clustered-column" | "line" | "area";

ContractChartShapeStyle

interface ContractChartShapeStyle {
  fillColor?: string | null;
  lineColor?: string | null;
  lineWidthPt?: number | null;
  lineDash?: ContractChartLineDash | null;

  fillThemeSlot?: number | null;
  lineThemeSlot?: number | null;
}

ContractChartSheetOrientation

type ContractChartSheetOrientation = "portrait" | "landscape";

ContractChartSheetPageMargins

interface ContractChartSheetPageMargins {
  left: number;
  right: number;
  top: number;
  bottom: number;
  header: number;
  footer: number;
}

ContractChartSheetPrintPreview

interface ContractChartSheetPrintPreview {
  sheetKey: string;
  pageCount: number;
  pageWidthPoints: number;
  pageHeightPoints: number;
  contentWidthPoints: number;
  contentHeightPoints: number;
  scale: number;
  orientation: ContractChartSheetOrientation;
  printArea: boolean;
}

ContractChartSheetPrintSettings

interface ContractChartSheetPrintSettings {
  paperSize: number;
  orientation: ContractChartSheetOrientation;
  scale: number;
  margins: ContractChartSheetPageMargins;
  oddHeader?: string | null;
  oddFooter?: string | null;
  printArea: boolean;
}

ContractChartStackMode

type ContractChartStackMode = "none" | "stacked" | "percentStacked";

ContractChartStatus

type ContractChartStatus = | "live-readonly" | "unsupported-chart-type" | "missing-cache" | "invalid-payload";

ContractChartStockSeriesRole

type ContractChartStockSeriesRole = "volume" | "open" | "high" | "low" | "close";

ContractChartStylePreset

type ContractChartStylePreset = "default" | "muted" | "monochrome" | "colorful" | "clean";

ContractChartSurfaceFormatting

interface ContractChartSurfaceFormatting {
  view3D: ContractChartSurfaceView3D;
  backWall: ContractChartShapeStyle;
  sideWall: ContractChartShapeStyle;
  floor: ContractChartShapeStyle;
}

ContractChartSurfaceView3D

interface ContractChartSurfaceView3D {
  rotation: number;
  elevation: number;
  perspective: number;
}

ContractChartTemplateSelection

interface ContractChartTemplateSelection {
  templateId: string;
  source: ContractChartTemplateSource;
  chartStyleId: number;
  colorStyleId: number;
  theme: ContractChartThemeReference;
}

ContractChartTemplateSource

type ContractChartTemplateSource = "built-in" | "crtx";

ContractChartThemeColorSlot

type ContractChartThemeColorSlot =
  | "dark1"
  | "light1"
  | "dark2"
  | "light2"
  | "accent1"
  | "accent2"
  | "accent3"
  | "accent4"
  | "accent5"
  | "accent6"
  | "hyperlink"
  | "followed-hyperlink";

ContractChartThemeReference

interface ContractChartThemeReference {
  themeId: string;
  colorSlot: ContractChartThemeColorSlot;
}

ContractChartTrendlineFacts

interface ContractChartTrendlineFacts {
  equation?: string | null;
  rSquared?: number | null;
  coefficients: number[];
  movingAveragePoints: ContractChartTrendlinePoint[];
  sourcePointCount: number;
}

ContractChartTrendlineFormatting

interface ContractChartTrendlineFormatting {
  trendlineIndex: number;
  kind: ContractChartTrendlineKind;
  name?: string | null;
  polynomialOrder?: number | null;
  movingAveragePeriod?: number | null;
  displayEquation: boolean;
  displayRSquared: boolean;

  readonly facts?: ContractChartTrendlineFacts | null;
}

ContractChartTrendlineKind

type ContractChartTrendlineKind = "linear" | "exponential" | "logarithmic" | "polynomial" | "moving-average";

ContractChartTrendlinePoint

interface ContractChartTrendlinePoint {
  x: number;
  y: number;
}

ContractChartType

type ContractChartType =
  | "column"
  | "bar"
  | "line"
  | "area"
  | "pie"
  | "doughnut"
  | "scatter"
  | "combo"
  | "radar"
  | "map"
  | "waterfall"
  | "funnel"
  | "histogram"
  | "bubble"
  | "pareto"
  | "treemap"
  | "sunburst"
  | "stock"
  | "boxwhisker"
  | "scatter-smooth"
  | "scatter-smooth-line"
  | "scatter-straight"
  | "scatter-straight-line"
  | "radar-markers"
  | "radar-filled"
  | "surface"
  | "area-column"
  | "stock-hlc"
  | "stacked-column"
  | "percent-stacked-column"
  | "stacked-bar"
  | "percent-stacked-bar"
  | "stacked-line"
  | "percent-stacked-line"
  | "stacked-area"
  | "percent-stacked-area";

ContractChartWaterfallPoint

interface ContractChartWaterfallPoint {
  readonly pointIndex: number;
  readonly value: number;
  readonly runningTotal: number;
  readonly isTotal: boolean;
}

ContractChartWaterfallSettings

interface ContractChartWaterfallSettings {
  totalPointIndices: number[];
  showConnectorLines: boolean;
  readonly points: ContractChartWaterfallPoint[];
}

ContractDataAnalysisChartPlan

interface ContractDataAnalysisChartPlan {
  available: boolean;
  lifecycle: "create" | "remove";
  chartType: "column" | "line";
  title: string;
  categoryRange: CellRange;
  valueRange: CellRange;
}

ContractDrawingObjectAction

type ContractDrawingObjectAction =
  | { kind: "create"; sheetId: string; creation: ContractOpenDocumentObjectCreation; }
  | { kind: "command"; sheetId: string; objectStableIds: string[]; primaryStableId?: string
  | null; command: ContractObjectSelectionPaneCommand; geometryAnchor?: ContractObjectAnchor
  | null; groupId?: string
  | null; orderedStableIds?: string[]; memberStableIds?: string[]; };

ContractDrawingObjectImageCrop

interface ContractDrawingObjectImageCrop {
  leftPct: number;
  topPct: number;
  rightPct: number;
  bottomPct: number;
}

ContractDrawingTextEditSemantics

interface ContractDrawingTextEditSemantics {
  sheetId: string;
  objectId: string;
  text: string;
  paragraphs: ContractTextParagraph[];
  verticalAlign?: ContractTextVerticalAlign | null;
  wrapText?: boolean | null;
  rotationDegrees?: number | null;
  marginsCm: [number | null, number | null, number | null, number | null];
}

ContractImagePayload

interface ContractImagePayload {
  mimeType: string;
  dataUrl: string;
  widthPx?: number | null;
  heightPx?: number | null;
  byteCount?: number | null;
  editingStatus?:
    "live-supported" | "unsupported" | "malformed" | "oversized" | null;
  editingError?: string | null;

  svgText?: string | null;

  svgTextOriginal?: string | null;
}

ContractOpenDocumentChartSeries

interface ContractOpenDocumentChartSeries {
  name: string;
  categoryFormula: string;
  valueFormula: string;
  categoryCache: string[];
  valueCache: number[];
}

ContractSparklineAction

type ContractSparklineAction =
  | { kind: "inventory" }
  | { kind: "create";
    sheetPath: string;
    sourceRange: CellRange;
    targetRow: number;
    targetCol: number;
    sparklineType: ContractSparklineType;
    style: ContractSparklineStyle;
    flags?: ContractSparklineFlags;
  }
  | { kind: "modify"; stableId: string; sourceRange?: CellRange
  | null; sparklineType?: ContractSparklineType
  | null; style?: ContractSparklineStyle
  | null; flags?: ContractSparklineFlags
  | null; }
  | { kind: "delete"; stableId: string };

ContractSparklineFlags

interface ContractSparklineFlags {
  showMarkers?: boolean;
  showAxis?: boolean;
  showHighPoint?: boolean;
  showLowPoint?: boolean;
  showFirstPoint?: boolean;
  showLastPoint?: boolean;
  showNegativePoints?: boolean;
}

ContractSparklinePlanMode

type ContractSparklinePlanMode = "inventory" | "preview" | "apply";

ContractSparklineProjectionEntry

interface ContractSparklineProjectionEntry {
  stableId: string;
  sheetPath: string;
  sourceRef: string;
  targetRef: string;
  targetRow: number;
  targetCol: number;
  sparklineType: ContractSparklineType;
  style: ContractSparklineStyle;
  flags: Required<ContractSparklineFlags>;
  renderText: string;
}

ContractSparklineStyle

type ContractSparklineStyle = "default" | "accent" | "calm";

ContractSparklineType

type ContractSparklineType = "line" | "column" | "winLoss";

ContractXlsxChartCreationPatch

interface ContractXlsxChartCreationPatch {
  activeSheetPath: string;
  sheetName: string;
  objectId?: string | null;
  objectName?: string | null;
  zOrder?: number | null;
  chartType: ContractChartType;
  stackMode?: ContractChartStackMode | null;
  title?: string | null;
  categoryAxisTitle?: string | null;
  valueAxisTitle?: string | null;
  stylePreset?: ContractChartStylePreset | null;
  legendPosition?: ContractChartLegendPosition | null;
  chartAreaFillColor?: string | null;
  chartAreaLineColor?: string | null;
  plotAreaFillColor?: string | null;
  plotAreaLineColor?: string | null;
  seriesFillColor?: string | null;
  firstDataPointFillColor?: string | null;
  showDataLabels?: boolean | null;
  dataLabelNumberFormat?: string | null;
  valueAxisLineColor?: string | null;
  valueAxisMinimum?: number | null;
  valueAxisMaximum?: number | null;
  valueAxisNumberFormat?: string | null;
  showGridlines?: boolean | null;
  showAxes?: boolean | null;
  showTrendline?: boolean | null;
  showErrorBars?: boolean | null;
  showSecondaryAxis?: boolean | null;
  emptyCellBehavior?: "gaps" | "zero" | "connect" | null;
  pivotSourceName?: string | null;
  from: ContractObjectAnchorCell;
  to: ContractObjectAnchorCell;
  series: ContractChartSeries[];
}

ContractXlsxChartMutationPatch

interface ContractXlsxChartMutationPatch {
  activeSheetPath: string;
  objectId: string;
  relId: string;
  chartType: ContractChartType;
  stackMode?: ContractChartStackMode | null;
  title?: string | null;
  categoryAxisTitle?: string | null;
  valueAxisTitle?: string | null;
  stylePreset?: ContractChartStylePreset | null;
  legendPosition?: ContractChartLegendPosition | null;
  showDataLabels?: boolean | null;
  dataLabelNumberFormat?: string | null;
  valueAxisMinimum?: number | null;
  valueAxisMaximum?: number | null;
  valueAxisNumberFormat?: string | null;
  showGridlines?: boolean | null;
  showAxes?: boolean | null;
  showSecondaryAxis?: boolean | null;
  emptyCellBehavior?: "gaps" | "zero" | "connect" | null;

  refreshCaches?: boolean | null;
  series: ContractChartSeries[];
}

ContractXlsxChartObjectMovePatch

interface ContractXlsxChartObjectMovePatch {
  activeSheetPath: string;
  objectId: string;
  relId: string;
  from: ContractObjectAnchorCell;
  ext: ContractObjectExtent;
}

ContractXlsxChartSeriesUpdatePatch

interface ContractXlsxChartSeriesUpdatePatch {
  activeSheetPath: string;
  objectId: string;
  relId: string;
  seriesIndex: number;
  nameRef?: string | null;
  nameLiteral?: string | null;
  categoryAxisTitle?: string | null;
  valueAxisTitle?: string | null;
  categoryRef: string;
  valueRef: string;
  categories?: string[] | null;
  values?: number[] | null;
}

ContractXlsxDrawingImageCreationPatch

interface ContractXlsxDrawingImageCreationPatch {
  activeSheetPath: string;
  sheetName: string;
  objectId: string;
  objectName?: string | null;
  mimeType: "image/png" | "image/jpeg";
  dataUrl: string;
  from: ContractObjectAnchorCell;
  ext: ContractObjectExtent;
  altText?: string | null;
  linkedSourceRange?: string | null;

  svgText?: string | null;
}

ContractXlsxDrawingObjectDeletionPatch

interface ContractXlsxDrawingObjectDeletionPatch {
  activeSheetPath: string;
  objectId: string;
  objectFamily: "chart" | "image";
  relId: string;
}

ContractXlsxDrawingObjectGroupMemberPatch

interface ContractXlsxDrawingObjectGroupMemberPatch {
  objectId: string;
  objectFamily: "chart" | "image";
  relId: string;
}

ContractXlsxDrawingObjectGroupPatch

interface ContractXlsxDrawingObjectGroupPatch {
  activeSheetPath: string;
  groupId: string;
  groupName?: string | null;
  members: ContractXlsxDrawingObjectGroupMemberPatch[];
}

ContractXlsxDrawingObjectImageTransformPatch

interface ContractXlsxDrawingObjectImageTransformPatch {
  activeSheetPath: string;
  objectId: string;
  objectFamily: "image";
  relId: string;
  rotationDeg?: number | null;
  imageCrop?: ContractDrawingObjectImageCrop | null;
  flipH?: boolean | null;
  flipV?: boolean | null;
  hidden?: boolean | null;
}

ContractXlsxDrawingObjectMetadataPatch

interface ContractXlsxDrawingObjectMetadataPatch {
  activeSheetPath: string;
  objectId: string;
  objectFamily: "chart" | "image";
  relId: string;
  objectName?: string | null;
  altText?: string | null;
  title?: string | null;
  description?: string | null;
  decorative?: boolean | null;
  hidden?: boolean | null;
  printObject?: boolean | null;
  locksWithSheet?: boolean | null;
}

ContractXlsxDrawingObjectMovePatch

interface ContractXlsxDrawingObjectMovePatch {
  activeSheetPath: string;
  objectId: string;
  objectFamily: "chart" | "image";
  relId: string;
  from: ContractObjectAnchorCell;
  ext: ContractObjectExtent;
}

ContractXlsxDrawingObjectUngroupPatch

interface ContractXlsxDrawingObjectUngroupPatch {
  activeSheetPath: string;
  groupId: string;
}

ContractXlsxDrawingObjectZOrderPatch

interface ContractXlsxDrawingObjectZOrderPatch {
  activeSheetPath: string;
  objectId: string;
  objectFamily: "chart" | "image";
  relId: string;
  action: "forward" | "backward" | "front" | "back";
}

ContractXlsxShapeObjectPatch

interface ContractXlsxShapeObjectPatch {
  objectId: string;
  objectName?: string | null;
  altText?: string | null;
  hidden?: boolean | null;
  prst: string;

  savePrst?: string | null;
  from: ContractObjectAnchorCell;

  to?: ContractObjectAnchorCell | null;
  ext: ContractObjectExtent;
  zOrder?: number | null;
  fillHex?: string | null;

  fillOpacity?: number | null;
  gradientFill?: boolean | null;
  gradientAngle?: number | null;
  gradientColor1?: string | null;
  gradientColor2?: string | null;
  lineHex?: string | null;

  strokeOnly?: boolean | null;
  lineWidthEmu?: number | null;

  rotationDegrees?: number | null;

  textRotationDegrees?: number | null;

  adj?: number | null;

  isLine?: boolean | null;
  flipH?: boolean | null;
  flipV?: boolean | null;
  headEnd?: string | null;
  tailEnd?: string | null;

  shadowPreset?: string | null;
  shadowColor?: string | null;
  shadowOpacity?: number | null;
  shadowBlur?: number | null;
  shadowAngle?: number | null;
  shadowDist?: number | null;
  glowColor?: string | null;
  glowSize?: number | null;
  glowOpacity?: number | null;
  softEdges?: number | null;
  reflectionOpacity?: number | null;
  reflectionBlur?: number | null;
  reflectionDistance?: number | null;
  reflectionSize?: number | null;

  textOutlineHex?: string | null;
  textFillType?: string | null;
  textFillOpacity?: number | null;
  textOutlineType?: string | null;
  textOutlineOpacity?: number | null;
  textOutlineWidth?: number | null;
  textShadow?: boolean | null;
  textShadowColor?: string | null;
  textShadowOpacity?: number | null;
  textShadowBlur?: number | null;
  textShadowAngle?: number | null;
  textShadowDist?: number | null;
  textGlowColor?: string | null;
  textGlowSize?: number | null;
  textGlowOpacity?: number | null;
  textSoftEdges?: number | null;

  bevelTopPreset?: string | null;
  bevelTopWidth?: number | null;
  bevelTopHeight?: number | null;
  bevelBottomPreset?: string | null;
  bevelBottomWidth?: number | null;
  bevelBottomHeight?: number | null;
  depthColor?: string | null;
  depth?: number | null;
  contourColor?: string | null;
  contourWidth?: number | null;
  material?: string | null;
  lightingRig?: string | null;
  lightingAngle?: number | null;
  cameraPreset?: string | null;
  rotationX?: number | null;
  rotationY?: number | null;
  rotationZ?: number | null;
  perspective?: number | null;
  wrapText?: boolean | null;
  overflowText?: boolean | null;
  autofit?: string | null;
  textDirection?: string | null;
  textMarginLeft?: number | null;
  textMarginRight?: number | null;
  textMarginTop?: number | null;
  textMarginBottom?: number | null;

  underline?: boolean | null;

  stCxnObjectId?: string | null;
  stCxnIdx?: number | null;
  endCxnObjectId?: string | null;
  endCxnIdx?: number | null;

  nativeNvId?: number | null;

  text?: string | null;
  paragraphs?: ContractTextParagraph[] | null;
  fontFamily?: string | null;
  fontSize?: number | null;
  bold?: boolean | null;
  italic?: boolean | null;
  textColor?: string | null;
  horizontalAlign?: ContractTextHorizontalAlign | null;
  verticalAlign?: ContractTextVerticalAlign | null;

  freeformPoints?: ReadonlyArray<{
    x: number;
    y: number;
    c1x?: number | null;
    c1y?: number | null;
    c2x?: number | null;
    c2y?: number | null;
  }> | null;
  isClosed?: boolean | null;

  rawAnchorXml?: string | null;

  geometryEdited?: boolean | null;

  adjustments?: ReadonlyArray<{ name: string; val: number }> | null;

  strokeDash?: string | null;
}

ContractXlsxShapeSheetPatch

interface ContractXlsxShapeSheetPatch {
  activeSheetPath: string;
  objects: ContractXlsxShapeObjectPatch[];
}