Modifying Styles Using the Excel Menu Bar

The Style Sheet Wizard is designed so you can easily take advantage of the Excel Style formatting settings and properly use the designed nVision Style naming convention. You can accomplish the same thing simply by opening a layout and selecting Format, and then Styles from the Excel menu bar. The Style dialog appears and you can create styles using the same naming convention as the Style Sheet Wizard.

The following examples show the naming convention for PS/nVision nPlosion styles. Note that if you apply the styles both from the Style Sheet Wizard and the Excel Menu Bar, the last applied style takes effect:

Field or Control Description

RxxH

The Header Style for any given level of a Row, where R represents a row, xx represents the number of the level (that is, 01, 02, and so on—00 represents the detail level), and H represents the Header Style.

RxxL

The Label Style for any given level of a Row, where R represents a row, xx represents the number of the level (that is, 01, 02, and so on—00 represents the detail level), and L represents the Label Style.

CxxA

The Amount Style for any given level of a column, where“ C represents a column, xx represents the number of the level (that is, 01, 02, and so on—00 represents the detail level), and A represents the Amount Style.

CxxB

The Base Style for any given level of a column, where C represents a column, xx represents the number of the level (that is, 01, 02, and so on—00 represents the detail level), and B represents the Base Style.

Note:

Detail Row and Column Style settings are represented by the 00 level.