Spreadsheet Formatting Options

STATISTICA Spreadsheets support several formatting options, including cell-specific and in-cell formatting, formats, spreadsheet layouts, custom formats, and selection conditions.

Cell-specific formatting. Cell-specific formatting allows you to format individual or specific cells to distinguish them from the rest of the cells in the spreadsheet. You may assign a format to just one cell or a range of cells.

In-cell formatting. In-cell formatting refers to the ability to format a portion of the contents in a selected cell. For example, if a cell contains the text "Lot 1245," you can format the number "1245" to be in bold font, while leaving the word "Lot" in the default font style.

Formats. Formats are used in Statistica spreadsheets to apply a quick and consistent format. Using the Format Manager, you can create and edit formats, and apply formats to portions of your spreadsheet data. See also: Formats - Overview, Create a New Format, Apply a Format, Modify a Format, Delete a Format, Rename a Format, and Save a Format.

Spreadsheet layouts. Spreadsheet layouts are used in Statistica spreadsheets to assign formats to specific components associated with the entire spreadsheet. Using the Spreadsheet Layout Manager, you can create sets of formats to be applied to various components of a spreadsheet. See also: Spreadsheet Layouts - Overview, Create a New Spreadsheet Layout, Apply a Spreadsheet Layout, Modify a Spreadsheet Layout, Rename a Spreadsheet Layout, and Delete a Spreadsheet Layout.

Selection conditions. Additionally, the use of selection conditions (accessible from the System tab of the Spreadsheet Layouts dialog box), enables you to create formats that will be applied to cells if your predefined conditions are met in those cells.

Variable width and case height. You can change the width of variables (columns) and the height of cases (rows) to enhance the appearance of the spreadsheet. 

ToolTips for Cells. When placing your mouse pointer over a cell (hovering) whose content is not completely displayed, a ToolTip containing the full contents of the spreadsheet cell is displayed. When hovering over a text label, the ToolTip also displays the label's numeric value. When hovering over a cell containing a numeric value displayed as ####, because the column is too narrow, the ToolTip displays the full value of the cell using the current variable's display format. ToolTips are also displayed in the Variable and Case header cells if their contents are completely displayed.

Custom number formats. Statistica spreadsheets provide a standard list of custom number formats from which you can choose, or you can create your own custom format. See also: Custom Number Formats.

Variable names. You can change the format of variable names (i.e., bold, underline, italics, font color and font size) to increase their visibility in the spreadsheets. For a data set with several hundred variables, you could format variables of a particular type (e.g., dependent variables) in such a way as to make them easily recognizable in the spreadsheet. STATISTICA also displays formats applied to variable names (such as bold, underline, italics, and font color; as specified in the spreadsheet) in the variable selection dialog. For example, a variable formatted as Measure1 in the spreadsheet will be displayed as Measure1 in the variable selection dialog. Note that font size is not shown in the variable selection dialog. The variable name will automatically wrap to fit the variable (column) width.

See also: Spreadsheet Overview and Range of Numeric Values That Can Be Entered or Stored in Cells.