How to Use WPS Multidimensional Number Field on Windows

Use WPS Multidimensional Number Field through 4 operation topics; all 4 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Create a Number Field

Entry: + button on the right side of the table header → Field Type drop-down list → Number

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

Success Criteria

• Interface result: A new number field column appears in the table.
• Next action available: You can open the field settings panel to adjust format or default value.

Tips While Using

• Common mistake: Closing the window before confirming the field name may leave the field uncreated.
• Environment note: You need permission to edit fields in the current multidimensional table.

2. Set Number Format

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

1. Right-click the number field title.
2. Select Field Settings.
3. Find the number format option in the settings panel.
4. Choose the format you need, such as integer 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.
• Next action available: You can continue entering or editing values in the field.

Tips While Using

• Common mistake: Treating a display-format change as a change to the stored value.
• Environment note: For percentage-style display, check the meaning of the underlying numeric value as well.

3. Set a Default Value

Entry: 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 in the settings panel.
4. Enter the preset numeric value.
5. Save the setting and add a new record.

Success Criteria

• Interface result: New records automatically receive the preset value in this field.
• Next action available: You can still edit the value manually after the record is added.

Tips While Using

• Common mistake: Forgetting to review new records after setting a default value.
• Environment note: The default value is mainly applied when a new record is created; existing records usually need separate review.

4. Turn On the Thousands Separator

Entry: Right-click the field title → Field Settings → thousands separator option

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

Success Criteria

• Interface result: Large numbers are displayed with thousands separators.
• Next action available: You can combine this with decimal-place settings for clearer display.

Tips While Using

• Common mistake: Treating the separator as part of the stored numeric content.
• Environment note: The thousands separator improves readability and does not change the numeric property of the field.