TIWCGJQSpreadSheetOptions Class
Represents type TIWCGJQSpreadSheetOptions.
The TIWCGJQSpreadSheetOptions type exposes the following members.
| Name | Description | |
|---|---|---|
 | Create(TCollection) | |
| CreateSingle(TPersistent,string) | Initializes a new instance of the TIWCGJQSpreadSheetOptions class. (Overrides TIWCGJSon.CreateSingle(TPersistent,string).) |
| Name | Description | |
|---|---|---|
 | AllowToggleState | Default true, allows the spreadsheet to be toggled from write/read. |
| AutoAddCells | Allows you to add cells by selecting the last row/column and add cells by pressing either tab (column) or enter (row). Default: True |
| AutoFiller | Turns on/off the auto filler, the little square that follows the active cell around that you can drag and fill the values of other cells in with. Default: True |
| BarMenus | Default true, Turns bar menus on/off. |
| BoxModelCorrection | If box model is detected, it adds these pixels to ensure the size of the spreadsheet controls are correct Default: 2 |
| CalcOff | Turns turns off ability to calculate. Default: False |
| CellSelectModel | Makes the select model act differently. Default: sscsmExcel |
| CGJSContainer | Represents property |
 | ClassData | Represents property |
| ColMargin | Size of height of new cells, and width of cell bars. Default: 10 |
| ContextmenuCell | Default is standard list of commands for context menus when right click or click on menu dropdown. |
| ContextmenuLeft | Default is standard list of commands for context menus when right click. |
| ContextmenuTop | Default is standard list of commands for context menus when right click or click on menu dropdown |
| Editable | Default true, makes the sheet editable or viewable |
| EditableNames | Default true, allows sheets to have their names changed, depends on Editable being true. |
| EndOfNumber | Represents property |
| FormulaFunctions | Additional functions for formulas. Will overwrite default functions if named the same. |
| FormulaVariables | Additional variables that formulas can access. |
| FreezableCells | Default true, Turns ability to freeze cells on/off |
| FrozenAt | Gives the ability to freeze cells at a certain row/col. |
| InstList | Represents property |
| IsStored | Represents property |
| JSon | Return the Interface of SuperObject (ISuperObject) (Inherited from TIWCGJSon.) |
| JSonEvents[string] | Represents property |
| List | Represents property |
| LockFormulas | Turns on/off the ability to edit formulas. Default: False |
| MemberList | Represents property |
| MenuLeft | Represents property |
| MenuRight | Represents property |
| MinSize | The minimum size of a spreadsheet. |
| NewColumnWidth | Width of new columns. Default: 120 |
| OnError | Is triggered on errors from the formula engine. |
| OnSheetAdd | Occurs just after a spreadsheet has been added |
| OnSheetAddColumn | Occurs just after a column has been added |
| OnSheetAddRow | Occurs just after a row has been added |
| OnSheetAllOpened | Occurs just after all sheets have been loaded and complete user interface has been created, this is triggered when calling sheet, so it needs to be bound beforehand |
| OnSheetCalculation | Occurs just after a spreadsheet has been fully calculated |
| OnSheetCellEdit | Occurs just before a cell has been a cell is started to edit |
| OnSheetCellEdited | Occurs just after a cell has been updated |
| OnSheetDelete | Occurs just after a spreadsheet has been deleted |
| OnSheetDeleteColumn | Occurs just after a column as been deleted |
| OnSheetDeleteRow | Occurs just after a row has been deleted |
| OnSheetFormulaKeydown | Occurs just after keydown on either inline or static formula |
| OnSheetFullScreen | Triggered when the sheet goes full screen |
| OnSheetOpen | Occurs just after a single sheet within a set of sheets has been opened, this is triggered when calling sheet, so it needs to be bound beforehand |
| OnSheetRename | Occurs just after a spreadsheet is renamed. |
| OnSheetSave | An assistance event called when calling jS.toggleState(), but not tied to anything internally. |
| OnSheetSwitch | Occurs after a spreadsheet has been switched |
| OnSheetTabSortStart | Occurs at the beginning of a sort for moving a spreadsheet around in order |
| OnSheetTabSortUpdate | Occurs after a sort of a spreadsheet has been completed |
| Owner | Represents property |
| PropCount | Represents property |
| PropIndexByName[string] | Represents property |
| PropList | Represents property |
| PropName | Represents property |
| PropNameByIndex[Integer] | Represents property |
| ResizableCells | Turns resizing on and off for cells. Default: True |
| ResizableSheet | Turns resizing on and off for sheet. Default: True |
| SObj | Represents property |
| Title | Title of spreadsheet. |
| TitleFn | Function for title of spreadsheet. Expects string. |
| Name | Description | |||
|---|---|---|---|---|
 | AddBooleanMember(string,Boolean,Boolean,Boolean) | Represents method | ||
| AddColorMember(string,TIWCGColor,Boolean,Boolean) | Represents method | ||
| AddCurrencyMember(string,Currency,Boolean,Boolean) | Represents method | ||
| AddDoubleMember(string,Double,Boolean,Boolean) | Represents method | ||
| AddDynObjListMember(string,Boolean,Boolean) | Represents method | ||
| AddEnumMember(string,string[],Byte,Boolean,Boolean) | Represents method | ||
| AddEnumSetMember(string,string[],Void,Word,Boolean,Boolean) | Represents method | ||
| AddFuncMember(string,string,string,Boolean,TIWCGJSonFuncClass,Boolean,Boolean) | Represents method | ||
| AddHTML5(TIWHTMLTag) | Represents method | ||
| AddIntegerMember(string,Integer,Boolean,Boolean) | Represents method | ||
| AddJSonMember(string,TCGJSon,Boolean,Boolean) | Represents method | ||
| AddMembers | The procedure add jquery properties.
| ||
| AddObjListMember(string,TIWCGJSonListClass,Boolean,Boolean,Boolean) | Represents method | ||
| AddObjMember(string,TIWCGJSonClass,Boolean,Boolean,Boolean) | Represents method | ||
| AddSimpleArrayMember(string,Boolean,Boolean,Boolean) | Represents method | ||
| AddStringMember(string,string,Boolean,Boolean) | Represents method | ||
| AddVariantMember(string,Variant,Boolean,Boolean) | Represents method | ||
| AfterConstruction | Represents method | ||
| Assign(TPersistent) | Represents method | ||
| CheckJSonMember(Integer) | Represents method | ||
| ConvertEnumToString(string) | Represents method | ||
| ConvertSetToString(string,TCGStringArray) | Represents method | ||
| FreeJSonObj(Integer) | Overloaded. Represents method | ||
| FreeJSonObj(string) | Overloaded. Represents method | ||
| GetBooleanValue(Integer) | Represents method | ||
| GetCGJSContainer | Represents method | ||
| GetColorValue(Integer) | Represents method | ||
| GetCurrencyValue(Integer) | Represents method | ||
| GetCustomJq(string,ISuperObject) | Represents method | ||
| GetDoubleValue(Integer) | Represents method | ||
| GetDynObjListValue(Integer) | Represents method | ||
| GetEnumAsString(Integer) | Represents method | ||
| GetEnumerValue(Integer) | Represents method | ||
| GetEnumSetValue(Integer,Pointer) | Represents method | ||
| GetFixedScript(TIWCGJSonFunc,Boolean) | Represents method | ||
| GetFuncValue(Integer) | Represents method | ||
| GetHTMLName | Represents method | ||
| GetImplComponent | Represents method | ||
| GetIntegerValue(Integer) | Represents method | ||
| GetIsStored | Represents method | ||
| GetItemIndex | Represents method | ||
| GetIWCLName | Represents method | ||
| GetJSon | Represents method | ||
| GetJSonByType(Boolean,Boolean) | Represents method | ||
| GetJSonEx(Boolean,Boolean,TIWCGResponseMemberList,Boolean) | Represents method | ||
| GetJSonValue(Integer) | Represents method | ||
| GetJSonValueObj(Integer) | Represents method | ||
| GetMemberJSon(TCGJSonMember,ISuperObject,Boolean,Boolean,string) | Represents method | ||
| GetMemberSetterHandler(TObject,TCGJSonMember) | Represents method | ||
| GetMemberSetterScriptParts(TIWCGResponseMemberList,TIWCGJScript) | Represents method | ||
| GetMembersJSon(TIWCGResponseMemberList,Boolean,Boolean) | Represents method | ||
| GetObjListValue(Integer) | Represents method | ||
| GetObjValue(Integer) | Represents method | ||
| GetOwner | Represents method | ||
| GetPropName | Represents method | ||
| GetSimpleArrayValue(Integer) | Represents method | ||
| GetStringValue(Integer) | Represents method | ||
| GetVariantValue(Integer) | Represents method | ||
| InternalGetJSon(TEachPropJSonProc,Boolean,Boolean,Void,Boolean,Boolean,TIWCGResponseMemberList,Boolean) | Represents method | ||
 | IsArray | Represents method | ||
| IsBooleanStored(Integer) | Represents method | ||
| IsColorStored(Integer) | Represents method | ||
| IsCurrencyStored(Integer) | Represents method | ||
| IsDoubleStored(Integer) | Represents method | ||
| IsEnumerStored(Integer) | Represents method | ||
| IsEnumSetStored(Integer) | Represents method | ||
| IsFuncStored(Integer) | Represents method | ||
| IsIntegerStored(Integer) | Represents method | ||
| IsJSonObjStored(string) | Represents method | ||
| IsJSonStored(Integer) | Represents method | ||
| IsObjStored(Integer) | Represents method | ||
| IsStringStored(Integer) | Represents method | ||
| IsVariantStored(Integer) | Represents method | ||
| JSonEscape | Represents method | ||
| JSonIdent | Represents method | ||
| JSonNameQuote | Represents method | ||
| ResetProps | Represents method | ||
| SetBooleanValue(Integer,Boolean) | Represents method | ||
| SetColorValue(Integer,TIWCGColor) | Represents method | ||
| SetCurrencyValue(Integer,Currency) | Represents method | ||
| SetDoubleValue(Integer,Double) | Represents method | ||
| SetDynObjListValue(Integer,TIWCGJSonDynObjList) | Represents method | ||
| SetEnumerValue(Integer,Byte) | Represents method | ||
| SetEnumSetValue(Integer,Pointer) | Represents method | ||
| SetFuncValue(Integer,TIWCGJSonFunc) | Represents method | ||
| SetIntegerValue(Integer,Integer) | Represents method | ||
| SetJSonValue(Integer,TCGJSon) | Represents method | ||
| SetObjListValue(Integer,TIWCGJSonList) | Represents method | ||
| SetObjValue(Integer,TIWCGJSon) | Represents method | ||
| SetSimpleArrayValue(Integer,TIWCGJSonSimpleArray) | Represents method | ||
| SetStringValue(Integer,string) | Represents method | ||
| SetVariantValue(Integer,Variant) | Represents method | ||
| StoreProperty(PPropInfo,TObject) | Represents method | ||
| SupportsSetter(TObject,TCGJSonMember) | Represents method |
