Categorising formulae

You can use formula categories to classify the formulae in your project. You create formula categories in Library Explorer. You can create as many formula categories as you like, then place individual formulae into appropriate categories.

Categorising formulae in this way makes it easier to find the formula you are looking for, for example when selecting a formula to display in a column in the spreadsheet. Whenever you select a formula, they are arranged into their categories, with any formulae that do not belong to a category being displayed below the formula categories that do exist.

To create a new formula category:

Open Library Explorer.
Open the Formula Category library. All existing formula categories appear in the list view.
Right-click a blank area of the list view and select New Formula Category. A new formula category appears in the list, with the cursor flashing in the Name column.
Enter a name for the formula category and press Enter.
Close Library Explorer.

You can now assign the category that you have created to formulae within the project. To assign a category to a formula:

Open Library Explorer.
Open the Formula library. All existing formulae appear in the list view.
Select the formula to which you want to assign the category and click Properties. The Formula Properties dialog is displayed.
Select the formula category that you want to assign to the formula in the Category field.
Click OK.

If you no longer require a formula category in a project, you can delete it in Library Explorer. Note that before you can delete a formula category you must first assign a different category to any formula to which the category that you want to delete is currently assigned.