YSI BODAnalyst - Manual (Page 51)

Reports Section 8
YSI Incorporated BOD Analyst for Windows Software 47
8.4 FORMATTING CELLS
The BOD Analyst software Report Designer offers great flexibility in formatting cells. All
formatting is accomplished using the items on the Format menu. This menu also provides for
the insertion of page breaks.
Format, Font opens the font dialog with which font settings can be changed for the current cell
or an entire block of cells. Settings for font color are ignored here. The background color and
foreground color (font color) are set using Format, Cell Colors.
To toggle the cell type between text and numeric, use Format, Cell. When OK is selected on the
Format Cell dialog, the settings are applied to all selected cells. If Text is selected as the Cell
Type, checking the Multiline Edit box causes text to wrap to multiple lines in a single cell as
shown in the example below. The row height must be able to accommodate the number of rows
required if multiline edit is selected. With Mulitiline Edit off, text overlaps to the cell to the right
if that cell is empty.
Borders can be specified by choosing Borders from the Format menu. Select which borders are
to be drawn for the selected cell or group of cells and click the OK button.
Note: Borders and the grid are not the same thing. The grid cannot be changed and is not
printed. Borders are always printed.
Cell Colors are changed using the Cell Colors item of the Format menu. Set the background or
foreground color by clicking the appropriate SET COLOR button. An example of the new
settings is presented at the bottom of the dialog.
Page breaks are added and deleted using the Format menu. Row Page Break, Add sets a page
break on the current row. When printing the spreadsheet, the row containing the page break is the
first row printed on the new page. The row header of the row containing the page break will have
a red border. Row Page Break, Remove removes an existing row page break. You must move to
the row containing the page break to remove it. Col Page Break, Add sets a page break at the
current column. When printing the spreadsheet, the column containing the page break is the first
column printed on the next page. The column header of the column containing the page break
will have a red border. Col Page Break, Remove removes a column page break. You must move
to the column containing the page break to remove it.