Cell Features

This section covers all cell-related functionality in the Worksheet widget, including cell editing, formatting, data operations and navigation.

Cell Data Types

Different cell types support various editors and renderers for optimal user experience:

Data Type	Renderer	Editor
Text	Default, Color Picker, Masked Value, Custom	Default, Color Picker, Masked Value, Custom
Numeric	Default, Unformatted, Custom	Default
Currency	Default, Custom	Default
Date	Default, Month Year, Custom	Default, Month Year
DateTime	Default, Time, Custom	Default, Time
Boolean	Checkbox	Default (Checkbox)
Picklist/Reference/User	Default (Text)	Default (Dropdown)
Attachment/Expression (readonly)	Default (Text)	None
RichText (readonly)	Default (Formatted Text)	Default (Dropdown)

For more details about attribute renderers and editors, see Renderer Editors for Attributes.

Cell Features

• Conditional Formatting: Cell styling based on data values
• Renderers: Configured or custom display formats for specific data types
• Editors: Configured or custom input controls for different data types
• Validation Indicators: Visual cues for data validation status

Cell Data Operations

• Copy (Ctrl+C / Cmd+C / Context Menu) - Copy selected cells with formatting preserved
• Copy with Headers (Context Menu) - Copy cells including column headers for external use
• Cut (Ctrl+X / Cmd+X / Context Menu) - Move cell data (unavailable for read-only cells)
• Paste (Ctrl+V / Cmd+V / Context Menu) - Insert clipboard data with validation and format conversion
• Clear Content (Delete) - Remove cell values while preserving formatting
• Auto-fill (Drag corner) - Fill cells vertically with pattern recognition
• Undo (Ctrl+Z / Cmd+Z) - Reverse last edit
• Redo (Ctrl+Shift+Z / Cmd+Shift+Z) - Restore undone edit

Cell Navigation and Editing

Cell navigation and editing operations are covered in detail in the Navigation and Shortcuts section.

Cell Validation

Real-time Validation

• Edit Prevention: Prevents further editing until errors are corrected
• Visual Indicators: Red highlighting for invalid cells
• Row-level Errors: Error indicators in row headers
• Tooltip Messages: Detailed error descriptions on hover
• Selective Operations: Save valid cells while flagging invalid ones

Validation Types

• Required Field Validation: Ensure all mandatory fields have values
• Data Type Validation: Ensure data matches expected format
• Business Rule Validation: Apply custom validation rules using regex
• Format Validation: Check data format (dates, datetime, etc.)

Cell Limitations

• Copy-Paste: Limited for User/Reference fields
• Auto-fill: Not supported for Reference field
• Read-only Fields: Expression, System (Creator/Modifier/Created/Modified), Attachment, and RichText fields cannot be edited

For more details on limitations, see Limitation section.

Best Practices for Cell Operations

• Use keyboard shortcuts for efficient navigation (Tab, Enter, arrows)
• Leverage copy-paste for bulk data entry from Excel
• Fix validation errors immediately to prevent blocking
• Use range selection, drag-autofill for bulk operations
• Match data formats when copying from external sources

Troubleshooting

Need Help? For common issues and solutions related to cell operations, see the Troubleshooting Guide.