Skip to main content

Troubleshooting

This comprehensive guide covers common issues, problems, and their solutions across all worksheet functionality including row operations, column operations, data management, navigation, performance, menu options, and linking.

Row Operation Issues​

Cannot Add Rows​

  • Check Permissions: Verify user has create permissions & create link option is enabled in worksheet configuration
  • Relationship Constraints: Check if relationship cardinality allows additional rows

Cannot Delete Rows​

  • Permission Check: Verify delete permissions on selected rows & state of the rows

Row Reordering Not Working​

  • Enable Reordering: Check if "Allow Reordering" is configured
  • Permission Check: Verify user has edit permissions

Validation Errors​

  • Required Fields: Ensure all mandatory fields have values
  • Data Format: Check that data matches expected format (dates, numbers, etc.)
  • Business Rules: Review custom validation rules applied using regex that may be failing

Column Operation Issues​

Filtering Not Working​

  • Check Reordering: Ensure row reordering is disabled
  • Data Type Issues: Verify filter criteria match column data type

Column Display Issues​

  • Hidden Columns: Check column visibility configuration
  • Width Problems: Verify column width configuration
  • Header Display: Ensure column labels are properly configured
  • Data Loading: Check if data is properly loaded for the column

Data Management Issues​

Save Issues​

  • Validation Errors: Fix highlighted validation errors before saving
  • Network Problems: Check internet connection stability
  • Permission Changes: Verify user still has save permissions
  • Concurrent Edits: Handle conflicts with other users' changes

Copy-Paste Issues​

  • Unsupported Fields: User and Reference fields don't support copy-paste
  • Format Mismatch: Ensure data format matches field requirements
  • Date Format Issues: Ensure date formats match system configuration
  • Permission Restrictions: Verify user has edit permissions for the column
  • Large Data: Break large paste operations into smaller chunks
  • Browser Limitations: Check browser clipboard access permissions

Auto-fill Limitations​

  • Complex Data Types: Auto-fill not supported for Reference - enter each field value individually using appropriate selectors

Export Failures​

  • Permission Issues: Verify export configuration for worksheet
  • Format Problems: Check data formatting in export results
  • Network Timeouts: Retry failed exports or reduce data volume

Auto-save Issues​

  • Network Connectivity: Auto-save may fail during network connectivity issues
  • Large Data: Large amounts of data may cause server performance issues
  • Concurrent Users: Data conflicts, lost changes, inconsistent states
  • Right-click Location: Make sure you are right clicking on worksheet cells or headers to open context menu
  • Permission Check: Verify user has necessary permissions
  • Browser Refresh: Try refreshing the browser page
  • Data State: Some options only appear with specific data conditions

Operations Failing​

  • Validation Errors: Check for data validation issues
  • Session Timeout: Re-login if session has expired
  • Network Problems: Verify internet connection stability
  • Large Operations: Break large operations into smaller chunks
  • Data Volume: Use filters to reduce dataset size before operations
  • Network Problems: Verify internet connection stability

Keyboard Shortcuts Not Working​

  • Browser Focus: Ensure worksheet has focus
  • Custom Editors: Remember limitations with custom field editors
  • Operating System: Verify correct key combinations for your OS

Performance Issues​

Unresponsive Editing​

  • Check Validation: Verify data matches expected format and any regex validation added for field
  • Review Field Types: Check for conflicts with complex field types

Slow Initial Loading​

  • Apply Filters: Use default filters to reduce initial dataset
  • Clear Cache: Clear browser cache to improve loading speed

General Resolution Strategies​

Immediate Fixes​

  1. Refresh Browser: Often resolves temporary display or interaction issues
  2. Clear Cache: Remove cached data that might be causing problems
  3. Check Permissions: Verify user has appropriate access rights
  4. Reload Data: Refresh worksheet data to get latest information
  5. Retry Operations: Attempt failed operations again after a brief pause

Best Practices to Avoid Issues​

Data Management​

  1. Regular Saves: Save work frequently to prevent data loss
  2. Validate Early: Fix validation errors as soon as they appear
  3. Use Filters: Apply filters to work with manageable data sets
  4. Test Changes: Verify changes work correctly before proceeding
  5. Backup Data: Export important data regularly

Performance Optimization​

  1. Limit Columns: Show only necessary columns to improve performance
  2. Reduce Data Volume: Use appropriate filters and pagination
  3. Network Awareness: Consider connection quality when working with large datasets