XlsxEditor
Home-tab edits of a workbook: every command acts on the selection through the Excel.* facade
and is one step of the same undo history the grid’s typing uses.
Import from @reductoai/xlsx/editor.
XlsxEditor properties
apply()
arrows()
cellSizes()
cfGuess()
cfRules()
chart()
chartData()
chartSource()
contextMenu()
target, as data; each entry’s command goes back through apply.
filtered()
find()
step -1 for Find Previous): the match becomes the active cell; a searched block stays selected.
findAll()
format()
frozen()
gridlines()
headings()
inTable()
link()
mergeDiscards()
names()
note()
noteShown()
pageSetup()
read()
advancedFilterGuess, removeDuplicatesGuess) on the session and selection.
sample()
code shows it, for Format Cells’ Sample.
scenarios()
scenarioValues()
changing, as Add Scenario offers them.
slicerSettings()
name; null when there is none.
sortGuess()
sparkline()
stepNote()
step -1 for Previous): the next note or comment’s cell becomes active.
subtotalGuess()
tableGuess()
textColumnsPreview()
thread()
usableNames()
validation()
contextMenu()
@reductoai/xlsx/editor.