Limitations
This section documents current limitations, known issues, and workarounds for the worksheet widget.
Copy and Paste Limitations
User Fields:
- Copy-paste not supported for user fields
- Alternative: Use drag-autofill feature
Reference Fields:
- Copy-paste not supported for reference fields
- Workaround: Use the reference editor for each field
Date/DateTime Fields:
- External paste only works with matching date formats
Browser Clipboard Permission:
- Browser Security: Some browsers restrict clipboard access
- Workaround: Use browser permissions to allow clipboard access
Auto-fill Limitations
- Drag-Autofill not supported for Reference fields
- Workaround: Use the reference editor for each field
Field Display Limitations
-
Read-only Attributes: Reference, Expression, Attachment, and RichText fields cannot be edited inline
-
Editor Display: Prefix/Suffix Not shown in custom cell editors for improved navigation usability
Row Reordering vs. Column Filtering & Sorting
- Limitation: Column filtering & sorting is disabled when row reordering is enabled
- Workaround: Complete reordering operations before disabling row reordering to enable filtering & sorting
Frozen Columns
- One Block from the Left: Frozen columns always start at the first column; freezing a column further right also freezes every column to its left
- Workaround: To keep only some columns fixed, drag them to the start of the column order while they are unfrozen, then freeze the last of them
- Width: At least one column always scrolls, but frozen columns keep their width on any screen. If the frozen columns are wider than the worksheet, the other columns can't be scrolled into view
- Workaround: Freeze only narrow key columns; on a small screen, narrow a frozen column by dragging its header edge, or hide it with Column Visibility
- Group Headers While Scrolling: When a header group is partly scrolled under the frozen columns, its label can be hidden until more of the group scrolls into view, because the label is placed over the group's full width
Data Limits
- Row Limit: Optimized for up to 10,000 rows per worksheet
- Column Limit: Best performance with fewer than 50 columns
- Copy/Paste Limit: 1,000 rows maximum for paste operations
Troubleshooting
Need Help? For solutions to common issues and problems, see the Troubleshooting Guide.