LiveView Formatting

Formatting lets you format the appearance of the cell; such as font, font size, and color.

NOTE: Formatting changes become visible only after you click outside of the cell that you change.

To use cell formatting: 

  1. In LiveView Template Editor, click the Formatting sub-tab.

    2. A formatting toolbar displays on the screen. It allows you to set the appearance of the cells in the template.

  2. To format a cell or range of cells, select the cell or cells. When you select a format, the active cells will be set to the specified format attribute. When a cell becomes active, the format selections on the toolbar will reflect the selections for that cell. When you select multiple cells, the format selections will reflect those of the first cell you select.
  3. Format the cell appearance by choosing the following:
    1. Font and font size
    2. Bold, italics, or underline
    3. A font color (default is black), and for the background of the cells (default is white)
    4. Horizontal alignment: flush left, centered, or flush right.
    5. Vertical alignment: top, center, or bottom.
    6. If more than one cell is selected, Merge Cells is enabled. Check this box to merge the selected cells into one large cell.
    7. In the Data Type drop-down box, select the type of data that will be in the selected cell(s):
      • Text (default); the Wrap Text box displays; check this box if you want text to wrap and stay within the cell.
      • Date: In the Format field that displays, type the format you want to use (Excel formatting is supported):
        24-hour format: m/d/yy h:mm:ss
        AM/PM format: m/d/yy h:mm:ss AM/PM or m/d/yy hh:mm:ss AM/PM
      • Number: In the Decimal Places field that displays, choose the number of decimal places you want; if desired, check the Use 1000 Separator box to insert the separator (for example, comma, depending on your regional settings).
  4. You can resize the row height or column width by dragging row/column header. A tooltip displays the height or width as you resize it.
  5. Alternatively, right click anywhere in the template to display a context menu that allows you to insert or remove columns or rows, or to type the column width and row height.
  6. Save your changes.