WPS Column Type on macOS FAQ

Last updated:July 20, 2026

Common questions about WPS Column Type on macOS usually focus on existing data behavior, dropdown setup, and how the active range is controlled.

FAQ

What happens to existing data after I set a column type?

  1. Existing data is displayed and checked according to the new column type where possible.
  2. For example, if a column is changed to a Date type, recognizable date values can be shown in a date format.
  3. Content that does not match the expected rule is not automatically deleted, but it may no longer match the current type setting.

Where do I set the options for a dropdown list column type?

  1. Right-click the target column header and open the Column Type submenu.
  2. Select Dropdown List.
  3. In the related settings panel, add or adjust the dropdown options for that column.

What does Set Start Row do?

  1. This option controls which row the column type starts from.
  2. The default value is 2, which usually means row 1 is left as a header row.
  3. If the first few rows are used for titles, notes, or content that should not follow the same format, set a larger start row number.

Why is my data still there after I clear a column type?

  1. The Clear command removes only the type setting for that column.
  2. Data already entered in the cells is not deleted.
  3. After clearing, the column returns to plain text and no longer follows the previous validation rule.

Glossary

TermDefinition
Column TypeA setting that applies a consistent data format, input method, or validation rule to an entire column.
Start RowThe control that decides which row the column type starts from, often used to skip header rows.
Dropdown ListA column type that lets users choose from preset options.
CheckboxA column type that shows status through checked or unchecked states.
Plain Text ColumnThe default column state when no specific column type is applied.