(Showing Draft Content)

TableSheet is a fast, data-bound table view with grid-like behavior, a spreadsheet user interface and calculation engine which uses the Data Manager to pull data from the server, interact with it and then creates a view of the fetched data to bind to a tablesheet.

The main benefits of using a tablesheet are described below:

• Better sheet-binding resulting in better performance in sort and filter.

• Support group blocks with group-level calculations and slicers.

• Runtime panels to allow adjusting columns and groups.

• Conditional formatting and rules based on bound data instead of spreadsheet cell values.

A tablesheet can be created using the GC.Spread.Sheets.TableSheet.TableSheet and GC.Data.DataManager classes. The Data Manager is a powerful local data engine which interacts with the database to pull data, manage it and to sync real time data back to database and it then creates a view of the fetched data to bind it to a tablesheet.

The following image shows a tablesheet created for a goods importer and distributor company.

TableSheet Features

For using tablesheet and its various features, refer the below topics:

Features	Description
TableSheet Components	Describe tablesheet structure, and its components.
Data Manager	Describe the working of Data Manager and its methods.
Create TableSheet	Create tablesheet in the spreadsheet through code.
TableSheet Views	Control and customize the display of tablesheet columns: Column Header Style Column header fit mode Cell types and dropdowns
Data Operations	Edit the data source efficiently with different sync modes.
TableSheet Relationships	Define and create table and field relationships with Data Manager.
TableSheet Operations	Perform different types of operations on a tablesheet: Pin Unpin Sort and Filter Row Action Grouping
Rules	Manage rules like conditional formatting and style rules in a tablesheet.
Appearance	Customize the appearance of a tablesheet: Alternate row styles Icons Themes
Calculations	Utilize the enhanced calculation engine to add calculated columns and reference tablesheet in a worksheet.
Interactive Behavior	Interact with the tablesheet with different actions: Zoom In and Out Resize Columns Cut, Copy and Paste Drag Operations Shortcut Keys
TableSheet IO	Export tablesheet to different file formats: JSON serialization Excel files PDF Print