| CalculationDiagnostic |
Something calculation noticed that is not visible in cell values alone. |
| Cell |
A handle to one cell position. |
| CellBorder |
One edge of a cell's border. |
| CellBorderStyle |
The lines Excel draws borders with. |
| CellColor |
A colour as Excel shows it, in sRGB. |
| CellFont |
The font of a cell's text. |
| CellHorizontalAlignment |
Where a cell's text sits across the cell. |
| CellRange |
A rectangle of cells on one sheet, such as A1:C10. |
| CellStyle |
How a cell looks in Excel: font, fill, borders, alignment and protection (locked, formula hidden). |
| CellUnderline |
How a font underlines text. |
| CellValue |
A value produced by a cell or a formula. |
| CellValueKind |
The kind of value a CellValue holds. |
| CellVerticalAlignment |
Where a cell's text sits from top to bottom of the cell. |
| ConditionalFormat |
A conditional format: which cells of its ranges it formats, and how. |
| ConditionalFormatType |
What a conditional format looks at, as Excel's New Formatting Rule dialog offers it. |
| ConditionalOperator |
How a ConditionalFormatType.CellValue rule compares the cell's value with its formulas. |
| ConditionalStyle |
What a conditional format changes about a cell's look, as Excel's Format Cells for a rule sets it: the font's style and colour, the fill, the borders and the number format. |
| DataValidation |
A data validation rule: what the cells of a range accept and the messages Excel shows for them. |
| DateSystem |
The workbook's date system: which day serial number 0 or 1 stands for. |
| DefinedName |
A defined name as Workbook.DefinedNames lists it. |
| DeleteShift |
Which cells take the place of deleted cells, as in Excel's Delete dialog. |
| DiagnosticKind |
What a CalculationDiagnostic reports. |
| ErrorKind |
Excel error values. |
| ErrorKinds |
Conversion between ErrorKind and its literal text (#DIV/0!). |
| FormulaParseException |
Thrown when formula text cannot be parsed. |
| FunctionArguments |
The arguments of one call of a function added through Workbook.Functions. |
| FunctionCollection |
The functions a workbook's formulas can call besides Excel's: add one with FunctionCollection.Add, and formulas calling it by name (ignoring case) use it from the next calculation on. |
| FunctionOptions |
How a function added through Workbook.Functions takes its arguments. |
| Hyperlink |
A hyperlink on a cell: a web or e-mail address, a file, or a place in the workbook. |
| InsertShift |
Where the cells beside inserted cells go, as in Excel's Insert dialog. |
| IterationSettings |
Iterative calculation, Excel's "Enable iterative calculation": circular references are calculated over and over until they settle, instead of giving 0. |
| LambdaValue |
A function value produced by LAMBDA. |
| Note |
A note on a cell: Excel's Insert Note (called a comment before Excel 365), shown in a box beside the cell, by default only while the pointer rests on it. |
| PageMargins |
The margins of a printed sheet in inches, as in Excel's Page Setup > Margins: the space around the cells, and how far the header and footer are from the top and bottom edges. |
| PageOrientation |
How a sheet is turned on the printed page, as in Excel's Page Layout > Orientation. |
| RecalculationResult |
What one Workbook.Recalculate did. |
| SheetProtection |
What users may still do on a protected sheet, as Excel's Protect Sheet dialog lists it: by default they may select cells and nothing else. |
| Table |
An Excel table: a named range with column names, an optional header row and an optional totals row. |
| TimePeriod |
The periods of Excel's A Date Occurring rule, counted from today. |
| ValidationErrorStyle |
What Excel does when a value breaks a rule. |
| ValidationOperator |
How a value is compared with a rule's formulas; lists and custom rules do not compare. |
| ValidationType |
What a data validation rule lets a cell hold, as Excel's Data Validation dialog names it under Allow. |
| Workbook |
A workbook: sheets, defined names and calculation settings. |
| Worksheet |
A sheet of a Workbook. |