Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info
titleINFO

The Workbook Inspector provides information about sheets, columns and formula, depending to the workbook type and content.

Image RemovedImage Added

NumberNameFunctionality
1'Sheet' tab
  • contains sheet related information
2Sheet type
  • displays the sheet type, e.g. formula sheet
3Columns options
  • displays all sheet columns and corresponding data type
4Sheet description
  • displays a sheet description or option to enter s sheet description
5'Column' type
  • contains column related information
6Column name
  • displays the column name
7Column description
  • displays a column description or option to enter a column description
8Data profile
  • displays data profile with visual information, e.g. rows with values, number of unique data
9'Formula' tab
  • contains all functions that you can apply to a sheet
10Formula search
  • search bar to find appropriate formula for data preparation
11Formula
  • displays all selectable formulas
12Formula description
  • provides information about a formula, e.g. formula syntax, formula description
13Formula settings field
  • displays options to modify and customize the formula
14'Add to Formular' button
  • adds the selected formula to the sheet
15'Browse Columns'
  • browses the columns

...