You can set default values for the rows in a time grid
attribute. The default value is applied to all cells in the row, except
for cells that contain manually entered information. You can edit
one row to update all sheets simultaneously. The time between the
start and end date must be the same for all sheets.
Before you begin
You must be an administrator to configure attributes. Default
values are numeric, and can be entered as expressions that are composed
of numbers or references to other cells, rows or attributes, combined
with the operators that are allowed in time grid attributes.
Procedure
- Click .
- Click the module to configure the time grid attribute in.
- Select a time grid attribute or click Add attribute and
select Time Grid.
- In Default Row Value, type a default
value for the row.
- Click OK.
Results
The new default value is applied to all cells in the rows
that are empty, or that have a previous default value.
Example
Default values are composed as expressions. The following
types of default row expressions are valid:
- Numbers: 100 or 3,14 (depends
on the locale)
- A reference to another cell within the sheet: ='A2'
- A reference to a corresponding cell in another row: ='A
row name'
- A reference to a float or integer attribute: ='An
attribute name'
- Any operator that is valid for the time grid attribute: +,-,/,*,
^
- A combination of numbers, references, and operators: =('A2'+'row
name')*100