Overview of Working Storage Area

The working storage area is a mechanism for storing global values across formulas.

Using the different call methods, you can test whether or not an item exists in the storage area, delete an item, set the value for an item, and get a value for an item. You can access the values by name. The names are case-independent.

This table lists the working storage area methods.

Method

Description

WSA_EXISTS(item [, type])

Tests whether or not the item called item exists in the storage area. If type is specified, then the item must be of the same type. These are the valid values for type:

  • DATE

  • DATE_NUMBER

  • DATE_TEXT

  • NUMBER

  • NUMBER_NUMBER

  • NUMBER_TEXT

  • TEXT

  • TEXT_NUMBER,

  • TEXT_TEXT

WSA_DELETE([item])

Deletes the item called item. If you don't specify a name, then all the storage area data is deleted.

WSA_SET(item, value)

Sets the value for the item called item. Any existing item of the same name is overwritten.

WSA_GET(item, default-value)

Retrieves a value for the item called item. If there is no item called item, then the method returns the default value. The data type of default-value is the expected data type for item.