Spread 8.0 Documentation
ScriptEnhanced Property
Support Options
ActiveX Reference > ActiveX Properties > ScriptEnhanced Property

Glossary Item Box

ScriptEnhanced Property


See Also    Example

Applies To

fpSpread and fpSpreadPreview controls

Description

Sets or returns whether methods and events that are enhanced for scripting environments are enabled.

Syntax

C++

BOOL CSpreadSheet::GetScriptEnhanced( );
void CSpreadSheet::SetScriptEnhanced(BOOL value);

Visual Basic

[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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.