WPS Column Type on Android FAQ

Last updated:July 20, 2026

Common questions about WPS Column Type on Android mainly involve existing data, start-row behavior, and undo options; this section includes 3 quick answers.

FAQ

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

  1. Existing data is checked and displayed according to the new type when possible.
  2. For example, if a text column is changed to Date, recognizable date values can be displayed in a date format.
  3. Content that does not match the target type remains in place and may be flagged as not meeting the preset rule.

What does Set Start Row do?

  1. This option controls the row from which the column type starts to apply.
  2. The default is row 2, which helps keep row 1 as a header row.
  3. If the first rows contain notes or merged title areas, you can move the start row lower.

Can I undo a column type change?

  1. Yes. You can use Undo to revert a recent change.
  2. If you only want to remove the current rule, open the Column Type page and tap Clear.
  3. Before undoing, check whether the current column display matches what you want.

Glossary

TermDefinition
Column TypeA setting that assigns one data format, display style, and validation rule to a full column.
Start RowThe control that decides from which row the column type begins to apply.
Clear Column TypeRemoves the current type restriction and returns the column to a normal text column without deleting existing data.