TableSheet

TableSheet is a worksheet-type component built on the DataManager infrastructure.

It binds to a DataManager table view and provides interactive editing, sorting, filtering, grouping, and hierarchy operations.

When collaboration is enabled, TableSheet follows the Data Manager–Based Collaboration Model.

Collaboration behavior depends on the underlying table's data source configuration.

Data Source–Dependent Behavior

TableSheet itself does not define data storage behavior.

Collaboration capability is determined by the DataManager table bound to the sheet.

1. Local Data (data option with JSON)

When the table is created using:

dataSourceOption: {
    data: [...]
}

The following user actions participate in collaboration:

• Editing cell values

• Inserting or removing records

• Modifying column definitions

• Updating schema configuration

• Performing hierarchy operations (move, promote, demote)

• Pinning and unpinning rows

• Sorting, filtering, grouping, and view updates

Both configuration and dataset mutations are synchronized.

2. Remote Data (URL-Based Transport)

When the table is created using:

dataSourceOption: {
    remote: { ... },
    autoSync: true

}

Behavior:

• TableSheet editing is supported.

• Data changes are sent to the configured remote service.

• Dataset mutations are not synchronized by the collaboration system.

• Configuration changes remain synchronized if serializable.

Data consistency is handled by the backend system rather than the collaboration layer.

3. Remote Data (Function Handlers)

When remote transport uses function handlers:

• The table does not participate in collaboration.

• No dataset or configuration synchronization occurs.

4. CSV or XML Data

When dataset content originates from CSV or XML formats:

• Configuration changes are synchronized.

• Dataset mutations are not synchronized.

Limitations

• Presence awareness is not supported.

• Dataset synchronization is available only for JSON-based local data.

• Remote data consistency is delegated to external services.