Spread.Sheets Documentation
Using the Sheet and Sheets Elements
Spread.Sheets Documentation > Developer's Guide > Managing Data > Using Spread.Sheets with AngularJS > Using the Sheet and Sheets Elements

The following table lists the child elements of the sheets element. The sheets element has no attributes.

Child Element API Reference Type
worksheet any Worksheet

The following table lists the attributes of the sheet element.

Attribute API Reference Type Comment
allowCellOverflow Worksheet.options.allowCellOverflow = value boolean  
clipBoardOptions Worksheet.options.clipBoardoptions(value) GC.Spread.Sheets.ClipboardPasteOptions  
colHeaderAutoText Worksheet.options.colHeaderAutoText = value GC.Spread.Sheets.HeaderAutoText  
colHeaderAutoTextIndex Worksheet.options.colHeaderAutoTextIndex = value number  
colHeaderVisible Worksheet.options.colHeaderVisible = value boolean  
currentTheme Worksheet.currentTheme(value) string  
dataSource Worksheet.setDataSource(value) any  
dataSourceDeepWatch boolean This attribute is used for Spread.Sheets to automatically refresh when the array type data source is changed. When set to true, AngularJS notifies the source of the change and updates Spread.Sheets; otherwise, does not refresh. The default value is true.
frozenColumnCount Worksheet.frozenColumnCount(value) number  
frozenlineColor Worksheet.options.frozenlineColor = value string  
frozenRowCount Worksheet.frozenRowCount(value) number  
frozenTrailingColumnCount Worksheet.frozenTrailingColumnCount(value) number  
frozenTrailingRowCount Worksheet.frozenTrailingRowCount(value) number  
isProtected Worksheet.options.isProtected = value boolean  
name Worksheet.name(value) string  
rowCount Worksheet.setRowCount(value) number  
rowHeaderAutoText Worksheet.options.rowHeaderAutoText = value GC.Spread.Sheets.HeaderAutoText  
rowHeaderAutoTextIndex Worksheet.options.rowHeaderAutoTextIndex = value number  
rowHeaderVisible Worksheet.options.setRowHeaderVisible = value boolean  
selectionBackColor Worksheet.options.selectionBackColor = value string  
selectionBorderColor Worksheet.options.selectionBorderColor = value string  
selectionPolicy Worksheet.selectionPolicy(value) GC.Spread.Sheets.SelectionPolicy  
selectionUnit Worksheet.selectionUnit(value) GC.Spread.Sheets.SelectionUnit  
sheetTabColor Worksheet.options.sheetTabColor = value string  
showColumnOutline Worksheet.showColumnOutline(value) boolean  
showRowOutline Worksheet.showRowOutline(value) boolean  
zoom Worksheet.zoom(value) number  

The following table lists the child elements of the sheet.

Child Element API Reference Count Type Comment
columns sheet.columns 1 columns The columns element can only be added on the sheet element.
columnOutlines Worksheet.columnOutlines 1 GC.Spread.Sheets.Outlines.Outline  
columnHeaderDefaultStyle Worksheet.setDefaultStyle(value, SheetArea.colHeader) 1 style  
defaultStyle Worksheet.setDefaultStyle(value, SheetArea.viewport) 1 style  
rowHeaderDefaultStyle Worksheet.setDefaultStyle(value, SheetArea.rowHeader) 1 style  
rowOutlines Worksheet.rowOutlines 1 GC.Spread.Sheets.Outlines.Outline  

 

 

Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.