ScriptEnhanced Property
Applies To
fpSpread and fpSpreadPreview controls
Description
Sets or returns whether methods and events that are enhanced for scripting environments are enabled.
Syntax
BOOL CSpreadSheet::GetScriptEnhanced( );
void CSpreadSheet::SetScriptEnhanced(BOOL value);
[form.]fpSpread.ScriptEnhanced[= boolean%]
[form.]fpSpreadPreview.ScriptEnhanced[= boolean%]
Remarks
The default value of the ScriptEnhanced property is False. If you use the ActiveX control in a scripting environment (for example, Microsoft's Visual InterDev® or Internet Explorer) and you want to change any parameter that is not passed "ByVal", you must set the ScriptEnhanced property to True and use the Script version of the method or event.The Script version of these methods and events will return these parameters as variants.
This setting is applied to the entire workbook, including all sheets in the control.
| Note: The fpSpreadPreview control has no script methods. The fpSpreadPreview script events are indicated by an asterisk ("*") in the table below. |
| Non-Script Method | Script Method |
|---|---|
| CFGetCellParam | ScriptCFGetCellParam |
| CFGetCellParamExt | ScriptCFGetCellParamExt |
| CFGetDoubleParamExt | ScriptCFGetDoubleParamExt |
| CFGetParamInfo | ScriptCFGetParamInfo |
| CFGetRangeParam | ScriptCFGetRangeParam |
| CFGetRangeParamExt | ScriptCFGetRangeParamExt |
| ColWidthToTwips | ScriptColWidthToTwips |
| EnumCustomFunction | ScriptEnumCustomFunction |
| ExportRangeToXMLBuffer | ScriptExportRangeToXMLBuffer |
| ExportToXMLBuffer | ScriptExportToXMLBuffer |
| GetActionKey | ScriptGetActionKey |
| GetBottomRightCell | ScriptGetBottomRightCell |
| GetCalTextOverride | ScriptGetCalTextOverride |
| GetCellFromScreenCoord | ScriptGetCellFromScreenCoord |
| GetCellPos | ScriptGetCellPos |
| GetClientArea | ScriptGetClientArea |
| GetCustomFunction | ScriptGetCustomFunction |
| GetExcelSheetList | ScriptGetExcelSheetList |
| GetFirstValidCell | ScriptGetFirstValidCell |
| GetFloat | ScriptGetFloat |
| GetInteger | ScriptGetInteger |
| GetIteration | ScriptGetIteration |
| GetLastValidCell | ScriptGetLastValidCell |
| GetOddEvenRowColor | ScriptGetOddEvenRowColor |
| GetTextTipAppearance | ScriptGetTextTipAppearance |
| OwnerPrintPageCount | ScriptOwnerPrintPageCount |
| RowHeightToTwips | ScriptRowHeightToTwips |
| TwipsToColWidth | ScriptTwipsToColWidth |
| TwipsToRowHeight | ScriptTwipsToRowHeight |
| Non-Script Event | Script Event |
|---|---|
| BeforeUserSort | ScriptBeforeUserSort |
| CustomFunction | ScriptCustomFunction |
| DataFill | ScriptDataFill |
| DragDropBlock | ScriptDragDropBlock |
| KeyDown | ScriptKeyDown |
| KeyPress | ScriptKeyPress |
| KeyUp | ScriptKeyUp |
| LeaveCell | ScriptLeaveCell |
| LeaveRow | ScriptLeaveRow |
| OLECompleteDrag* | ScriptOLECompleteDrag |
| OLEDragDrop* | ScriptOLEDragDrop |
| OLEDragOver* | ScriptOLEDragOver |
| OLEGiveFeedback* | ScriptOLEGiveFeedback |
| OLEStartDrag* | ScriptOLEStartDrag |
| PrintAbort | ScriptPrintAbort |
| PrintMsgBox | ScriptPrintMsgBox |
| QueryAdvance | ScriptQueryAdvance |
| QueryData | ScriptQueryData |
| TextTipFetch | ScriptTextTipFetch |
Data Type
Integer (Boolean)
See Also
ScriptCFGetCellParam, ScriptCFGetDoubleParamExt, ScriptCFGetParamInfo, ScriptCFGetRangeParam, ScriptColWidthToTwips, ScriptEnumCustomFunction, ScriptExportRangeToXMLBuffer, ScriptExportToXMLBuffer, ScriptGetActionKey, ScriptGetBottomRightCell, ScriptGetCalTextOverride, ScriptGetCellFromScreenCoord, ScriptGetCellPos, ScriptGetClientArea, ScriptGetCustomFunction, ScriptGetExcelSheetList, ScriptGetFirstValidCell, ScriptGetFloat, ScriptGetInteger, ScriptGetIteration, ScriptGetLastValidCell, ScriptGetOddEvenRowColor, ScriptGetTextTipAppearance, ScriptOwnerPrintPageCount, ScriptRowHeightToTwips, ScriptTwipsToColWidth, ScriptTwipsToRowHeight methods
ScriptBeforeUserSort, ScriptCustomFunction, ScriptDataFill, ScriptDragDropBlock, ScriptKeyDown, ScriptKeyPress, ScriptKeyUp, ScriptLeaveCell, ScriptLeaveRow, ScriptOLECompleteDrag, ScriptOLEDragDrop, ScriptOLEDragOver, ScriptOLEGiveFeedback, ScriptOLEStartDrag, ScriptPrintAbort, ScriptPrintMsgBox, ScriptQueryAdvance, ScriptQueryData, ScriptTextTipFetch events