TreeGrid v6.3
Gantt objects
The Gantt chart can show various objects, possibly all together in one cell:
Main bar or milestone – one solid bar, with percentage completion, supports also dependencies and resources
Real flow – one or more bars, as one non continuous flow, all in one color, adjacent bars are merged, supports also dependencies and resources
Flag – one or more icons in the cell, on specified dates, with defined tooltip text.
Run – one or more independent bars with different color, class and caption, supports also resources and dependencies. The dependency can be connected only to the first and last box.
Mark – one or more dates or date ranges to highlight.
Format – Text displayed right to main bar, milestone, run or flow (to the first object in GanttDependencyObjects)
Dependencies – lines between two tasks, the task can be defined by Main bar, milestone, Run or Flow (used in this order).
The Gantt chart sources for objects are usually other columns where are stored the source data in cells. These cells can be also edited by user and Gantt chart is automatically updated.
<C> string GanttOrder [“Chart,Constraints,Run,Main,Flow,Mark,Dependency,Format,Flags,Points”] new 6.3;upd.6.4.
Comma separated list of all Gantt objects to render, case insensitive.
The order of rendering the Gantt objects. The objects rendered later will overlay the previous objects in the same place.
The not listed Gantt objects are never rendered.
It affects also accessibility (interactivity) of the objects, they are accessible in reversed order.
<C> string GanttObject [“Main”] new 6.4 .
The main Gantt object. Permitted objects are Main, Flow, Run. Case insensitive.
It is used for attaching and calculating dependencies, for assigning and calculating resources and the GanttFormat is displayed next to it.
It can contain more comma separated objects to use the first one existing in the cell, in this order.
It replaces deleted GanttDependencyObjects attribute.
<C><cell> string GanttFormat [Resources] new 6.4 .
Text displayed right to GanttFormatObject object.
By default it displays GanttResources value.
It can display any HTML text. It can also show values from other cells in row, set by *col* where col is the column name.
For example: GanttFormat="$<span style='color:#77F'>*P*</span> *R*" => shows value from P column (as price) and from R column (as resources).
<C> string GanttFormatObject [“Last”] new 6.4 .
Object next the GanttFormat text will be displayed.
Last – the object from Main, Flow and Run positioned rightmost.
Object – GanttObject object
Main, Flow, Run – only for this object
If the selected object is not present in the cell, the text is not shown.
Main bar
Planned task - one continuous bar, only one per row
Defined by GanttStart (start date) and GanttEnd (due date) or by GanttStart (start date) and GanttDuration (length).
The main bar can show % of completion set by GanttComplete.
<C><cell> string GanttStart Gantt source – column name or exact value .
Start date of the main bar, usually column name, but can be also date string (M/d/yyyy hh:mm:ss) or count of milliseconds.
If the start date is edited, the bar is moved.
<C><cell> string GanttEnd Gantt source – column name or exact value upd 6.3 .
Due date of the main bar, usually column name, but can be also date string (M/d/yyyy hh:mm:ss) or count of milliseconds
The end date can be last date or last unit, depending on GanttEndLast setting (new in 6.3).
When the GanttEnd date is empty (or the column value it points to), the milestone is displayed instead of main bar.
If the end date is edited, the bar is resized.
<C><cell> string GanttDuration Gantt source – column name or exact value upd 6.3 .
Duration between start date and end date in GanttDataUnits. Can be column name or float or string.
The length can contain also unit modifier set by GanttDataModifiers, for example one day is usually 1d or 8h or 0.2w (new in 6.3).
When the GanttDuration date is empty or 0 (or the column value it points to), the milestone is displayed instead of main bar.
<C><cell> string GanttComplete Gantt source – column name or exact value .
% of completion (0 – 100) of the task, can be column name or float.
<C><cell> string GanttText Gantt source – column name or exact value new 6.0 .
Text displayed as tooltip when mouse hovers the main bar or milestone.
<C><cell> string GanttMainTip new 6.4 .
Tip shown on mouse hover the main bar, but not milestone. It can contain HTML code.
By default it shows the value of GanttText.
It can also show values from other cells in row, set by *col* where col is the column name.
It can show also the specials: *Text* - show the GanttText, *Start* - start date of the main bar, *End* - end date of the main bar, *Duration* - length of the main bar.
Example: “*Start* - *End*<br>*Text*”
formula float ganttpercent (string ganttcol, string weightcol, int round) chg 6.3 .
Calculates summary percent of all child rows for its date ranges
ganttcol – gantt column, if it is null, uses the first Gantt column in grid
weightcol – column with exact weight factors for the tasks, if not set, the weight is computed from the task duration.
round – to how many decimal places will be the result rounded, by default it is not rounded at all (new 6.3)
Example: <I Calculated=’1’ CalcOrder=”Complete” CompleteFormula=”ganttpercent()”/>
formula float ganttduration (string ganttcol) chg 6.3 .
Calculated summary duration for child rows. Use when the gantt is set by start and duration instead of start and end date.
It returns duration from the actual row start date to the maximal end date in its child rows. Returns value in GanttDataUnits.
ganttcol – gantt column, if it is null, uses the first Gantt column in grid
Example: <I Calculated=’1’ CalcOrder=”Duration” DurationFormula=”ganttduration()”/>
formula int ganttpercentduration (string durationcol, string percentcol=’’, int round=0) deleted 6.3.
Replaced by ganttpercent.
Deadline - one icon, only one per row, instead of main bar
Defined by GanttStart (exact date) with no GanttEnd / GanttDuration set.
In fact it is the main bar with void length.
<C><cell> string GanttStart Gantt source – column name or exact value .
The date of the milestone, usually column name, but can be also date string (M/d/yyyy hh:mm:ss) or count of milliseconds
<C><cell> string GanttText Gantt source – column name or exact value new 6.0 .
Text displayed as tooltip when mouse hovers the milestone.
<C><cell> string GanttMilestoneTip new 6.4 .
Tip shown on mouse hover the milestone, similar to GanttMainTip.
Real process of planned task - one or more discrete bars with the same meaning
Defined by GanttFlow (date ranges).
It is one task divided to one or more discrete parts. Adjacent parts are always merged to one part.
It can be discrete, can contain more date ranges. The first and last date in range are separated by tilde (~), ranges itself by semicolon (;).
<C><cell> string GanttFlow Gantt source – column name or exact value .
Real flow times, can be column name or date range string “d1~d2;d3~d4;d5;...” (date string (M/d/yyyy hh:mm:ss) or count of milliseconds).
These dates extend the displayed date range in chart when needed
The end date of range can be last date or last unit, depending on GanttEndLast setting.
<C><cell> string GanttFlowComplete Gantt source – column name or exact value new 6.4 .
% of completion (0 – 100) of the task, can be column name or float.
When set, the flow replaces the main task! It should not be used with main task!
This attribute is intended to use when the main task should be able to contain more parts, to replace it by Flow.
Remember, to attach dependencies to Flow instead of main task you need to set GanttObject=’Flow’.
<C><cell> string GanttFlowText Gantt source – column name or exact value new 6.0 .
Text displayed as tooltip when mouse hovers real flow bar.
<C><cell> string GanttFlowTip new 6.4 .
Tip shown on mouse hover the flow bar. It can contain HTML code.
By default it shows the value of GanttFlowText.
It can also show values from other cells in row, set by *col* where col is the column name.
It can show also the specials: *Text* - show the GanttFlowText, *Start* - start date of the bar, *End* - end date of the bar, *Duration* - length of the bar, *Index* - the bar index (from 1)
Example: “*Index*. *Start* - *End*<br>*Text*”
Information for date(s) - one or more different icons with tooltip per row
Defined by GanttFlags (date ranges) and GanttFlagTexts (texts for individual flags, displayed as tooltip).
Shows icons on defined dates and displays tooltip when mouse hover the icon
<C><cell> string GanttFlags Gantt source – column name or exact value .
A list of dates (separated by semicolon) where to display a flag with information specified by GanttFlagTexts.
It can be column name, a list of date string (M/d/yyyy hh:mm:ss) or a list of counts of milliseconds
<C><cell> string GanttFlagTexts Gantt source – column name or exact value .
A list of information for the individual flags. Separated by semicolon. This information is shown as hint (TITLE) for the flag. It can be column name or a list of strings
<C><cell> string GanttFlagIcons Gantt source – column name or exact value new 6.1 .
A list of icons for the individual flags. Separated by semicolon. The icon is the exact url of the icon.
<C><cell> string[*] GanttFlagIconList new 6.1 .
A list of predefined icons. The icon is the exact url of the icon. First character separated array.
This list is shown in popup menu to choose the flag icon.
<C><cell> string[*] GanttFlagIconNames new 6.1 .
It contains menu item names for the GanttFlagIconList. First character separated array.
The item name can contain %d to be replaced by the icon.
If not defined, the exact icon is shown as the item.
<C><cell> string GanttFlagsTip new 6.4 .
Tip shown on mouse hover the flag. It can contain HTML code.
By default it shows the value for the flag from GanttFlagTexts.
It can also show values from other cells in row, set by *col* where col is the column name.
It can show also the specials: *Text* - show the GanttFlagTexts, *Start* - date of the flag, *Index* - the flag index (from 1)
Example: “*Index*. *Start*<br>*Text*”
Point at date(s) - one or more different movable bullets
<C><cell> string GanttPoints Gantt source – column name or exact value new 6.4 .
The GanttPoints can be defined by four ways:
- Comma separated list of column names where are the individual values stored, for example GGanttPoints=’A,B,C’ A=’1/1/2000’ B=’2/1/2000’ C=’4/2/2000’
- Column name where are the column names stored, for example GGanttPoints=’X’ X=’A,B,C’ A=’1/1/2000’ B=’2/1/2000’ C=’4/2/2000’
- Direct list of values, comma or semicolon separated, it is not changeable, for example GGanttPoints=’1/1/2000;2/1/2000;4/2/2000’
- Column name where are the direct values stored, for example GGanttPoints=’X’ X=’1/1/2000;2/1/2000;4/2/2000’
<C><cell> string GanttPointsIcons Gantt source – column name or exact value new 6.4 .
A list of icons for the individual points. Separated by comma or semicolon. The icon is the exact url of the icon.
It can be also one of predefined classes 1 – 8, defined in Grid.css as GxGanttPoint1 – GxGanttPoint8:
1 – black, 2 – red, 3 – blue, 4 – green, 5 – pink, 6 – yellow, 7 – light blue, 8 - gray
<C><cell> string[] GanttPointsEdit new 6.4 .
If the individual points can be changed by a user. Comma separated list of 0/1 values.
<C><cell> string GanttPointsTip new 6.4 .
Tip shown on mouse hover the point. It can contain HTML code.
It can also show values from other cells in row, set by *col* where col is the column name.
It can show also the specials: *Start* - date of the point, *Index* - the point index (from 1), *Col* - name of the column where the point value is stored
Example: “*Col* = *Start*”
<C> int GanttPointsShift [3] new 6.4 .
Minimal distance between adjacent points.
If points are on the same place, the next will be shifted right for this value
Mark line, e.g. actual date - one or more vertical lines per row
Defined by GanttMark (date ranges).
It is a mark line showing some important date or deadline. It is often the same for whole column, but it need not be.
It is displayed above the other Gantt items, so the line should not be too thick.
<C><cell> string GanttMark Gantt source – column name or exact value .
Other times to mark in chart, useful for displaying actual date or vertically divide chart to bigger units or mark weekends and so on.
It can be column name or date range string “d1~d2;d3~d4;d5;...” (date string (M/d/yyyy hh:mm:ss) or count of milliseconds).
These dates do not extend the displayed date range in chart. When the date is outside the actual displayed range in chart, it is not shown.
<C><cell> string GanttMarkRound [‘m’] .
Mark rounding, to these units will be all dates in GanttMark rounded, possible values are the same as GanttUnits.
To display just thin vertical lines, set it to ‘m’, for thicker lines higher the value according to actual GanttUnits used.
.