WPS Number Field on macOS FAQ

Last updated:July 21, 2026

When using WPS Number Field, common questions usually focus on display formatting, default values, and data entry rules; this FAQ includes 4 common questions and a glossary.

FAQ

Why does the displayed result look different from the calculation value?

  1. Open Field Settings for the number field.
  2. Check whether integer display, decimal places, or the thousands separator is enabled.
  3. Confirm that the change is in display style rather than the stored value.
  4. If needed, switch to a more suitable number format.
  1. Check whether the current display format matches your expectation.
  2. Review whether the entered value and the display style are aligned.
  3. If the field is used in calculations, also review the formula logic and display format together.

How do I clear a custom number format?

  1. Right-click the number field header.
  2. Open Field Settings.
  3. Change the format back to the default numeric display style.
  4. Save the setting and confirm that the field display is restored.

Why is text not kept as expected when I enter it?

  1. Confirm that the current column is a number field.
  2. Number fields are mainly used to store numeric values.
  3. If you need to enter text, switch to a field type that is designed for text input.

Glossary

TermDefinition
Number FieldA field type in a data table that stores and displays numeric values that can be used in calculations.
Default ValueA preset value that is filled in automatically when a new record is added.
Thousands SeparatorA display style that separates large numbers for easier reading, such as 1,000.
Number FormatA setting that controls how numeric values are displayed, such as integer or a fixed number of decimal places.