When using Number, the most common questions focus on formatting support, calculations, and field differences; this FAQ includes 3 common questions and a glossary.
FAQ
What number formats are supported in WPS Number on iOS?
- On iOS, you can create and fill number fields.
- The mobile side does not provide direct display-format adjustment for the number field.
- If you need integers, decimal places, or thousand separators, set them on desktop.
Can a number field calculate values automatically?
- A number field stores numeric values and does not run formula calculations by itself.
- If you need automatic calculations, create a formula field.
- Reference the number field inside the formula field to complete the calculation logic.
What is the difference between a number field and a currency field?
- A number field is suitable for general numeric values such as counts, scores, or statistics.
- A currency field is more suitable for amount-based data and usually carries currency meaning in display.
- Choose the field type based on whether the data needs currency semantics.
Glossary
| Term | Definition |
|---|---|
| Number field | A field type in a multi-dimensional table that stores numeric values. |
| Record details | The expanded editing area opened from a cell, where you can view and edit field values. |
| Formula field | A field type that references other fields and performs calculations or expression-based processing. |