# Paste Special, Find and Replace, and structural edits The three Excel operations that write more than one cell, plus freeze panes. ```ts import { parseClipboard, buildClipboardPayload, planPaste, resolvePasteCell, findAll, replaceAll, setFindTarget, insertRows, deleteColumns, setStructureTarget, splitFrozenRows, freezeAtActiveCell, } from '@svgrid/enterprise/sheet' ``` All of them run inside `cmd.batch()`, so each is **one** `Ctrl+Z`. ## Paste Special ### Why the clipboard needed an HTML flavour The grid's clipboard is TSV only: `writeText` out, `readText` in. Values survive; formats, formulas and merges do not. Excel writes both `text/plain` and `text/html` and reads the HTML back when it is there, so matching that is what makes a round trip work. `buildClipboardPayload` produces both: ```ts const { text, html } = buildClipboardPayload(grid, { row: 2, col: 0 }) await navigator.clipboard.write([ new ClipboardItem({ 'text/plain': new Blob([text], { type: 'text/plain' }), 'text/html': new Blob([html], { type: 'text/html' }), }), ]) ``` The HTML is a plain ``. Formats ride on inline styles every app reads, with Excel's own `mso-number-format` beside them so Excel keeps the number format rather than guessing one from the text; the number behind a formatted display rides in Excel's `x:num`; the formula travels in a `data-formula` attribute they all ignore. So a paste into Excel keeps the look and the numbers, and a paste back into the grid keeps the formula. `parseClipboardHtml` reads the other direction. Excel's clipboard puts every cell's format in a `