Spreadjs What properties are supported in ANGULAR2?

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/978677/201706/978677-20170629113839274-436991559. PNG "width=" 665 "height=" 369 "/>

Spreadjs The pure front-end Table control is a HTML5-based JAVASCRIPT spreadsheet and Grid feature control that provides complete formula engine, sorting, filtering, input controls, data visualization, Excel import/export, etc. for online editing classes for. NET, Java, and mobile platforms. Excel features a tabular program development.

In the previous article , we learned that Spreadjs has fully supported the ANGULAR2 and that it takes only 4 steps to complete the integration Spreadjs in ANGULAR2.

Let's describe what properties Spreadjs supports in ANGULAR2. Different tags can be bound to different properties, we follow the label to describe the classification. The following is a list of the main attributes, and more detailed properties are described here .

gc-spread-sheets :

Attribute	Type	Comment
Name	String	The name of the entire workbook, the default name for Excel when exporting
Tabstripvisible	Boolean	Whether to show the bottom left sheet navigation bar
Allowuserdragfill	Boolean	Whether the user is allowed to drag and fill
Highlightinvaliddata	Boolean	Whether invalid data is highlighted when data is validated (after highlighting is set, invalid data is circled in red)
BackColor	String	Set Background color
BackgroundImage	String	Set a background picture
Hoststyle	Any	The style of the label, equivalent to the Style property of the HTML, uses the same method as the ANGULAR2 binding, for example: {width:400px, height:600px}
Hostclass	String	Tag class, equivalent to the class attribute of the HTML.

Gc-worksheet :

Attribute	Type	Comment
DataSource	Any	A form-level binding that sets the data source.
Name	String	Set the name of the sheet
Frozencolumncount	Number	Top freeze column with parameter Colindex
Frozenrowcount	Number	Top freeze row with parameter rowindex
Frozentrailingcolumncount	Number	The bottom freezes the column with a parameter of Colcount-colindex, such as freezing the last two rows with a parameter of 2.
Frozentrailingrowcount	Number	Bottom freeze row with parameter Rowcount-rowindex
RowCount	Number	Set Number of rows
ColCount	Number	Set Number of columns
Rowheadervisible	Boolean	Whether to show Rowheader
Columnheadervisible	Boolean	Whether to show ColumnHeader
isprotected	Boolean	Set up form protection
SelectionBackColor	String	Set the background color of the selected area
Selectionbordercolor	String	Set the border color of the selected area
DefaultStyle	Gc. Spread.Sheets.Style	Sets the default style, which is an instance of GC.Spread.Sheets.Style.

Gc-column :

Attribute	Type	Comment
Width	Number	Column width
Resizable	Boolean	Whether to resize by dragging
AutoFit	Boolean	Whether to automatically match column widths
Style	Gc. Spread.Sheets.Style	Set style for whole column
Celltype	Gc. Spread.Sheets.CellTypes.Base	Set the cell type for an entire column
Formatter	String	Format cells in an entire column

The above is the supported properties, it should be noted that in ANGULAR2 Spreadjs maximum precision can only be set to the column level, which is related to the ANGULAR2 binding mechanism, need special attention.

Spreadjs V10.2 version will be released soon, more and better features in the new version, please look forward to!

Login to Spreadjs website to learn more.

This article is from the "Grape City Control Technology Team Blog" blog, declined to reprint!

Spreadjs What properties are supported in ANGULAR2?