Cell Icon Set Library

Download Library: media:Cell Icon Set Library.ana

The above screenshot shows cell icons in table cells. These icons can be used to convey information in various ways, but normally requires you to provide the icon images and to encode the logic to decide which icon to display.

This library provides pre-curated icon sets, so that you can select an icon set and let the library do the rest -- i.e., provide the icon images, use icons that go together as a set, and decide which icon to show. This is exposed through the two key functions:

• CellIconSetByLevel( ) : Select which icon based on an integer 1..n
• CellIconSetByValue( ) : Partition an array of numbers into levels for you.

You can select from various icon sets and can also vary the color scheme among 5 pre-defined consistent color schemes.

The library also exposes functions to draw all the icons (returning images), giving you total control over size, colors and percent progress (for indicator icons). These can be useful if you want icons with different colors, size or properties than those in the pre-curated icon sets.

How to use

You use the two main functions of the library, CellIconSetByLevel and CellIconSetByValue, in place of using the built-in CellIcon function. These are used from within the Computed Cell Formats attribute.

Select the icon set

When using either function, you'll select a cell icon set by specifying a set name and optionally the number of levels and color scheme. The available set names and color schemes are shown here:

For example, if you select the icon set name 'Arrows' with 4 levels using the 'Neon' color scheme, the four icons will be used, such as in this example:

Which icons to use

Each icon set has between 2 and 5 separate icons. Each cell will contain (at most) one of these icons, which will visually depict a value or other information at that cell coordinate. The icon might reflect the value that appears in that cell (such as whether it is large or small), or it might depict a different piece of information. For example, in a result table showing a closing price on a given day, the icon might depict whether prices increased or decreased on that day, which is information that would be taken from a different variable.