Spread.Sheets > 開発者の手引き > データの管理 > Angular 2の使用 > シート要素の概要 |
次の表は、gc-spread-sheets要素の全項目一覧を示します。
機能 | Spread.Sheets API | 型 | 備考 |
---|---|---|---|
name | Workbook.name | string | |
allowUserZoom | Workbook.options.allowUserZoom = value | boolean | |
allowUserResize | Workbook.options.allowUserResize = value | boolean | |
tabStripVisible | Workbook.options.tabstripvisible = value | boolean | |
tabEditable | Workbook.options.tabEditable = value | boolean | |
newTabVisible | Workbook.options.newTabVisible = value | boolean | |
allowUserEditFormula | Workbook.options.allowUserEditFormula = value | boolean | |
autoFitType | Workbook.options.autofittype = value | GC.Spread.Sheets.AutoFitType | |
allowUserDragFill | Workbook.options.allowUserDragfill = value | boolean | |
allowUserDragDrop | Workbook.options.allowUserDragDrop = value | boolean | |
highlightInvalidData | Workbook.options.highlightInvalidData = value | boolean | |
referenceStyle | Workbook.options.referenceStyle = value | GC.Spread.Sheets.ReferenceStyle | |
backColor | Workbook.options.backColor = value | string | |
grayAreaBackColor | Workbook.options.grayAreaBackColor = value | string | |
backgroundImage | Workbook.options.backgroundImage = value | string | |
backgroundImageLayout | Workbook.options.backgroundImageLayout = value | GC.Spread.Sheets.ImageLayout | |
showVerticalScrollbar | Workbook.options.showVerticalScrollbar = value | boolean | |
showHorizontalScrollbar | Workbook.options.showHorizontalScrollbar = value | boolean | |
ShowScrollTip | Workbook.options.showScrollTip = value | GC.Spread.Sheets.ShowScrollTip | |
ShowResizeTip | Workbook.options.showResizeTip = value | GC.Spread.Sheets.ShowResizeTip | |
showDragDropTip | Workbook.options.showDragDropTip = value | boolean | |
showDragFillTip | Workbook.options.showDragFillTip = value | boolean | |
hostStyle | any | 親要素のスタイル。Angularのスタイルバインディングと同様です。(例:width: 400px, height: 600px) | |
hostClass | string | 親要素のクラス名 |
次のサンプルはsheet要素の使用例です:
JavaScript |
コードのコピー
|
---|---|
@Component({ selector: 'my-app', template: `<gc-spread-sheets [backColor]="spreadBackColor" [hostStyle]="hostStyle"> </gc-spread-sheets>`, }) export class AppComponent { spreadBackColor = 'aliceblue'; hostStyle = { width: '800px', height: '600px' }; } |
次の表は、sheetイベントの一覧を示します:
機能 | Spread.Sheets API | 備考 |
---|---|---|
workbookInitialized | workbookインスタンスと引数{spread: workbook}を返します。 | |
validationError | GC.Spread.Sheets.Events.ValidationError | |
cellClick | GC.Spread.Sheets.Events.CellClick | |
cellDoubleClick | GC.Spread.Sheets.Events.CellDoubleClick | |
enterCell | GC.Spread.Sheets.Events.EnterCell | |
leaveCell | GC.Spread.Sheets.Events.LeaveCell | |
valueChanged | GC.Spread.Sheets.Events.ValueChanged | |
topRowChanged | GC.Spread.Sheets.Events.TopRowChanged | |
leftColumnChanged | GC.Spread.Sheets.Events.LeftColumnChanged | |
invalidOperation | GC.Spread.Sheets.Events.InvalidOperation | |
rangeFiltering | GC.Spread.Sheets.Events.RangeFiltering | |
rangeFiltered | GC.Spread.Sheets.Events.RangeFiltered | |
tableFiltering | GC.Spread.Sheets.Events.TableFiltering | |
tableFiltered | GC.Spread.Sheets.Events.TableFiltered | |
rangeSorting | GC.Spread.Sheets.Events.RangeSorting | |
rangeSorted | GC.Spread.Sheets.Events.RangeSorted | |
clipboardChanging | GC.Spread.Sheets.Events.ClipboardChanging | |
clipboardChanged | GC.Spread.Sheets.Events.ClipboardChanged | |
clipboardPasting | GC.Spread.Sheets.Events.ClipboardPasting | |
clipboardPasted | GC.Spread.Sheets.Events.ClipboardPasted | |
columnWidthChanging | GC.Spread.Sheets.Events.ColumnWidthChanging | |
columnWidthChanged | GC.Spread.Sheets.Events.ColumnWidthChanged | |
rowHeightChanging | GC.Spread.Sheets.Events.RowHeightChanging | |
rowHeightChanged | GC.Spread.Sheets.Events.RowHeightChanged | |
dragDropBlock | GC.Spread.Sheets.Events.DragDropBlock | |
dragDropBlockCompleted | GC.Spread.Sheets.Events.DragDropBlockCompleted | |
dragFillBlock | GC.Spread.Sheets.Events.DragFillBlock | |
dragFillBlockCompleted | GC.Spread.Sheets.Events.DragFillBlockCompleted | |
editStarting | GC.Spread.Sheets.Events.EditStarting | |
editChange | GC.Spread.Sheets.Events.EditChange | |
editEnding | GC.Spread.Sheets.Events.EditEnding | |
editEnd | GC.Spread.Sheets.Events.EditEnd | |
editEnded | GC.Spread.Sheets.Events.EditEnded | |
rangeGroupStateChanging | GC.Spread.Sheets.Events.RangeGroupStateChanging | |
rangeGroupStateChanged | GC.Spread.Sheets.Events.RangeGroupStateChanged | |
selectionChanging | GC.Spread.Sheets.Events.SelectionChanging | |
selectionChanged | GC.Spread.Sheets.Events.SelectionChanged | |
sheetTabClick | GC.Spread.Sheets.Events.SheetTabClick | |
sheetTabDoubleClick | GC.Spread.Sheets.Events.SheetTabDoubleClick | |
sheetNameChanging | GC.Spread.Sheets.Events.SheetNameChanging | |
sheetNameChanged | GC.Spread.Sheets.Events.SheetNameChanged | |
userZooming | GC.Spread.Sheets.Events.UserZooming | |
userFormulaEntered | GC.Spread.Sheets.Events.UserFormulaEntered | |
cellChanged | GC.Spread.Sheets.Events.CellChanged | |
columnChanged | GC.Spread.Sheets.Events.ColumnChanged | |
rowChanged | GC.Spread.Sheets.Events.RowChanged | |
activeSheetChanging | GC.Spread.Sheets.Events.ActiveSheetChanging | |
activeSheetChanged | GC.Spread.Sheets.Events.ActiveSheetChanged | |
sparklineChanged | GC.Spread.Sheets.Events.SparklineChanged | |
rangeChanged | GC.Spread.Sheets.Events.RangeChanged | |
buttonClicked | GC.Spread.Sheets.Events.ButtonClicked | |
editorStatusChanged | GC.Spread.Sheets.Events.EditorStatusChanged | |
floatingObjectChanged | GC.Spread.Sheets.Events.FloatingObjectChanged | |
floatingObjectSelectionChanged | GC.Spread.Sheets.Events.FloatingObjectSelectionChanged | |
pictureChanged | GC.Spread.Sheets.Events.PictureChanged | |
floatingObjectRemoving | GC.Spread.Sheets.Events.FloatingObjectRemoving | |
floatingObjectRemoved | GC.Spread.Sheets.Events.FloatingObjectRemoved | |
pictureSelectionChanged | GC.Spread.Sheets.Events.PictureSelectionChanged | |
floatingObjectLoaded | GC.Spread.Sheets.Events.FloatingObjectLoaded | |
touchToolStripOpening | GC.Spread.Sheets.Events.TouchToolStripOpening | |
commentChanged | GC.Spread.Sheets.Events.CommentChanged | |
commentRemoving | GC.Spread.Sheets.Events.CommentRemoving | |
commentRemoved | GC.Spread.Sheets.Events.CommentRemoved | |
slicerChanged | GC.Spread.Sheets.Events.SlicerChanged |
次のサンプルはイベントの使用例です:
JavaScript |
コードのコピー
|
---|---|
@Component({ selector: 'my-app', template: `<gc-spread-sheets (workbookInitialized)="workbookInit($event)" (validationError)="validationError($event)"> </gc-spread-sheets>`, }) export class AppComponent { workbookInit (args) { //do something } validationError (args) { //do something } } |
次の表は子要素の一覧を示します:
子要素 | Spread.Sheets API | カウント |
---|---|---|
gc-worksheet | GC.Spread.Sheets.Worksheet | any |