How to Use WPS Multidimensional Number Field on macOS

Use WPS Multidimensional Number Field with 4 how-to topics; all 4 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Create a Number Field

Entry path: Click the + button on the right side of the header → Field Type → Number

1. Click the + button on the right side of the header.
2. Select Number from the field type list.
3. Enter a field name.
4. Click OK to finish.

Success Criteria

• Interface result: A new number field column appears in the table.
• What you can do next: You can enter numeric values or open field settings.

Tips While Using

• Common mistake: If you choose the wrong field type, the new column will not behave as expected.
• Environment note: You need permission to edit the table structure.

2. Set the Number Format

Entry path: Right-click the field title → Field Settings → Number Format

1. Right-click the number field title.
2. Select Field Settings.
3. Find Number Format in the settings panel.
4. Choose the format you need, such as integer display or 1 to 9 decimal places.
5. Click OK to save the setting.

Success Criteria

• Interface result: Numbers in the field are displayed in the selected format.
• What you can do next: You can continue entering or editing values.

Tips While Using

• Common mistake: This setting changes display only and does not change the stored value.

3. Set a Default Value

Entry path: Right-click the field title → Field Settings → Default Value

1. Right-click the number field title.
2. Select Field Settings.
3. Find the Default Value option.
4. Enter the preset numeric value.
5. Save the setting, then add a new record to verify it.

Success Criteria

• Interface result: New records are filled with the preset value automatically.
• What you can do next: You can still edit the value manually after the record is created.

Tips While Using

• Common mistake: The default value usually applies to new records only and does not backfill existing records automatically.

4. Show Thousands Separators

Entry path: Right-click the field title → Field Settings → Show Thousands Separators

1. Right-click the number field title.
2. Select Field Settings.
3. Find Show Thousands Separators in the settings panel.
4. Select the option to show thousands separators.
5. Save the setting and review the display result.

Success Criteria

• Interface result: Large numbers are displayed with thousands separators.
• What you can do next: You can use this together with decimal-place settings.

Tips While Using

• Common mistake: Thousands separators improve readability but do not affect calculations.