Understanding cell coloring for changed data values
When you enter a new value in a personal workspace or sandbox, a visual indicator is
applied to the cell to remind you that the new value is different from the base values. The color of
the data changes from black to either blue or green, or the appearance of the cell changes,
depending on which component you are using. Any dependent cells, such as consolidated or rule
calculated cells, also change in appearance if your edits cause them to be recalculated.
The following table summarizes the cell coloring that is applied in the different TM1® user interfaces when you enter new data values in a sandbox or personal workspace.
A table that shows how different updates to cell contents change the color of the cell
contents. The Direct and Personal workspace or sandbox columns describe the potential writeback
modes.
|
Cell color |
Planning Analytics component |
Direct |
Personal workspace or sandbox |
|---|---|---|---|
|
Black |
Microsoft Excel |
When you input a new value, there is no color change. All values display in black. |
Committed personal workspace or Sandbox data. |
|
Blue |
Microsoft Excel |
None |
Newly input data. Edited cells, dependent or consolidated calls, recalculated cells |
|
Left bottom corner of cell displays in blue |
Microsoft Excel |
None |
Newly input data. Edited cells, dependent or consolidated calls, recalculated cells |
|
Green |
TM1 Web Cube Viewer and websheets |
New values |
New values |