WPS Multidimensional Text Field on macOS FAQ

Common questions about WPS Multidimensional Text Field usually focus on field selection, default values, duplicate control, and data-entry rules; this FAQ covers 4 frequent questions and answers.

FAQ

What is the difference between a text field and a numeric field?

1. A text field stores content as text and is suitable for names, notes, and identifiers.
2. A numeric field is more suitable for calculations, summaries, and numeric formatting.
3. For long numeric values such as ID numbers or document numbers, a text field is usually the better choice to preserve the original format.

How can I use an existing field as a text field?

1. Right-click the target field title.
2. Open Field Settings.
3. Before changing the field type to Text, review the current content and confirm that the displayed format should stay as text.
4. After the change, check the cell display results to confirm they match your needs.

Why can’t I enter repeated content after duplicate prevention is enabled?

1. This happens because Prevent Duplicate Entries is turned on for the field.
2. When the new value matches an existing record, the system prompts you to change it.
3. Enter a different value, or review and clean up existing duplicates before continuing.

Why should default values and duplicate rules be planned in advance?

1. A default value automatically fills new records and is useful for repeated content.
2. Duplicate prevention is useful for identifiers, account names, and other values that should stay distinct.
3. If a field needs both prefilling and strict value control, it helps to confirm the entry rules before finalizing the field design.

Glossary