allyhub inspect sheet
A workbook's facts, for you to judge, never problems: error values by cell, numbers written into formulas, a cell unlike its neighbours, what nothing reads, exceptions in calculated columns, values under a validation that breaks them, the rounds iterative calculation ran
allyhub inspect sheet [sheet] [options]Arguments
Section titled “Arguments”| Argument | Type | What it is |
|---|---|---|
<sheet> |
string | The sheet, by its file or its id in allyhub.yaml |
Options
Section titled “Options”| Option | Type | Default | What it does |
|---|---|---|---|
--kind |
list of string | Only facts of these kinds: sheet-error, sheet-number, sheet-unlike, sheet-exception, sheet-unused, sheet-invalid, sheet-typed, sheet-ordinary, sheet-iteration | |
--plain |
string | "0,1,-1" |
Numbers a formula may hold and not be said, by commas; –all says them too |
--around |
integer | 1 |
How many neighbours each side must read alike for a cell to be unlike them |
--all |
boolean | false |
Every finding on a line of its own, and every number in every formula, and a table’s columns nothing reads |
Global options
Section titled “Global options”--dir <value>: the project’s folder; default the one around where it is run. --json: print the result as JSON.
Examples
Section titled “Examples”allyhub inspect sheet finance/budgetallyhub inspect sheet finance/budget --kind sheet-error,sheet-numberallyhub inspect sheet finance/budget --plain 0,1,100 --allExit codes
Section titled “Exit codes”0 when it succeeds; the others are listed in Exit codes.
In the work
Section titled “In the work”sheets: Making a sheet
sheet capabilities → sheet import → sheet calc → sheet trace → sheet diff → inspect sheet → sheet → frames → check → dev → render