Creating Spreading Patterns

  To add a custom spreading pattern:

1. Open the HSP_SPREAD_PATTERN database table.

2. Enter row values to name and represent how values are spread from a parent cell:

   Table 85.  HSP_SPREAD_PATTERN Table

   Column	Description
   NAME — VARCHAR (80) UNIQUE NOT NULL	Internal name (not displayed)
   LABEL — VARCHAR (80) NOT NULL	Reference to a string ID in the resource file, which displays in the user interface. If a string resource is not created, the LABEL string identifier displays instead (for example “Label_Spread_445”).
   PATTERN VARCHAR (255) NOT NULL	Space delimited; one or more elements, up to 255 characters: A number: For example, to specify that the parent value splits evenly across its children, specify 1. !: Lock; do not change the value of a cell that has “!” as its pattern element. P: Parent value being spread. A child receives the exact value the parent receives. *: Repeat the element that follows. Use 1* to repeat 1 for every cell, to take up the rest of the space in the applied pattern. If no * exists as part of an element within a pattern, the entire pattern repeats itself instead of a specific element. A pattern cannot contain only the * character, and can have only one element with the * character. For example, 1 2* 3 is allowed, but 1 2* 3* is not.

3. Save and close the table.

   The new patterns display as spreading options on the Grid Spread and Mass Allocate dialog boxes.