Difference between revisions of "Conditional Formatting Actions for OnePager Express for Version 7.0"
From OnePager Documentation
| Line 1: | Line 1: | ||
==Summary of Conditional Formatting Rule Actions== | ==Summary of Conditional Formatting Rule Actions== | ||
| − | The purpose of this article is to summarize the discussion on telling OnePager what actions to take when a rule '''does''' apply. | + | 1) The purpose of this article is to summarize the discussion on telling OnePager Express what actions to take when a rule '''does''' apply. |
| − | For this purpose, there are six (6) fields that you can set to format the tasks/milestones. | + | 2) For this purpose, there are six (6) fields that you can set to '''conditionally format''' the tasks/milestones. |
| + | |||
| + | 3) These fields are described in the table below, which gives the '''name''' of the field in the '''Conditional Formatting Rules''' form, a '''description''' of the allowable options, and how you specify the '''formatting action''' to take: | ||
{| class="wikitable" | {| class="wikitable" | ||
| − | ! style="text-align: center; font-weight: bold;" | Conditional Formatting | + | ! style="text-align: center; font-weight: bold;" | Conditional Formatting Form Columns |
! style="font-weight: bold;" | Description | ! style="font-weight: bold;" | Description | ||
! style="font-weight: bold;" | Instructions | ! style="font-weight: bold;" | Instructions | ||
| Line 12: | Line 14: | ||
| Color | | Color | ||
| If the condition is true, apply the selected fill color to the task/milestone. If the condition is not true, retain the default color for the task/milestone. | | If the condition is true, apply the selected fill color to the task/milestone. If the condition is not true, retain the default color for the task/milestone. | ||
| − | | Click the | + | | Click the Color dropdown to pop up the Standard Color Chooser form. |
|- | |- | ||
| − | | | + | | Taskbar Shape |
| If the condition is true, use the selected shape to represent the task. If the condition is not true, the task retains its default shape. | | If the condition is true, use the selected shape to represent the task. If the condition is not true, the task retains its default shape. | ||
| − | | Click the | + | | Click the Taskbar Shape dropdown to pop up the taskbar shape list. |
|- | |- | ||
| Milestone Shape | | Milestone Shape | ||
| If the condition is true, use the selected shape to represent the milestone. If the condition is not true, the milestone retails its default shape. | | If the condition is true, use the selected shape to represent the milestone. If the condition is not true, the milestone retails its default shape. | ||
| − | | Click the | + | | Click the Milestone Shape dropdown to pop up the milestone shape list. |
|- | |- | ||
| − | | Height | + | | Height % |
| The height of the task/milestone in the rule is expressed as a percentage of row height. If the condition is true, resize the task/milestone to the specified height. If the condition is not true, the task/milestone retains the global default height. | | The height of the task/milestone in the rule is expressed as a percentage of row height. If the condition is true, resize the task/milestone to the specified height. If the condition is not true, the task/milestone retains the global default height. | ||
| Any positive number can be used. | | Any positive number can be used. | ||
|- | |- | ||
| Border | | Border | ||
| − | | The border properties of the task/milestone in the rule can be changed to the values specified in the '''Border style rules''' form. If the condition is true, use the border properties specified in the'''Border style rules''' form. If the condition is not true, use the default border properties for the task/milestone. | + | | The border properties of the task/milestone in the rule can be changed to the values specified in the '''Border style rules''' form. If the condition is true, use the border properties specified in the '''Border style rules''' form. If the condition is not true, use the default border properties for the task/milestone. |
| − | | Click the | + | | Click the Border dropdown to pop up the border list. You can set the border’s color, width, and style (solid, dash, dot, etc.) |
|- | |- | ||
| Label Font | | Label Font | ||
| − | | The task/milestone’s label font can be changed to the value specified in font selector. If the condition is true, use the label font specified. If the condition is not true, use the default | + | | The task/milestone’s label font can be changed to the value specified in font selector. If the condition is true, use the label font specified in the '''Font properties''' form. If the condition is not true, use the default Label font. |
| − | | Clicking the font cell pops up the font selector. You can set the font face, color, size, and style ('''bold''', ''italic'', [[underline]]) | + | | Clicking the Label font cell pops up the font selector. You can set the font face, color, size, and style ('''bold''', ''italic'', [[underline]]) |
| + | |- | ||
| + | | Priority | ||
| + | | The priority in the rule is established by OnePager and stepped by one each time a rule is added. See the next section for more details. | ||
| + | | Positive integer numbers are used. | ||
| + | |- | ||
| + | | Legend Text | ||
| + | | The legend text property of the task/milestone in the rule can be changed in the Legend to the value specified. If the condition is true, use the Legend text specified in the Legend text cell. If the condition is not true, use the default Legend text. | ||
| + | | Any text string. | ||
| + | |- | ||
| + | | Text Location | ||
| + | | The text location property of the task/milestone in the rule can be changed using the text location dropdown in the cell. If the condition is true, use the Text Location value in the Text Location cell. If the condition is not true, use the default text location. | ||
| + | | Select any of the eleven (11) available text locations. | ||
|} | |} | ||
| − | == | + | ==Priority== |
| − | 1) The last column | + | 1) The third from the last column on the far right in the '''Conditional Formatting Rules''' window is the '''Priority''' column. |
| − | 2) The ''' | + | 2) The '''Priority column''' controls the sequence in which the rules get applied. |
| − | 3) | + | 3) OnePager automatically assigns increasing numbers to the '''Priority column''' as rules are defined. |
| − | 4) You can change the | + | 4) If several rules are in competition to set a particular formatting property, the rule with the lowest '''Priority number''' has priority over all the others. |
| + | |||
| + | 5) You can change the values in the '''Priority column''' at any time after the rule is completely defined, and any numeric value is acceptable. | ||
| + | |||
| + | ==Legend Text== | ||
| + | |||
| + | 1) The next to last column to the right is the '''Legend Text column'''. | ||
| + | |||
| + | 2) Whenever the result of a '''Conditional Import''' set of rules results in a '''Legend''' entry being created, you can provide the '''text''' for that '''Legend''' entry by providing appropriate text in the '''Legend Text''' column for the applicable rule. | ||
| + | |||
| + | ==Text Location== | ||
| + | |||
| + | 1) The last column to the right is the '''Legend Text Location''' column. | ||
| + | |||
| + | 2) Whenever the result of a '''Conditional Formatting''' set of rules results in a '''Text Label''' entry being created, you can provide the '''text label position''' for that '''Text Label''' entry by selecting from one of the eleven (11) standard text locations provided in the dropdown. | ||
==No Action Taken== | ==No Action Taken== | ||
| − | When defining rules, any action field (e.g., color, task bar shape, milestone shape, borders, etc.) that is left blank is interpreted by OnePager as a '''no action''' | + | 1) When defining rules, any action field (e.g., '''color, task bar shape, milestone shape, borders''', etc.) that is left blank is interpreted by OnePager as a '''no action'''. |
| + | |||
| + | 2) This amounts to retaining the default setting for that property. | ||
| + | |||
| + | 3) If you want to '''edit''' an action become a '''no action''', just check the '''use default''' checkbox for the grid cell in question. | ||
==Number of Rules== | ==Number of Rules== | ||
| − | You can apply the approach described above to define as many rules as required. When you are finished, click '''OK''' in the '''Conditional Formatting Rules''' form which returns you to your starting place in the '''Task Bar''' tab or the '''Milestones''' tab. Click the '''Apply''' button and or '''OK''' buttons in the '''Chart Properties''' form to have OnePager apply the rules to the chart. For the '''Template Properties''' form, click the '''Save and Use''' button to have OnePager | + | 1) You can apply the approach described above to define as many rules as required. |
| + | |||
| + | 2) When you are finished, click the '''OK''' button in the '''Conditional Formatting Rules''' form which returns you to your starting place in the '''Task Bar''' tab or the '''Milestones''' tab. | ||
| + | |||
| + | 3) Click the '''Apply''' button and or '''OK''' buttons in the '''Chart Properties''' form to have OnePager apply the rules to the chart. | ||
| + | |||
| + | 4) For the '''Template Properties''' form, click the '''Save and Use''' button to have OnePager apply these rules to any chart that is created from the '''Template'''. | ||
(11.8.1-70) | (11.8.1-70) | ||
Revision as of 14:24, 23 September 2019
Contents
Summary of Conditional Formatting Rule Actions
1) The purpose of this article is to summarize the discussion on telling OnePager Express what actions to take when a rule does apply.
2) For this purpose, there are six (6) fields that you can set to conditionally format the tasks/milestones.
3) These fields are described in the table below, which gives the name of the field in the Conditional Formatting Rules form, a description of the allowable options, and how you specify the formatting action to take:
| Conditional Formatting Form Columns | Description | Instructions |
|---|---|---|
| Color | If the condition is true, apply the selected fill color to the task/milestone. If the condition is not true, retain the default color for the task/milestone. | Click the Color dropdown to pop up the Standard Color Chooser form. |
| Taskbar Shape | If the condition is true, use the selected shape to represent the task. If the condition is not true, the task retains its default shape. | Click the Taskbar Shape dropdown to pop up the taskbar shape list. |
| Milestone Shape | If the condition is true, use the selected shape to represent the milestone. If the condition is not true, the milestone retails its default shape. | Click the Milestone Shape dropdown to pop up the milestone shape list. |
| Height % | The height of the task/milestone in the rule is expressed as a percentage of row height. If the condition is true, resize the task/milestone to the specified height. If the condition is not true, the task/milestone retains the global default height. | Any positive number can be used. |
| Border | The border properties of the task/milestone in the rule can be changed to the values specified in the Border style rules form. If the condition is true, use the border properties specified in the Border style rules form. If the condition is not true, use the default border properties for the task/milestone. | Click the Border dropdown to pop up the border list. You can set the border’s color, width, and style (solid, dash, dot, etc.) |
| Label Font | The task/milestone’s label font can be changed to the value specified in font selector. If the condition is true, use the label font specified in the Font properties form. If the condition is not true, use the default Label font. | Clicking the Label font cell pops up the font selector. You can set the font face, color, size, and style (bold, italic, underline) |
| Priority | The priority in the rule is established by OnePager and stepped by one each time a rule is added. See the next section for more details. | Positive integer numbers are used. |
| Legend Text | The legend text property of the task/milestone in the rule can be changed in the Legend to the value specified. If the condition is true, use the Legend text specified in the Legend text cell. If the condition is not true, use the default Legend text. | Any text string. |
| Text Location | The text location property of the task/milestone in the rule can be changed using the text location dropdown in the cell. If the condition is true, use the Text Location value in the Text Location cell. If the condition is not true, use the default text location. | Select any of the eleven (11) available text locations. |
Priority
1) The third from the last column on the far right in the Conditional Formatting Rules window is the Priority column.
2) The Priority column controls the sequence in which the rules get applied.
3) OnePager automatically assigns increasing numbers to the Priority column as rules are defined.
4) If several rules are in competition to set a particular formatting property, the rule with the lowest Priority number has priority over all the others.
5) You can change the values in the Priority column at any time after the rule is completely defined, and any numeric value is acceptable.
Legend Text
1) The next to last column to the right is the Legend Text column.
2) Whenever the result of a Conditional Import set of rules results in a Legend entry being created, you can provide the text for that Legend entry by providing appropriate text in the Legend Text column for the applicable rule.
Text Location
1) The last column to the right is the Legend Text Location column.
2) Whenever the result of a Conditional Formatting set of rules results in a Text Label entry being created, you can provide the text label position for that Text Label entry by selecting from one of the eleven (11) standard text locations provided in the dropdown.
No Action Taken
1) When defining rules, any action field (e.g., color, task bar shape, milestone shape, borders, etc.) that is left blank is interpreted by OnePager as a no action.
2) This amounts to retaining the default setting for that property.
3) If you want to edit an action become a no action, just check the use default checkbox for the grid cell in question.
Number of Rules
1) You can apply the approach described above to define as many rules as required.
2) When you are finished, click the OK button in the Conditional Formatting Rules form which returns you to your starting place in the Task Bar tab or the Milestones tab.
3) Click the Apply button and or OK buttons in the Chart Properties form to have OnePager apply the rules to the chart.
4) For the Template Properties form, click the Save and Use button to have OnePager apply these rules to any chart that is created from the Template.
(11.8.1-70)
