WPS Multidimensional Number Field on macOS FAQ

Last updated:July 22, 2026

Common questions about WPS Multidimensional Number Field usually focus on display formatting, calculation behavior, default values, and field limits; this section includes 4 FAQs and 4 glossary terms.

FAQ

Why does a percentage-style number look different from the calculation value?

  1. Open Field Settings for the number field.
  2. Check whether the current display format uses percentage or decimal-related rules.
  3. Compare the entered value with the displayed value. For example, 0.5 may display as 50% while calculations still use the stored numeric value.

How do I clear a custom number format?

  1. Right-click the number field title.
  2. Open Field Settings.
  3. Choose the default numeric display option in the format settings and save it.

Why can’t I enter text in a number field?

  1. Confirm that the current column is a Number field.
  2. Enter numeric content instead of text.
  3. If you also need notes or descriptions, add a text field alongside the number field.

Why didn’t old records change after I set a default value?

  1. Make sure the default value setting was saved.
  2. Add a new record to confirm that the default value is filled automatically.
  3. Update existing records manually if you want earlier entries to change.

Glossary

TermDefinition
Number fieldA field type in a multidimensional table that stores numeric values for display and calculation.
Default valueA preset value that is filled in automatically when a new record is created.
Thousands separatorA display format that separates large numbers into readable groups.
Stored valueThe underlying numeric value used in calculations, even when the display format changes.