Feature Description
Attribute table drag-and-drop assignment enables rapid value assignment from source cells to target cells through mouse dragging, achieving copy, arithmetic sequence, and geometric sequence effects to enhance data entry and editing efficiency.
This operation is only supported within the same column. After selecting cells, move the cursor to the lower-right corner. When the cursor changes to a crosshair, perform dragging for automatic assignment. Specific feature descriptions are as follows:
- Drag-and-Drop Assignment Methods
Three drag-and-drop assignment methods are available:
| Type | Operation | Assignment Method |
| Copy | 1. Select any number/type of cells, hold Ctrl key and drag. 2. For Boolean, Char or Text types (cell values contain only text), copying is the only supported method - drag directly without key combination. 3. Select one or multiple cells (non-numeric/date formats): Drag directly to copy. |
Assigned cells maintain same values as selected cells. |
| Geometric Sequence | Select two consecutive cells with different values, hold Shift key. | Calculate subsequent cell values based on quotient of selected cells. (Example: Selected values 1,3. Drag down 4 cells → 1,3,9,27,81,243) |
| Arithmetic Sequence | Without Ctrl/Shift keys: 1. Select two consecutive different-value cells and drag directly. 2. For multiple selected cells: Only numeric/date fields support arithmetic update. |
Calculate subsequent values based on difference of selected cells. (Example: Selected 1,3. Drag down 4 cells → 1,3,5,7,9,11) |
- Drag-and-Drop Methods by Data Type
Supported assignment methods vary by data type as shown below:
| Type | Supported Methods |
| Short | Arithmetic, Geometric, Copy |
| 32-bit Integer | Arithmetic, Geometric, Copy |
| Long | Arithmetic, Geometric, Copy |
| Double | Arithmetic, Geometric, Copy |
| Single | Arithmetic, Geometric, Copy |
| Text | Arithmetic, Geometric, Copy |
| Char | Copy |
| Boolean | Copy |
| Date | Arithmetic, Copy |
| Byte | Copy |
| Long Binary | Not Supported |
Notes:Text fields support arithmetic/geometric sequences only when: ① Two consecutive cells share same text prefix with numeric suffix (e.g. "Day 1, Day 2"); ② All cell values are numeric.
Related Topics