CellIcon( icon, side )
Displays an image (icon) in a cell, next to a cell value. «icon» is an image. «side» can be
This can be used from the Cell Format Expression attribute.
The above screenshot uses CellIcon in two ways. First, an icon appears to the right of Staff development, indicating that the projects are sorted in decreasing order by the values in that column, and second, in the Net revenues column to show the the sign of the value. These were implemented using the following code in the Cell Format Expression attribute:
The first item in the outer CellFormats implements the column sorting. A variable in the model, vis_icon, computes which icon to display (it is defined as
If Sort_descending Then icon_descending Else icon_ascending). The model contains logic that sorts the Project index, which is beyond the scope of this discussion. The CellSpan with
header:true puts the icon in the header cell.
The second item in the outer CellFormats list implements the green up and red down arrows.
This function was first introduced in Analytica 5.0, but labelled as an experimental feature and not included in expression assist.
In Analytica 5.4, it was exposed on expression assist.
In Analytica 6.0, text in the description calling it experimental was removed.
- Cell Icon Set Library -- A set of pre-curated icons for use as cell icons and functions to make it easier use icons.
- Cell Format Expression and Computed cell formats
- CellFormats, CellSpan
- ReadImageFile, Drawing images
Enable comment auto-refresher