> ## Documentation Index
> Fetch the complete documentation index at: https://docs.reducto.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Types: editor: Other

## `CellArea`

A block's rows and columns, one-based, without its sheet.

Import from `@reductoai/xlsx/editor`.

| Name | Type | Description |
| - | - | - |
| `c1` | `number` | |
| `c2` | `number` | |
| `r1` | `number` | |
| `r2` | `number` | |

## `CellBlock`

Import from `@reductoai/xlsx/editor`, `@reductoai/xlsx/view`.

| Name | Type | Description |
| - | - | - |
| `c1` | `number` | |
| `c2` | `number` | |
| `drawings?` | `DrawingTarget[]` | The drawing objects a step moved, sized or deleted. |
| `r1` | `number` | |
| `r2` | `number` | |
| `sheet` | `number` | |

## `CellLink`

A cell's link as Insert Hyperlink shows it.

Import from `@reductoai/xlsx/editor`.

| Name | Type | Description |
| - | - | - |
| `address` | `string` | |
| `tip` | `string` | |

## `CellSizeKind`

Import from `@reductoai/xlsx/editor`.

```ts theme={null}
type CellSizeKind = "rowHeight" | "columnWidth" | "standardWidth"
```

## `CellSizes`

What Row Height, Column Width and Default Width show; null where the lines differ.

Import from `@reductoai/xlsx/editor`.

| Name | Type | Description |
| - | - | - |
| `columnChars` | `number \| null` | |
| `rowHeight` | `number \| null` | |
| `standardWidth` | `number` | |

## `Col`

Not exported by name. You get it from the API.

| Name | Type | Description |
| - | - | - |
| `hidden` | `boolean` | |
| `max` | `number` | |
| `min` | `number` | |
| `outlineLevel` | `number` | |
| `styleIndex?` | `number` | |
| `widthPx` | `number` | |

## `EditResult`

The result of a command: the cells it changed, for a host to repaint and select.

Import from `@reductoai/xlsx/editor`.

```ts theme={null}
type EditResult = CellBlock | null
```

## `FoundCell`

A cell Find matched, with the text it matched in.

Import from `@reductoai/xlsx/editor`.

| Name | Type | Description |
| - | - | - |
| `c` | `number` | |
| `r` | `number` | |
| `sheet` | `number` | |
| `text` | `string` | |

## `Hyperlink`

Not exported by name. You get it from the API.

| Name | Type | Description |
| - | - | - |
| `display?` | `string` | |
| `location?` | `string` | |
| `range` | `Merge` | |
| `target?` | `string` | |
| `tooltip?` | `string` | |

## `IgnoredError`

An `<ignoredError>` area and the checks it turns off there.

Import from `@reductoai/xlsx/view`.

```ts theme={null}
type IgnoredError = Merge & { rules: ErrorRule[] }
```

## `Mark`

Import from `@reductoai/xlsx/editor`.

```ts theme={null}
type Mark = "bold" | "italic" | "underline" | "strike"
```

## `OutlinePr`

Not exported by name. You get it from the API.

| Name | Type | Description |
| - | - | - |
| `summaryBelow` | `boolean` | |
| `summaryRight` | `boolean` | |

## `PenEdges`

What a pen stroke draws: a cell's side, a range's outline, or every line of it (Draw Border Grid).

Import from `@reductoai/xlsx/editor`.

```ts theme={null}
type PenEdges = "outline" | "grid" | "top" | "bottom" | "left" | "right"
```

## `PenMode`

Not exported by name. You get it from the API.

```ts theme={null}
type PenMode = "draw" | "grid" | "erase"
```

## `PenState`

Not exported by name. You get it from the API.

| Name | Type | Description |
| - | - | - |
| `color` | `string` | |
| `line` | `string` | |
| `mode` | `PenMode` | |

## `SavedSplit`

A saved split: bar offsets in twips (headers included), the top-left and bottom-right panes' first cells.

Not exported by name. You get it from the API.

| Name | Type | Description |
| - | - | - |
| `cols` | `"left" \| "right"` | |
| `inner` | `{ c: number; r: number }` | |
| `outer` | `{ c: number; r: number }` | |
| `rows` | `"top" \| "bottom"` | |
| `x` | `number` | |
| `y` | `number` | |

## `Sheet`

Import from `@reductoai/xlsx/view`.

```ts theme={null}
type Sheet = SheetTab & { autoFilterRange?: Merge; background?: string; cells: SheetCells; cfFormula?: CfFormula; cols: Col[]; comments: Comment[]; conditionalFormats: ConditionalFormat[]; date1904?: boolean; defaultColWidthPx: number; defaultRowHeightPx: number; drawings: Drawing[]; freeze?: Freeze; hyperlinks: Hyperlink[]; ignoredErrors?: IgnoredError[]; invalidCircles?: { c: number; r: number }[]; maxCol: number; maxRow: number; merges: Merge[]; outlinePr?: OutlinePr; pageBreaks?: { cols: number[]; rows: number[] }; pivots: Pivot[]; print?: PrintSetup; rows: ReadonlyMap<number, ViewRow>; savedView?: SavedView; showFormulas?: boolean; showGridLines: boolean; showHeadings?: boolean; showPageBreaks?: boolean; slicers?: ViewSlicer[]; sparklineGroups: SparklineGroup[]; tableFilterArrows: TableFilterArrow[]; tables: Table[]; validationDropdowns: ValidationDropdown[]; validationLists: string[][]; validationPrompts?: ValidationPrompt[]; zeroHeight?: boolean }
```

## `SheetCells`

Live cells of one sheet, read from the workbook's store; one-based.

Import from `@reductoai/xlsx/view`.

| Name | Type | Description |
| - | - | - |
| `forEach()` | `(fn: (cell: Cell) => void) => void` | |
| `forEachInRange()` | `(r1: number, r2: number, c1: number, c2: number, fn: (cell: Cell) => void) => void` | Present cells inside the rectangle, row-major. |
| `formula()` | `(r: number, c: number) => string \| undefined` | Formula as Excel shows it, with the leading `=`. |
| `get()` | `(r: number, c: number) => Cell \| undefined` | |
| `mayHavePictures()?` | `() => boolean` | False when no cell of the sheet can hold a picture, so a paint skips the pass. |
| `spill()?` | `(r: number, c: number) => { c1: number; c2: number; r1: number; r2: number } \| null` | The block a dynamic array spills into when the cell is in it; the anchor is its top-left. |

## `SheetTab`

What a sheet tab needs; cheap to build for every sheet.

Import from `@reductoai/xlsx/view`.

| Name | Type | Description |
| - | - | - |
| `index` | `number` | |
| `name` | `string` | |
| `state?` | `string` | |
| `tabColor?` | `Color` | |

## `TraceArrow`

A tracer arrow on `sheet`: from the cells read to the formula; null ends sit on another sheet.

Import from `@reductoai/xlsx/editor`.

| Name | Type | Description |
| - | - | - |
| `error` | `boolean` | The cells read hold an error: Excel draws the arrow red. |
| `from` | `{ c1: number; c2: number; r1: number; r2: number } \| null` | |
| `sheet` | `number` | |
| `to` | `{ c: number; r: number } \| null` | |

## `TraceKind`

Import from `@reductoai/xlsx/editor`.

```ts theme={null}
type TraceKind = "precedents" | "dependents"
```

## `WorkbookLayout`

Import from `@reductoai/xlsx/view`.

| Name | Type | Description |
| - | - | - |
| `activeSheetIndex?` | `number` | |
| `chartSheets?` | `ChartSheetView[]` | Chart sheets, each with the worksheet index its tab sits before. |
| `date1904?` | `boolean` | Serials count days from 1904-01-01. |
| `definedNames` | `DefinedName[]` | |
| `drawingContext` | `DrawingContext` | Theme colours, fonts and format scheme as DrawingML reads them. |
| `dxfs` | `Dxf[]` | |
| `sheets` | `SheetTab[]` | |
| `styles` | `Styles` | |
| `tableStyles` | `CustomTableStyle[]` | |
| `theme?` | `Theme` | |
| `chart()` | `(part: string) => ChartPart \| undefined` | A chart part with its caches rebuilt from the live cells, read once per layout. |
| `media()` | `(part: string) => Uint8Array<ArrayBufferLike> \| undefined` | Bytes of an image part. |
| `rels()` | `(part: string) => Relationship[]` | Relationships of a part, internal targets resolved to part names. |
| `sheet()` | `(index: number) => Sheet` | The full sheet, built on first use and kept for this layout. |
