Skip to main content

ClearWhat

Import from @reductoai/xlsx/editor.

DeleteShift

Import from @reductoai/xlsx/editor.

FillDirection

Import from @reductoai/xlsx/editor.

FillSeries

Excel’s Series window. by fills each row or each column from its first cell. Linear adds step, Growth multiplies by it, Date adds step units; filling stops before a value past stop. trend fits the line’s numbers (least squares) and overwrites them too. Import from @reductoai/xlsx/editor.

FindQuery

Find and Replace’s options; what takes Excel’s *, ? and ~. Import from @reductoai/xlsx/editor.

GoToSpecial

One pick of Excel’s Go To Special window. One selected cell searches the sheet, a block searches itself. Import from @reductoai/xlsx/editor.

InsertShift

Import from @reductoai/xlsx/editor.

Merge

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

MergeHow

Import from @reductoai/xlsx/editor.

PasteOperation

The sum Paste Special makes of each pasted number and the number under it. Import from @reductoai/xlsx/editor.

PasteSpecial

Excel’s Paste Special: the held cells pasted in part, summed into the cells under them, or linked. Import from @reductoai/xlsx/editor.

PasteWhat

What Paste Special pastes, named as Excel’s XlPasteType. Import from @reductoai/xlsx/editor.

RemoteMerge

What another writer’s change did, as a shared session reports it. Import from @reductoai/xlsx-editor.

RemoveDuplicatesGuess

What Data > Remove Duplicates opens with: the list, the header guess, and a name per column. Import from @reductoai/xlsx/editor.

SortGuess

What Sort opens with: the range, whether its first row is headers, each column’s first-row text and each row; numbers when its first value is a number. Import from @reductoai/xlsx/editor.

SortLevel

One level of Sort: a sheet column, one-based (a sheet row when sorting left to right). Import from @reductoai/xlsx/editor.

SpecialValue

The value kinds Go To Special’s Constants and Formulas take; all four when left out. Import from @reductoai/xlsx/editor.

TextSplit

How Text to Columns cuts a cell’s text: at delimiter characters, or at character positions. Import from @reductoai/xlsx/editor.

ValidationDropdown

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

ValidationPrompt

The input message a validation shows while one of its cells is selected. Not exported by name. You get it from the API.

ValidationSpec

What the Data Validation dialog sets; a null rule is Any value. Import from @reductoai/xlsx/editor.

ValidationState

Import from @reductoai/xlsx/editor.