#####   ######  #####    ###    #   #  ###  #   #  ######
##  ##  ##      ##  ##  ## ##   #   #   #   #   #  ##
#####   ####    #####   #   #   #   #   #   #   #  ####
##  #   ##      ##      ## ##    # #    #    # #   ##
##   #  ######  ##       ###      #    ###    #    ######

$ curl repovive.com/roadmaps/frontend-system-design-interview-prep/spreadsheet-design/copy-and-paste

░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░████████████████████████████████████████████████████████████████████████████████████████████████████

#####   ######  #####    ###    #   #  ###  #   #  ######
##  ##  ##      ##  ##  ## ##   #   #   #   #   #  ##
#####   ####    #####   #   #   #   #   #   #   #  ####
##  #   ##      ##      ## ##    # #    #    # #   ##
##   #  ######  ##       ###      #    ###    #    ######

$ curl repovive.com/roadmaps/frontend-system-design-interview-prep/spreadsheet-design/copy-and-paste

Repovive

Copy and Paste - Spreadsheet Design | Frontend System Design Interview Prep | Repovive

Repovive.

Frontend System Design Interview Prep17 sections · 206 units12h total

Open in Course

Copy and Paste

Clipboard operations

Copy/paste must work within app and with external sources.

Internal copy:

$1.$ Store selected cells in internal clipboard

$2.$ Track relative positions

$3.$ On paste, apply to new location

System clipboard:

// Copy to system clipboard as TSV
const text = selectionToTSV(selectedCells);
navigator.clipboard.writeText(text);

// Paste from system clipboard
const text = await navigator.clipboard.readText();
const cells = parseTSV(text);

Formula adjustment: When copying "=A1+1" from B1 to C1, adjust to "=B1+1".