Getting Started
Features

Features Overview

A comprehensive overview of GridSheet's powerful features and capabilities.

Core Functionality

Spreadsheet Interface

GridSheet provides a familiar spreadsheet interface with:

  • Cells: Individual data containers with support for text, numbers, and formulas
  • Rows and Columns: Traditional grid layout with resizable dimensions
  • Navigation: Keyboard and mouse navigation with Excel-like shortcuts
  • Selection: Multi-cell selection and range operations

Formula Engine

Built-in formula support for complex calculations:

  • Mathematical Functions: SUM, AVERAGE, COUNT, etc.
  • Logical Functions: IF, AND, OR, etc.
  • Cell References: A1 notation and relative/absolute references
  • Real-time Calculation: Automatic formula recalculation

Data Validation

Comprehensive validation system:

  • Type Validation: Text, number, date, boolean validation
  • Range Validation: Min/max value constraints
  • Custom Validation: User-defined validation rules
  • Policy System: Advanced business logic validation

Advanced Features

Policy System

Flexible policy framework for business rules:

  • Validation Policies: Data integrity and format validation
  • Business Logic: Complex rule enforcement
  • Dynamic Updates: Real-time policy modification
  • Type Safety: Full TypeScript support for policies

Rendering System

Customizable cell rendering:

  • Built-in Renderers: Text, number, date, checkbox renderers
  • Custom Renderers: User-defined rendering logic
  • Mixins: Reusable rendering components
  • Styling: Comprehensive styling options

Hub System

Centralized state management:

  • Multi-sheet Support: Multiple sheets in a single hub
  • Event System: Real-time event handling
  • State Synchronization: Automatic state updates
  • Performance: Optimized state management

Event Handling

Comprehensive event system for spreadsheet operations:

  • Data Events: onChange, onSave for cell data modifications
  • Selection Events: onSelect for cell selection changes
  • Structure Events: onInsertRows, onInsertCols, onRemoveRows, onRemoveCols for row/column operations
  • Keyboard Events: onKeyUp for editor keyboard interactions
  • Initialization Events: onInit for table initialization
  • Real-time Feedback: Immediate event notifications for all operations

Performance Features

  • Virtual Scrolling: Efficient rendering for large datasets
  • Lazy Loading: On-demand data loading
  • Memory Management: Optimized memory usage
  • Rendering Optimization: Smart re-rendering strategies
OverviewReact