Skip to main content

Row Operations

This section covers all row-related functionality in the Worksheet widget, including adding, deleting, reordering and managing rows.

Row Features​

Adding Rows​

  • Insert Row: Insert single or multiple rows at once using the context menu with options for 1, 10, 20, or 50 rows
  • Permission Checks: Insert row is allowed only if user has create permissions & create link option enabled in configuration
  • New Row Positioning: Rows are added at the bottom of the worksheet

Deleting Rows​

  • Row Deletion: Remove individual or multiple rows with confirmation
  • Permission Checks: Deletion allowed only if user has appropriate permissions
  • Confirmation Dialog: Shows count of selected items and asks for confirmation

Row Reordering​

  • Drag and Drop: Change row order by dragging rows when reordering is enabled
  • Visual Feedback: Clear indicators during drag operations
  • Limitations: Reordering disables filtering and sorting features

Row Selection and Navigation​

Selection Methods​

  • Single Row: Click on row header to select entire row
  • Multiple Rows: Click on row header & drag to select row headers of multiple rows
  • Range Selection: Hold Shift and use arrow keys to select a range of rows or click & drag for rage selection
  • All Rows: Use Ctrl+A/Cmd+A to select all visible rows or click on very first cell (top-left) to select entire worksheet

Row Validation​

Validation Process​

  • Real-time Validation: Invalid data is highlighted immediately and prevents further editing until corrected
  • Row-level Checks: Validate entire rows before saving
  • Required Field Validation: Ensure all mandatory fields have values
  • Business Rule Validation: Apply custom validation rules using regex validation attribute configuration

Error Handling​

  • Visual Indicators: Red row header highlighting for invalid rows
  • Error Messages: Detailed tooltips on hover explaining validation failures displayed in first cell of the row
  • Selective Saving: Save valid rows while flagging invalid ones

Performance Considerations​

  • Large Datasets: Row operations may be slower with very large datasets (>10,000 rows)
  • Network Dependency: Row operations require stable internet connection
  • Batch Operations: Large batch operations may have timeout limits

Troubleshooting​

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