Scripting Environment Usage

Some fpSpread control methods and events and fpSpreadPreview control events contain parameters that are not passed by value ("ByVal") but are instead passed by reference. If you use the fpSpread or fpSpreadPreview ActiveX controls in a scripting environment (for example, Microsoft Visual InterDev® or Internet Explorer) and you want to change any parameter that is not passed "ByVal", you should:

1. Set the ScriptEnhanced property to True.
2. Use the Script version of the method or event.
   The Script version of these methods and events will return these parameters as variants.

For example, you could use code in the ScriptBeforeUserSort event to cancel sorting when a user clicks a column header to sort a column in a scripting environment. One of the samples provided with the Spread control illustrates how to use Script events and methods. When you install Spread using the default settings, the samples are installed in the product's \SAMPLES directory.

For a complete list of Script methods and events, see the ScriptEnhanced property.