TIWCGJQSpreadSheet Class
Represents type TIWCGJQSpreadSheet.
IWCGJQControl.TIWCGCustomRegion
IWCGJQControl.TIWCGJSContainer
IWCGJQControl.TIWCGJQContainer
IWCGJQSpreadSheet.TIWCGJQCustomSpreadSheet
IWCGJQSpreadSheet.TIWCGJQSpreadSheet
type [ComponentPlatformsAttribute(pidWin32 or pidWin64)] TIWCGJQSpreadSheet = class(TIWCGJQCustomSpreadSheet) end;
The TIWCGJQSpreadSheet type exposes the following members.
| Name | Description | |
|---|---|---|
 | Create(TComponent) | Initializes a new instance of the TIWCGJQCustomSpreadSheet class. (Overrides TIWCGJSContainer.Create(TComponent).) |
| Name | Description | |
|---|---|---|
 | AjaxRequestRegisterCallbackName | Represents property |
| AjaxResponseScriptList | Represents property |
 | Align | Represents property |
| Anchors | Represents property |
| BorderOptions | Represents property |
| BrowserDestroyJsAdded | Represents property |
| CGScrollStyle | Represents property |
| Color | Represents property |
| ContextMenu | Represents property |
| Css | Represents property |
| Cursor | Represents property |
| DataLink | Represents property |
| DisableAjaxResponseCount | Represents property |
| Dispatcher | Represents property |
| ExtraTagParams | Represents property |
| Font | Represents property |
| GenerateAjaxResponse[TCGJSonMember] | Represents property |
| HasDataLink | Represents property |
| HiddenInputNames | Represents property |
| Hint | Represents property |
| HTML5 | Represents property |
| HTMLName | Represents property |
| InternalVisible | Represents property |
| Intro | Represents property |
| IsLoading | Represents property |
| IWApplication | Represents property |
| IWCLName | Represents property |
| JQDragOptions | Represents property |
| JQDropOptions | Represents property |
| JQEffects | Represents property |
| JQElemSelector | Represents property |
| JQEvents | Represents property |
| JQHTMLName | Represents property |
| JQPositionOptions | Represents property |
| JQResizeOptions | Represents property |
| JQSelector | Represents property |
| JQSpreadSheetDefaults | Represents property |
| JQSpreadSheetOptions | Represents property |
| LayoutMgr | Represents property |
| LoadHidden | Represents property |
| MapID | Represents property |
| Mobile | Represents property |
| NeedsCookieJs | Represents property |
| NeedsJSONJs | Represents property |
| OnCreate | Represents property |
| OnHTMLTag | Represents property |
| ParentShowHint | Represents property |
| RegisterCallbackName[string] | Represents property |
| RenderInvisibleControls | Represents property |
| RootForm | Represents property |
| ShowHint | Represents property |
| SpreadSheetExportUrl | Represents property |
| Style | Represents property |
| StyleRenderOptions | Represents property |
| SubmitResponseScriptList | Represents property |
| TabIndex | Represents property |
| TabStop | Represents property |
| Version | Represents property |
| WebApplication | Represents property |
| ZIndex | Represents property |
| Name | Description | |||||
|---|---|---|---|---|---|---|
 | AcceptDesignTimeControlWithin(TControl,string,Boolean) | Represents method | ||||
| AddColumn(boolean) | Overloaded. Add column to active sheet. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| AddColumn(Integer,boolean) | Overloaded. Add column to active sheet. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| AddJavaScriptEventToResponse(string,TIWCGAjaxReponseScriptEvent,Boolean,Boolean) | Represents method | ||||
| AddJavaScriptToAjaxResponse(string,Boolean,Boolean) | Overloaded. Represents method | ||||
| AddJavaScriptToAjaxResponse(string,TIWCGAjaxReponseScriptEvent,Boolean,Boolean) | Overloaded. Represents method | ||||
| AddJavaScriptToResponse(string,Boolean,Boolean) | Represents method | ||||
| AddJavaScriptToSubmitResponse(string,Boolean,Boolean) | Overloaded. Represents method | ||||
| AddJavaScriptToSubmitResponse(string,TIWCGAjaxReponseScriptEvent,Boolean,Boolean) | Overloaded. Represents method | ||||
| AddLinkFile(TIWCompContext,string,string) | Represents method | ||||
| AddMemberToAjaxResponse(TIWCGJSon,TCGJSonMember) | Represents method | ||||
| AddMultipleColumns(Integer,Integer,boolean,boolean) | Add multiple columns to active sheet. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| AddMultipleRows(Integer,Integer,boolean,boolean) | Add multiple rows to active sheet. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| AddRow(boolean) | Overloaded. Add single row to active sheet. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| AddRow(Integer,boolean) | Overloaded. Add single row to active sheet. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| AddSheet(Integer,Integer,Integer,Integer) | Aadds a spreadsheet table. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| AfterConstruction | Represents method | ||||
| AfterSetBounds(Integer,Integer,Integer,Integer) | Represents method | ||||
| AjaxPictureChanged(TObject) | Represents method | ||||
| AjaxReRender | Overloaded. Represents method | ||||
| AjaxReRender(Boolean,Boolean) | Overloaded. Represents method | ||||
| AjaxReRender(Boolean,TRenderRegionAsyncMethod,string,string) | Overloaded. Represents method | ||||
| BeforeSetBounds(Integer,Integer,Integer,Integer) | Represents method | ||||
| CallEvent(string,TStringList,Boolean) | Represents method | ||||
| CellFind | This procedure will invoke the browser prompt message. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| CGRenderSize(TIWHTMLTag) | Represents method | ||||
| CheckDataLink | Represents method | ||||
| ColumnShowAll | Show all the hidden columns. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| ContainerPrefix | Represents method | ||||
| CreateWnd | Represents method | ||||
| DataLinkActiveChange | Represents method | ||||
| DataLinkDataChange | Represents method | ||||
| DataLinkEditingChange | Represents method | ||||
| DataLinkUpdateData | Represents method | ||||
| DeleteColumn(Integer) | Remove the column. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| DeleteRow(Integer) | Remove the row. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| DeleteSheet(Integer) | Delete a spreadsheet table. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| DesignTimeRefresh | Represents method | ||||
| DisableAjaxResponse | Represents method | ||||
| DispatchAjaxJavaScript(string) | Represents method | ||||
| DispatchSubmitJavaScript(TObject,string) | Represents method | ||||
| Dispose(Boolean) | Represents method | ||||
| DoAjaxBrowserDestroy | Represents method | ||||
| DoAjaxRequest(TStringList) | Represents method | ||||
| DoBrowserUpdated | Represents method | ||||
| DoPostRenderProcessing(TIWMarkupLanguageTag,TIWBaseComponentContext,TComponent) | Represents method | ||||
| DoRenderHTML(TIWCompContext) | Represents method | ||||
| EnableAjaxResponse | Represents method | ||||
| Export(string,TIWCGJQSpreadSheetDataType,Boolean) | Export the data to file. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| FillCells(TIWCGJQSpreadSheetOrientation,Integer,Integer) | Fill up/down current cell value.
| ||||
| GetAfterResizeScript | Represents method | ||||
| GetAjaxResponseScriptListIntf(Boolean) | Represents method | ||||
| GetAsyncCommonPropertiesToRemove | Represents method | ||||
| GetBeforeResizeScript | Represents method | ||||
| GetCGJSContainer | Represents method | ||||
| GetControlCaption | Represents method | ||||
| GetControlEditable | Represents method | ||||
| GetControlText | Represents method | ||||
| GetDataLinkClass | Represents method | ||||
| GetDefaultCustomValueScript | Represents method | ||||
| GetDesignTag | Represents method | ||||
| GetDisableAjaxResponseCount | Represents method | ||||
| GetDocumentationLink | Represents method | ||||
| GetGenerateAjaxResponse(TCGJSonMember) | Represents method | ||||
| GetHiddenInputsRemoveJs | Represents method | ||||
| GetHTML5 | Represents method | ||||
| GetHTMLName | Represents method | ||||
| GetHtmlRemoveJs | Represents method | ||||
| GetHtmlReplaceWithTempIDJS | Represents method | ||||
| GetHtmlTag(TIWCompContext) | Return the TIWHTMLTag object. This object represents the structure html and used in Design-Time and Run-Time.
| ||||
| GetIDJQuery | Represents method | ||||
| GetIDJQueryElem | Represents method | ||||
| GetImplComponent | Represents method | ||||
| GetInputControlNames(TStringList) | Represents method | ||||
| GetInvalidateBrowserOnCreate | Represents method | ||||
| GetIsDesigining | Represents method | ||||
| GetIsLoading | Represents method | ||||
| GetIWApplication | Represents method | ||||
| GetIWCLName | Represents method | ||||
| GetJQDragOptionsClass | Represents method | ||||
| GetJQDropOptionsClass | Represents method | ||||
| GetJQEventsClass | Represents method | ||||
| GetJQHTMLName | Represents method | ||||
| GetJQResizeOptionsClass | Represents method | ||||
| GetMemberBaseScript(ISuperObject) | Represents method | ||||
| GetMobile | Represents method | ||||
| GetNeedsCookieJs | Represents method | ||||
| GetNeedsJSONJs | Represents method | ||||
| GetPluginDestroyJs | Represents method | ||||
| GetReleaseIWCLJs | Represents method | ||||
| GetRenderExtraScript | Represents method | ||||
| GetRenderScript | Represents method | ||||
| GetResizeScript | Represents method | ||||
| GetScriptLinks(TStrings) | Represents method | ||||
| GetScriptLinksAfterJQM(TStrings) | Represents method | ||||
| GetScriptLinksBeforeJQM(TStrings) | Represents method | ||||
| GetSubmitParam | Represents method | ||||
| getSubmitProc | Represents method | ||||
| GetSubmitResponseScriptListIntf(Boolean) | Represents method | ||||
| getTabOrder | Represents method | ||||
| GetWebBrowser | Represents method | ||||
| get_DoRefreshControl | Represents method | ||||
| get_Editable | Represents method | ||||
| get_HTMLName | Represents method | ||||
| get_NonEditableAsLabel | Represents method | ||||
| get_ShouldRenderTabOrder | Represents method | ||||
| HideContextMenu | Overloaded. Represents method | ||||
| Import(string) | Import the data to spreadsheet.
| ||||
| InitControl | Represents method | ||||
| InitPaintHandler | Represents method | ||||
| IsForThisControl(string) | Represents method | ||||
| IWRemoveComponent(TComponent) | Represents method | ||||
| JQueryReady(Boolean) | Represents method | ||||
| jsAddColumn(string,boolean) | Represents method | ||||
| jsAddMultipleColumns(Integer,Integer,boolean,boolean) | Represents method | ||||
| jsAddMultipleRows(Integer,Integer,boolean,boolean) | Represents method | ||||
| jsAddRow(string,boolean) | Represents method | ||||
| jsAddSheet(Integer,Integer,Integer,Integer) | Represents method | ||||
| jsCellFind | Represents method | ||||
| jsColumnShowAll | Represents method | ||||
| jsDeleteColumn(Integer) | Represents method | ||||
| jsDeleteRow(Integer) | Represents method | ||||
| jsDeleteSheet(Integer) | Represents method | ||||
| jsExport(string,TIWCGJQSpreadSheetDataType,Boolean) | Represents method | ||||
| jsFillCells(TIWCGJQSpreadSheetOrientation,Integer,Integer) | Represents method | ||||
| jsGetCell(Integer,Integer,Integer) | Represents method | ||||
| jsGetCellValue(Integer,Integer,Integer) | Represents method | ||||
| jsGetTD(Integer,Integer) | Represents method | ||||
| jsImport(string) | Represents method | ||||
| jsMerge | Represents method | ||||
| jsNewSheet | Represents method | ||||
 | JSonEscape | Represents method | ||||
| JSonIdent | Represents method | ||||
| JSonNameQuote | Represents method | ||||
| jsPromptChangeTitle | Represents method | ||||
| jsReCalc | Represents method | ||||
| jsRedo | Represents method | ||||
| jsRowShowAll | Represents method | ||||
| jsSetCellFormula(string,Integer,Integer,Integer) | Represents method | ||||
| jsSetCellHtml(string,Integer,Integer,Integer) | Represents method | ||||
| jsSetCellValue(variant,Integer,Integer,Integer) | Represents method | ||||
| jsSetFocus | Represents method | ||||
| jsSetVisibility | Represents method | ||||
| jsSheetSize | Represents method | ||||
| jsShowAndHide(Integer,ISuperObject,ISuperObject) | Represents method | ||||
| jsShowSource(TIWCGJQSpreadSheetSourceType) | Represents method | ||||
| jsSwitchSheet(Integer) | Represents method | ||||
| jsToggleCellStyle(string,string,Integer,Integer,Integer) | Overloaded. Represents method | ||||
| jsToggleCellStyle(TIWCGJQSpreadSheetStyle,Integer,Integer,Integer) | Overloaded. Represents method | ||||
| jsToggleCellType(TIWCGJQSpreadSheetCellType,Integer,Integer,Integer) | Represents method | ||||
| jsToggleEditReadOnly | Represents method | ||||
| jsToggleFullScreen | Represents method | ||||
| jsToggleHideColumn | Represents method | ||||
| jsToggleHideRow | Represents method | ||||
| jsUndo | Represents method | ||||
| jsUnmerge | Represents method | ||||
| Loaded | Represents method | ||||
| MakeHTMLTag(TIWHTMLTag,TIWRenderStream) | Overloaded. Represents method | ||||
| Merge | Merge selected cells. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| NewSheet | Represents method | ||||
| Notification(TComponent,TOperation) | Represents method | ||||
| OriginalRenderHTML(TIWCompContext) | Represents method | ||||
| PromptChangeTitle | This procedure will invoke the browser prompt message to specify the new title of current sheet. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| ReCalc | Re-Calculates the current sheet. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| Redo | Redo operation. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| RemoveIWSize(string) | Represents method | ||||
| RenderAsync(TIWCompContext) | Represents method | ||||
| RenderAsyncBorders | Represents method | ||||
| RenderAsyncCGScrollbars(string) | Represents method | ||||
| RenderAsyncComponent(TIWBaseComponentContext) | Represents method | ||||
| RenderAsyncComponents(TIWContainerContext,TIWBasePageContext) | Represents method | ||||
| RenderAsyncSize | Represents method | ||||
| RenderCSSClass(TIWCompContext) | Represents method | ||||
| RenderDesignHTML(TIWHTMLTag) | Represents method | ||||
| RenderDesignHTMLPage(string) | Represents method | ||||
| RenderHTML(TIWCompContext) | Represents method | ||||
| RenderMarkupLanguageTag(TIWBaseComponentContext) | Represents method | ||||
| RenderRealTabIndex(TIWHTMLTag,Integer) | Represents method | ||||
| RenderScriptLinks(TIWCompContext) | Represents method | ||||
| RenderScripts(TIWCompContext) | Represents method | ||||
| RenderStyle(TIWCompContext) | Represents method | ||||
| RenderStyleToTag(TIWHTMLTag,TIWCGPicture,TIWCGBackgroundType) | Represents method | ||||
| ResetJSonProps | Represents method | ||||
| ResponseEvent(TObject,string) | Represents method | ||||
| RowShowAll | Show all the hidden rows. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| Select | Represents method | ||||
| SetBounds(Integer,Integer,Integer,Integer) | Represents method | ||||
| SetCellFormula(string,Integer,Integer,Integer) | Set cell formula. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| SetCellHtml(string,Integer,Integer,Integer) | Set cell html. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| SetCellValue(variant,Integer,Integer,Integer) | Set cell value. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| SetContextMenu(TIWCGJQCustomContextMenu) | Represents method | ||||
| SetControlEditable(Boolean) | Represents method | ||||
| SetControlText(string) | Represents method | ||||
| SetFileValue(TFileName) | Represents method | ||||
| SetFocus | Represents method | ||||
| SetFocusAndSelect | Represents method | ||||
| SetInternalContextMenu(TIWCGJQCustomContextMenu) | Represents method | ||||
| SetIWCssAttr(string,string,string) | Overloaded. Represents method | ||||
| SetIWCssAttr(TIWHTMLTag,string,string) | Overloaded. Represents method | ||||
| SetNeedsCookieJs(Boolean) | Represents method | ||||
| SetNeedsJSONJs(Boolean) | Represents method | ||||
| setTabOrder(TIWTabOrder) | Represents method | ||||
| SetValue(string) | Represents method | ||||
| SetValueByName(string,string) | Represents method | ||||
| set_DoRefreshControl(Boolean) | Represents method | ||||
| set_Editable(Boolean) | Represents method | ||||
| set_NonEditableAsLabel(Boolean) | Represents method | ||||
| set_Visible(Boolean) | Represents method | ||||
| ShowAndHide(Integer,ISuperObject,ISuperObject) | Represents method | ||||
| ShowContextMenu(Integer,Integer) | Overloaded. Represents method | ||||
| ShowContextMenuOnCenter | Overloaded. Represents method | ||||
| ShowContextMenuOnCenter(Integer,Integer) | Overloaded. Represents method | ||||
| ShowSource(TIWCGJQSpreadSheetSourceType) | View source of spreadsheet. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| Submit(string) | Represents method | ||||
| SwitchSheet(Integer) | Switches spreadsheet. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| ToggleCellStyle(string,string,Integer,Integer,Integer) | Overloaded. Sets cell class for styling.
| ||||
| ToggleCellStyle(TIWCGJQSpreadSheetStyle,Integer,Integer,Integer) | Overloaded. Sets cell class for styling.
| ||||
| ToggleCellType(TIWCGJQSpreadSheetCellType,Integer,Integer,Integer) | Sets cel type.
| ||||
| ToggleEditReadOnly | Toggle Edit & ReadOnly (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| ToggleFullScreen | Represents method | ||||
| ToggleHideColumn | Hides or shows the currently selected column. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| ToggleHideRow | Hides or shows the currently selected row. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| Undo | Undo operation. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| Unmerge | Unmerge selected cells. (Inherited from TIWCGJQCustomSpreadSheet.) | ||||
| UpdateWebBrowser(Integer) | Represents method |
| Name | Description | |
|---|---|---|
 | OnAfterRenderHTML | Represents property |
| _Events_ | Represents property |