Типы: форматирование

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

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

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

• ColumnProfile
• ColumnValueFrequency
• ContractApplyThemeFontsPatch
• ContractCellStyleDefinition
• ContractCellStyleFormatting
• ContractCellStyleMutation
• ContractCellStylesManagerAction
• ContractCellStylesManagerAuthority
• ContractColumnWidth
• ContractConditionalComparison
• ContractConditionalFormattingManagerAction
• ContractConditionalFormattingManagerAuthority
• ContractConditionalFormattingOpaqueRule
• ContractConditionalPopulationKind
• ContractConditionalRange
• ContractConditionalRankDirection
• ContractConditionalRule
• ContractConditionalRuleKind
• ContractConditionalRuleVisual
• ContractConditionalScalar
• ContractDataCleanupPreviewRow
• ContractDataCleanupRowSpan
• ContractDelimitedColumnFormat
• ContractFileFormat
• ContractFormatCapabilities
• ContractMergeCellsMode
• ContractPreviewBorderSide
• ContractPreviewBorderStyle
• ContractPreviewBorders
• ContractPreviewConditionalFillKind
• ContractPreviewConditionalIcon
• ContractPreviewFontVerticalAlign
• ContractPreviewFormatting
• ContractPreviewGradientFill
• ContractPreviewPatternFill
• ContractPreviewPatternFillKind
• ContractRangeFilterColumnCriteria
• ContractRowHeight
• ContractTableColumnMetadata
• ContractTableStyleDefinition
• ContractTableStyleElementDefinition
• ContractTableStyleMutation
• ContractTableStyleOptions
• ContractTableStylesManagerAction
• ContractTableStylesManagerAuthority
• ContractTableTotalColumn
• ContractTextToColumnsAdvancedOptions
• ContractTextToColumnsColumnFormat
• ContractXlsxCellFormatPatch
• ContractXlsxColumnOutlineGroupPatch
• ContractXlsxColumnOutlineRangePatch
• ContractXlsxColumnOutlineUngroupPatch
• ContractXlsxDelimitedColumnRulePatch
• ContractXlsxRowOutlineGroupPatch
• ContractXlsxRowOutlineRangePatch
• ContractXlsxRowOutlineUngroupPatch
• FlashFillCandidateView
• FlashFillExample
• FlashFillInference
• FlashFillMode
• FlashFillPreviewCell
• FlashFillRefusalContext
• FlashFillTargetRow
• FlashFillValue
• FlashFillValueKind
• MWireTableRowType
• SortRangeRowsDirection
• SortRangeRowsLevel
• SortRangeRowsNumericTextMode

ColumnProfile

interface ColumnProfile {

  name: string;

  typeName: ContractPowerQueryCellKind | "mixed" | "null";

  nullCount: number;

  errorCount: number;

  emptyCount: number;

  validCount: number;

  distinctCount: number;

  distinctCapped: boolean;

  distribution: ColumnValueFrequency[];

  validRatio: number;

  errorRatio: number;

  emptyRatio: number;
}

ColumnValueFrequency

interface ColumnValueFrequency {
  value: string;
  kind: ContractPowerQueryCellKind;
  count: number;
}

ContractApplyThemeFontsPatch

interface ContractApplyThemeFontsPatch {
  majorTypeface: string;
  minorTypeface: string;
}

ContractCellStyleDefinition

interface ContractCellStyleDefinition {
  identity: string;
  name: string;
  builtIn: boolean;
  builtinId?: number | null;
  editable: boolean;
  deletable: boolean;
  duplicable: boolean;
  category: string;
  formatting: ContractCellStyleFormatting;
  xfId: number;
  applicationStyleIndex: number;
  usageCount: number;
  opaque: boolean;
  rawXmlDigest: string;
}

ContractCellStyleFormatting

type ContractCellStyleFormatting = Omit< ContractPreviewFormatting, "dataBar" | "conditionalIcon" | "conditionalFillKind" >;

ContractCellStyleMutation

type ContractCellStyleMutation =
  | { kind: "create"; draftIdentity: string; name: string; basedOnIdentity?: string
  | null; formatting?: ContractCellStyleFormatting
  | null; }
  | { kind: "modify";
    identity: string;
    name: string;
    formatting: ContractCellStyleFormatting;
    expectedRawXmlDigest: string;
  }
  | { kind: "duplicate"; identity: string; draftIdentity: string; name: string; }
  | { kind: "delete"; identity: string; expectedRawXmlDigest: string; };

ContractCellStylesManagerAction

type ContractCellStylesManagerAction =
  | { action: "inspect" }
  | { action: "commit"; mutations: ContractCellStyleMutation[]; expectedOpaqueStyleIdentities?: string[]; }
  | { action: "applyStyle"; identity: string; target: CellRange }
  | { action: "mergeFromWorkbook"; sourceSubsetId: string; identities?: string[]; };

ContractCellStylesManagerAuthority

interface ContractCellStylesManagerAuthority {
  canApply: boolean;
  readOnly: boolean;
  protected: boolean;
  sourceKindLive: boolean;
  refusalCode?: string | null;
}

ContractColumnWidth

interface ContractColumnWidth {
  col: number;
  width: number;
}

ContractConditionalComparison

type ContractConditionalComparison = "greaterThan" | "lessThan" | "equalTo";

ContractConditionalFormattingManagerAction

type ContractConditionalFormattingManagerAction =
  | { action: "inspect" }
  | { action: "apply"; rules: ContractConditionalRule[]; expectedOpaqueRuleIdentities?: string[]; };

ContractConditionalFormattingManagerAuthority

interface ContractConditionalFormattingManagerAuthority {
  canApply: boolean;
  readOnly: boolean;
  protected: boolean;
  sourceKindLive: boolean;
  refusalCode?: string | null;
}

ContractConditionalFormattingOpaqueRule

interface ContractConditionalFormattingOpaqueRule {
  identity: string;
  ruleType: string;
  priority: number;
  stopIfTrue: boolean;
  appliesTo: string;
  formulas: string[];
  rawXmlDigest: string;
  editable: false;
  refusalCode: "conditional-formatting-opaque-rule-read-only" | string;
}

ContractConditionalPopulationKind

type ContractConditionalPopulationKind = "duplicate" | "unique";

ContractConditionalRange

interface ContractConditionalRange {
  rowStart: number;
  rowEnd: number;
  colStart: number;
  colEnd: number;
}

ContractConditionalRankDirection

type ContractConditionalRankDirection = "top" | "bottom";

ContractConditionalRule

interface ContractConditionalRule {
  id: string;
  priority: number;
  stopIfTrue: boolean;
  appliesTo: ContractConditionalRange[];
  kind: ContractConditionalRuleKind;
  visual: ContractConditionalRuleVisual;
  pivotScope?: ContractPivotConditionalRuleScope | null;
}

ContractConditionalRuleKind

type ContractConditionalRuleKind =
  | { type: "compare"; operator: ContractConditionalComparison; operand: ContractConditionalScalar; }
  | { type: "between"; lower: ContractConditionalScalar; upper: ContractConditionalScalar; }
  | { type: "textContains"; value: string }
  | { type: "population"; value: ContractConditionalPopulationKind }
  | { type: "rank"; direction: ContractConditionalRankDirection; amount: number; percent: boolean; }
  | { type: "average"; above: boolean }
  | { type: "twoColorScale" }
  | { type: "threeColorScale" }
  | { type: "dataBar" }
  | { type: "iconSet" }
  | { type: "formula"; value: string };

ContractConditionalRuleVisual

interface ContractConditionalRuleVisual {
  dxfId?: number | null;
  fillColor?: string | null;
  fontColor?: string | null;
  bold: boolean;
  dataBarColor?: string | null;
  colorScaleColors: string[];
  iconSet?: string | null;
}

ContractConditionalScalar

type ContractConditionalScalar =
  | { kind: "blank" }
  | { kind: "emptyString" }
  | { kind: "number"; value: number }
  | { kind: "text"; value: string }
  | { kind: "boolean"; value: boolean }
  | { kind: "error"; value: string };

ContractDataCleanupPreviewRow

interface ContractDataCleanupPreviewRow {
  sourceRow: number;
  values: ContractDataCleanupPreviewValue[];
  duplicate?: boolean;
}

ContractDataCleanupRowSpan

interface ContractDataCleanupRowSpan {
  rowStart: number;
  rowEnd: number;
}

ContractDelimitedColumnFormat

interface ContractDelimitedColumnFormat {
  sourceIndex: number;
  format: ContractTextToColumnsColumnFormat;
}

ContractFileFormat

type ContractFileFormat = (typeof CONTRACT_FILE_FORMAT_IDS)[number];

ContractFormatCapabilities

interface ContractFormatCapabilities {
  fileFormat: ContractFileFormat;
  containerFamily: ContractContainerFamily;
  openCapability: ContractCapabilityLevel;
  editCapability: ContractCapabilityLevel;
  saveCapability: ContractSaveCapability;
  saveKind: ContractSaveKind;
  fidelityClass: ContractFidelityClass;
  nonGoals: ContractFormatNonGoal[];
}

ContractMergeCellsMode

type ContractMergeCellsMode = "merge" | "merge-and-center" | "merge-across";

ContractPreviewBorderSide

interface ContractPreviewBorderSide {
  style: ContractPreviewBorderStyle;
  color?: string | null;
}

ContractPreviewBorderStyle

type ContractPreviewBorderStyle =
  | "thin"
  | "hair"
  | "dotted"
  | "dashed"
  | "dashDot"
  | "dashDotDot"
  | "medium"
  | "mediumDashed"
  | "mediumDashDot"
  | "mediumDashDotDot"
  | "slantDashDot"
  | "thick"
  | "double";

ContractPreviewBorders

interface ContractPreviewBorders {
  left?: ContractPreviewBorderSide | null;
  right?: ContractPreviewBorderSide | null;
  top?: ContractPreviewBorderSide | null;
  bottom?: ContractPreviewBorderSide | null;
  diagonalUp?: ContractPreviewBorderSide | null;
  diagonalDown?: ContractPreviewBorderSide | null;
}

ContractPreviewConditionalFillKind

type ContractPreviewConditionalFillKind = "cellIs" | "containsText" | "colorScale";

ContractPreviewConditionalIcon

interface ContractPreviewConditionalIcon {
  glyph: string;
  color: string;
  label?: string | null;
}

ContractPreviewFontVerticalAlign

type ContractPreviewFontVerticalAlign = "baseline" | "superscript" | "subscript";

ContractPreviewFormatting

interface ContractPreviewFormatting {
  fillColor?: string | null;
  gradientFill?: ContractPreviewGradientFill | null;
  patternFill?: ContractPreviewPatternFill | null;
  dataBar?: ContractPreviewDataBar | null;
  conditionalIcon?: ContractPreviewConditionalIcon | null;
  conditionalFillKind?: ContractPreviewConditionalFillKind | null;
  numberFormat?: string | null;
  fontColor?: string | null;
  fontFamily?: string | null;
  fontSize?: number | null;
  bold?: boolean;
  italic?: boolean;
  fontVerticalAlign?: ContractPreviewFontVerticalAlign | null;
  underlineKind?: ContractPreviewUnderlineKind | null;
  underline?: boolean;
  strike?: boolean;
  horizontalAlign?: ContractPreviewHorizontalAlign | null;
  verticalAlign?: ContractPreviewVerticalAlign | null;
  wrapText?: boolean;
  shrinkToFit?: boolean;
  textRotation?: number | null;
  indent?: number | null;
  borders?: ContractPreviewBorders | null;
  locked?: boolean | null;
  hidden?: boolean | null;
}

ContractPreviewGradientFill

interface ContractPreviewGradientFill {
  degree?: number | null;
  stops: ContractPreviewGradientStop[];
}

ContractPreviewPatternFill

interface ContractPreviewPatternFill {
  kind: ContractPreviewPatternFillKind;
  fgColor?: string | null;
  bgColor?: string | null;
}

ContractPreviewPatternFillKind

type ContractPreviewPatternFillKind =
  | "solid"
  | "darkGray"
  | "mediumGray"
  | "lightGray"
  | "gray125"
  | "gray0625"
  | "darkHorizontal"
  | "darkVertical"
  | "darkDown"
  | "darkUp"
  | "darkGrid"
  | "darkTrellis"
  | "lightHorizontal"
  | "lightVertical"
  | "lightDown"
  | "lightUp"
  | "lightGrid"
  | "lightTrellis";

ContractRangeFilterColumnCriteria

type ContractRangeFilterColumnCriteria = { column: number; } & ContractRangeFilterPredicate;

ContractRowHeight

interface ContractRowHeight {
  row: number;
  height: number;
}

ContractTableColumnMetadata

interface ContractTableColumnMetadata {
  id: number | null;
  name: string;
  dataRange?: string | null;
  calculatedColumnFormula?: string | null;
  totalsRowFunction?: string | null;
  totalsRowFormula?: string | null;
}

ContractTableStyleDefinition

interface ContractTableStyleDefinition {
  identity: string;
  name: string;
  builtIn: boolean;
  category: "light" | "medium" | "dark" | "custom" | string;
  displayOrder: number;
  isDefault: boolean;
  supported: boolean;
  opaque: boolean;
  editable: boolean;
  deletable: boolean;
  duplicable: boolean;
  appliedTableCount: number;
  elements: ContractTableStyleElementDefinition[];
  rawXmlDigest: string;
}

ContractTableStyleElementDefinition

interface ContractTableStyleElementDefinition {
  elementType: string;
  stripeSize?: number | null;
  dxfId?: number | null;
  formatting?: ContractCellStyleFormatting | null;
  opaque: boolean;
  rawXmlDigest: string;
}

ContractTableStyleMutation

type ContractTableStyleMutation =
  | { kind: "create"; draftIdentity: string; name: string; basedOnIdentity?: string
  | null; elements?: ContractTableStyleElementDefinition[] }
  | { kind: "modify";
    identity: string;
    name: string;
    elements: ContractTableStyleElementDefinition[];
  expectedRawXmlDigest: string }
  | { kind: "duplicate"; identity: string; draftIdentity: string; name: string }
  | { kind: "delete"; identity: string; expectedRawXmlDigest: string }
  | { kind: "setDefault"; identity: string };

ContractTableStyleOptions

interface ContractTableStyleOptions {
  showHeaderRow: boolean;
  showTotalRow: boolean;
  showFirstColumn: boolean;
  showLastColumn: boolean;
  showRowStripes: boolean;
  showColumnStripes: boolean;
}

ContractTableStylesManagerAction

type ContractTableStylesManagerAction =
  | { action: "inspect"; tableStableId?: string
  | null }
  | { action: "commit"; mutations: ContractTableStyleMutation[]; expectedOpaqueStyleIdentities?: string[] }
  | { action: "applyStyle"; tableStableId: string; identity: string; options: ContractTableStyleOptions };

ContractTableStylesManagerAuthority

interface ContractTableStylesManagerAuthority {
  canApply: boolean;
  readOnly: boolean;
  protected: boolean;
  sourceKindLive: boolean;
  tableMissing: boolean;
  refusalCode?: string | null;
}

ContractTableTotalColumn

interface ContractTableTotalColumn {
  columnName: string;
  function?: string | null;
  formula?: string | null;
  label?: string | null;
}

ContractTextToColumnsAdvancedOptions

interface ContractTextToColumnsAdvancedOptions {
  decimalSeparator?: string | null;
  thousandsSeparator?: string | null;
}

ContractTextToColumnsColumnFormat

type ContractTextToColumnsColumnFormat = "general" | "text" | "skip" | "date_mdy" | "date_dmy" | "date_ymd";

ContractXlsxCellFormatPatch

interface ContractXlsxCellFormatPatch {
  activeSheetPath: string;
  cellRef: string;
  fillColor?: string | null;
  patternFill?: ContractPreviewPatternFill | null;
  fontColor?: string | null;
  fontFamily?: string | null;
  fontSize?: number | null;
  numberFormat?: string | null;
  bold?: boolean | null;
  italic?: boolean | null;
  fontVerticalAlign?: ContractPreviewFontVerticalAlign | null;
  underline?: boolean | null;
  strike?: boolean | null;
  horizontalAlign?: string | null;
  verticalAlign?: string | null;
  wrapText?: boolean | null;
  shrinkToFit?: boolean | null;
  locked?: boolean | null;
  hidden?: boolean | null;
  borders?: ContractPreviewBorders | null;
  textRotation?: number | null;
  borderPreset?: string | null;
  diagonalUp?: boolean | null;
  diagonalDown?: boolean | null;
}

ContractXlsxColumnOutlineGroupPatch

interface ContractXlsxColumnOutlineGroupPatch {
  activeSheetPath: string;
  colStart: number;
  colEnd: number;
  outlineLevel?: number | null;
  hidden?: boolean | null;
}

ContractXlsxColumnOutlineRangePatch

interface ContractXlsxColumnOutlineRangePatch {
  activeSheetPath: string;
  colStart: number;
  colEnd: number;
  outlineLevel?: number | null;
  hidden?: boolean | null;
  summaryBelow?: boolean | null;
  summaryRight?: boolean | null;
}

ContractXlsxColumnOutlineUngroupPatch

interface ContractXlsxColumnOutlineUngroupPatch {
  activeSheetPath: string;
  colStart: number;
  colEnd: number;
}

ContractXlsxDelimitedColumnRulePatch

interface ContractXlsxDelimitedColumnRulePatch {
  sourceIndex: number;
  type: "auto" | "general" | "text" | "date" | "skip";
  dateOrder?: "mdy" | "dmy" | "ymd" | null;
}

ContractXlsxRowOutlineGroupPatch

interface ContractXlsxRowOutlineGroupPatch {
  activeSheetPath: string;
  rowStart: number;
  rowEnd: number;
  outlineLevel?: number | null;
  hidden?: boolean | null;
}

ContractXlsxRowOutlineRangePatch

interface ContractXlsxRowOutlineRangePatch {
  activeSheetPath: string;
  rowStart: number;
  rowEnd: number;
  outlineLevel?: number | null;
  hidden?: boolean | null;
  summaryBelow?: boolean | null;
  summaryRight?: boolean | null;
}

ContractXlsxRowOutlineUngroupPatch

interface ContractXlsxRowOutlineUngroupPatch {
  activeSheetPath: string;
  rowStart: number;
  rowEnd: number;
}

FlashFillCandidateView

interface FlashFillCandidateView { id: string; label: string; pattern: Record<string, unknown> }

FlashFillExample

interface FlashFillExample { sources: FlashFillValue[]; output: FlashFillValue }

FlashFillInference

interface FlashFillInference {
  candidates: FlashFillCandidateView[];
  selectedCandidateId?: string | null;
  ambiguous: boolean;
  previews: FlashFillPreviewCell[];
  deterministicHash: string;
}

FlashFillMode

type FlashFillMode = "infer" | "preview" | "apply";

FlashFillPreviewCell

interface FlashFillPreviewCell {
  sheetKey: string;
  row: number;
  col: number;
  value: FlashFillValue;
  skipped: boolean;
}

FlashFillRefusalContext

interface FlashFillRefusalContext {
  readOnly?: boolean;
  protected?: boolean;
  tableBoundary?: boolean;
  spill?: boolean;
  merged?: boolean;
  cancelled?: boolean;
}

FlashFillTargetRow

interface FlashFillTargetRow {
  sheetKey: string;
  row: number;
  col: number;
  sources: FlashFillValue[];
  targetHasFormula?: boolean;
  targetIsNonblank?: boolean;
  filteredOut?: boolean;
}

FlashFillValue

interface FlashFillValue { kind: FlashFillValueKind; text: string }

FlashFillValueKind

type FlashFillValueKind = | "blank" | "empty-string" | "text" | "number" | "date" | "time" | "error" | "formula";

MWireTableRowType

interface MWireTableRowType {
  columns: MWireTypeField[];
}

SortRangeRowsDirection

type SortRangeRowsDirection = "ascending" | "descending";

SortRangeRowsLevel

interface SortRangeRowsLevel {
  col: number;
  direction: SortRangeRowsDirection;
  customOrder?: string[];
}

SortRangeRowsNumericTextMode

type SortRangeRowsNumericTextMode = "as_text" | "as_number";