Use WPS Column Type on iOS through 3 how-to topics, all available without membership, and jump from the index to the exact steps you need.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Set a Column Type | Free |
| 2 | 2. Set the Start Row | Free |
| 3 | 3. Clear a Column Type | Free |
How-to Guide
1. Set a Column Type
Entry path: Column floating menu → More Options → Column Type
- Open a smart table and tap the column header you want to edit, such as column A, B, or C.
- In the column floating menu, tap More Options.
- Tap Column Type.
- Select the type you want, and the setting takes effect immediately.
- Available types include Date, Checkbox, Progress, Time, Cell Image, Email, and URL.
Success Criteria
- The current column displays according to the selected type.
- New input in that column follows the matching display or validation behavior.
Tips While Using
- One column can use only one column type at a time.
- If you switch to a new type, the previous type is replaced.
2. Set the Start Row
Entry path: Column Type settings page → Set Start Row
- Open the Column Type settings page for the target column.
- Tap the Set Start Row input box.
- Check the default value of 2, which means the column type starts from row 2 and row 1 is usually used as a header row.
- Enter a new starting row number.
- The change takes effect immediately.
Success Criteria
- The selected column type starts from the new row you entered.
- Content before that row is not limited by the column type.
Tips While Using
- If the first few rows are used for titles or notes, set a later start row.
- Different columns can use different start rows as needed.
3. Clear a Column Type
Entry path: Column floating menu → More Options → Column Type → Clear
- Tap the target column header to open the column floating menu.
- Tap More Options.
- Tap Column Type.
- Tap Clear in the upper-right corner.
- The column returns to a regular text column.
Success Criteria
- The column no longer uses the previous type for validation.
- Existing data in the column is still kept.
Tips While Using
- Clearing a column type does not delete the data already entered.
- If you need the rules again, set a new column type afterward.