Altair® Monarch®

 

Refining Traps

A Trap has four possible property components:

  • Value

  • Font

  • Alignment

  • Cell Properties

You can review the trap components by selecting the edit icon beside a trap:

 

Initially, the Value tab is displayed:

 

At this point you can:

  • Refine cell value rules

  • Add a new value rule.

  • Select the Font, Align, or Cell tabs to edit Font, Alignment, or Cell Format trapping rules.

Trap Components

Value

The Value tab allows you to define traps according to the values in a cell.

 

Notes:

  • The drop-down allows you to select valid Value rules:

  •  

  • Some rules will require you to enter a specific value. For example, Starts With, will display a text box:

  •  

  • You can define more than one value rule, for example:

  •  

    In case of multiple value rules, the rules are combine using the AND logical operation.

  • If you define contradicting value rules, for example:

  •  

    no values will be extracted.

  • Select the delete icon (red x) beside a value to delete it.

  • Together with the value rules, you can also check the following:

    • Case Sensitive to ensure that text values are strictly applied with respect to letter case. For example if your value is Starts With "NORTH" and Case Sensitive is checked, values that start with "north" will be ignored.

    • Negate to follow the opposite rule instead

Font

The Font tab allows you to define traps according to Font properties.

 

Notes:

  • Font properties include:

    • Font Name

    • Font Size

    • Font Color

    • Font face: bold, italicized, underlined

  • For Font color, set  the RGB values in the boxes provided. Use the eyedropper tool: select the tool (dropper color will change from white to black) and then click on the cell you want to pick the color from.

  • You can select or unselect all the font rules as needed.

  • Select Negate follow the opposite of the rule instead

Align

The Align tab allows you to define trap according to alignment properties.

 

Notes:

  • You can select or unselect all the alignment rules as needed.

  • Select Negate follow the opposite of the rule instead

Cell

The Cell tab allows you to define a trap according to cell decoration properties.

 

Notes:

  • Cell decorations include:

    • Background

    • Left Border

    • Right Border

    • Top Border

    • Bottom Border

  • You can set the background and border colors in two ways:

  • For color-related values, set  the RGB values in the boxes provided. Use the eyedropper tool by selecting the tool (dropper color will change from white to black) and then clicking on the cell you want to pick the color from.

  • You can select or unselect all the cell decoration properties as needed. For some properties you will need to set specific values.

  • Select Negate follow the opposite of the rule instead