Spread.Sheets
SpreadSheets要素の使用

次の表は、SpreadSheets要素の属性を示します。

属性 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(ホスト要素のスタイルは、AngularJSのスタイルバインディングと同じです。例:{width:400px, height:600px })
hostClass string(ホスト要素のクラス名)

次の表は、出力イベントの一覧を示します。

属性 APIリファレンス コメント
workbookInitialized ワークブックのインスタンス args (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
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

次の表は、子要素を示します。

子要素 APIリファレンス カウント
Worksheet GC.Spread.Sheets.Worksheet any

 

 


© 2016-2018, GrapeCity inc. All rights reserved.