In PS/nVision, the styles for your summary rows and columns come directly from the styles that you have defined in the summary rows and columns in your layout. You define nPlosion styles either by using Style Sheet Wizard or by directly applying the styles from the Excel menu bar using PS/nVision nPlosion style naming conventions.


You can use the Style Sheet Wizard exclusively to create and edit nPlosion styles, which are stored in a special Excel worksheet provided with PS/nVision. There are two kinds of nPlosion styles:


•The RowStyles tab displays Row styles.

•TheColumnStyles tab displays Column styles.


Seven levels of each style are provided, as well as a separate style for detail values. The Style sheet Classical.xls is shipped with PS/nVision. Create your own style sheet wizard by saving the Classical.xls file under a different name in the Style Sheet directory location. Configure the Style Sheet directory location using Configuration Manager.


Note. You can override the Base style by modifying any of the other styles that come after it. For example, you could make a particular field shaded, even though the base style for that row or column does not include shading.


When opened, the Style Sheet Wizard displays a rollup of data for eight rows and eight columns (Excel has a limitation of rolling data up into only eight outlines). The following are the four types of styles that you can apply to each row and column:



An outlined row or column of data has two parts. When opened, the top portion of the outline is considered the header, and the bottom portion is considered the Label. The Heading does not contain any data; it is strictly for display purposes.



The bottom portion of the outline. The Label is the only thing displayed if the outline is collapsed.



Any numeric data that will be a result of an nPlosion.



The formatting options for the Heading, Label, and Amount styles. If there are style settings for the Label, Heading, or Amount, they will override the Base Style setting. 


Note. If you apply the styles both from the Style Sheet Wizard and the Excel Menu Bar, the last applied style takes effect.


In this exercise, you will use style sheets with nPlosion layouts.

Table of Contents