Presentation
Dynamic presentation functions are only available and usable in dynamic presentation formulas applied to the cells of a grid.
When a style needs multiple layout functions, use Block to combine them.
See all of the Functions.
| BackgroundImage | Returns a string describing a background image. |
| BarChart | Creates a horizontal bar chart in the cell. |
| Block | Defines a block of presentation expressions to run sequentially |
| CellValue | Returns the value of the cell being formatted by the dynamic display. |
| ColorLerp | Calculates an intermediate color between two colors. |
| Fill | Determines the color or appearance of the fill for the cell's background. |
| FontColor | Determines the font color of the text in a cell. |
| FontStyle | Determines the font style of the text in a cell. |
| GradientPattern | Returns a string describing a gradient. |
| Transitions | Adjust CSS transition |
Examples
1. If current cell value is negative, its formatting defined in XForms is changed to have bold, italic and white text on red background :If(
CellValue<0,
Block(
Fill('red'),
FontColor('white'),
FontStyle('bi')
)
)
2. Alternate lines colors between white and yellow (but from a performance point of view, it's better if colors are defined statically in cells properties)if(Line()%2=0,Fill('white'),Fill('#FFFF00'))
3. Alternate lines colors and highlight selected lines in a ListView Layer with selection checkboxes in first columnif(A1,Fill('#3CF'),if(RowIndex()%2=0,Fill('white'),Fill('yellow')))