Sets the font of the cells specified by the start and end clusters or by a named range.


icon

Inputs/Outputs

  • ci32.png auto format —

    auto format sets the cell format using Excel preset table styles. The default is no formatting.

    In Excel, select Format»AutoFormat to view examples of Excel table styles.

  • cNI__reportlvclass.png —

    report in is a reference to the report whose appearance, data, and printing you want to control. Use the New Report VI to generate this LabVIEW class object.

  • ccclst.png font —

    font sets the font attributes that the VI uses when formatting.

    The VI ignores this input if you wire the autoformat input.

  • cstr.png font name —

    font name specifies the name of the font you want to use, such as Times New Roman.

    If you misspell the font name or specify a font that is not installed on the computer, the operating system selects a font.

  • cdbl.png font size —

    font size specifies the size at which you want the font to appear, in points.

  • cu16.png bold —

    bold specifies whether the text is in bold. The default is bolded text.

  • cu16.png italic —

    italic specifies whether the text is in italics. By default, the control does not change the text settings.

  • cu16.png underline —

    underline specifies whether the text is underlined. By default, the control does not change the text settings.

  • cu16.png strike through —

    strike through specifies whether the text contains a strikethrough line. By default, the control does not change the text settings.

  • cu32.png font color —

    font color allows you to select the color of the font from a color table. The default is transparency.

  • cnclst.png start (-1, -1) —

    start determines the range of cells that the VI will format.

    If neither start nor end are wired, the VI formats the used section of the worksheet. If start is wired but end is unwired, the VI formats the unique cell specified by start. If neither row nor column are equal to –1, the VI formats the corresponding cell. If row is equal to –1, the VI formats the entire column. If column is equal to –1, the VI formats the entire row. If both start and end are wired, the VI formats the range of cells between start and end.

  • ci32.png row —

    row represents the index of the first row of the range to format.

  • ci32.png column —

    column represents the index of the first column of the range to format.

  • cnclst.png end (-1, -1) —

    end determines the range of cells that the VI will format.

    If neither start nor end are wired, the VI formats the used section of the worksheet. If start is wired but end is unwired, the VI formats the unique cell specified by start. If neither row nor column are equal to –1, the VI formats the corresponding cell. If row is equal to –1, the VI formats the entire column. If column is equal to –1, the VI formats the entire row. If both start and end are wired, the VI formats the range of cells between start and end.

  • ci32.png row —

    row represents the last row index.

  • ci32.png column —

    column represents the last column index.

  • cerrcodeclst.png error in (no error) —

    error in describes error conditions that occur before this node runs. This input provides standard error in functionality.

  • cstr.png name ("") —

    name specifies the named range to format.

  • iNI__reportlvclass.png —

    report out is a reference to the report whose appearance, data, and printing you want to control.

    You can wire this output to other Report Generation VIs.

  • ierrcodeclst.png error out —

    error out contains error information. This output provides standard error out functionality.