WPS Multidimensional Number Field on macOS: Introduction

WPS Multidimensional Number Field is a field type for storing and displaying numeric data in WPS; it includes 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the How-to Index
Membership-related items	0	Matches the number of membership-related rows in the How-to Index
Membership limit	None	This feature is described as having no membership restriction
Version limit	None	This feature is described as having no version restriction

About This Feature

Overview

Multidimensional Number Field in WPS is used to enter, store, and display numeric data. It works well for prices, quantities, percentages, amounts, and other values that may need calculation or consistent display formatting.

Its main capabilities include:

Create a number field for a new numeric column.
Set number format to show integers or 1 to 9 decimal places.
Set a default value for newly added records.
Show thousands separators for easier reading.

This feature is useful for product tracking, budget records, inventory counts, project data entry, and similar structured workflows. Format settings affect display only and do not change the stored value used in calculations.

System Requirements

Item	Requirement
Operating system	A Mac device that can run WPS Office normally
App version	The latest version of WPS Office for Mac is recommended
Network	No mandatory network connection is required for local field settings; keep a connection available for sign-in or sync scenarios
Other	You need access to the multidimensional table and permission to edit the table structure or field settings

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office for Mac, then open a multidimensional table and confirm that field creation and field settings are available

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Multidimensional Number Field stores numeric values and supports integer display, decimal places, default values, and thousands separators.	Excel for Mac supports number format codes, decimal-place control, thousands separators, and display formatting that does not change the underlying value.	Google Sheets supports number, currency, percentage, and custom number formats, including decimal and thousands separators.	Notion supports number-related database properties and formulas, but it focuses on database properties rather than spreadsheet-style cell display formatting.	Acrobat supports number, currency, and percentage formatting for PDF form fields, mainly for form input rather than multidimensional table field management.
WPS Advantages	Advantage: WPS lets you create the field, set a default value, and adjust display formatting directly at the field level for structured record management.	Compared with WPS: Excel is centered on spreadsheet cell formatting, so field-level defaults and multidimensional table structure are handled differently.	Compared with WPS: Google Sheets is strong for spreadsheet cell formatting, but its workflow is different from field-level defaults in a multidimensional table.	Compared with WPS: Notion is better aligned with database properties and formulas, while number display settings are less centralized in a dedicated field setup flow.	Compared with WPS: Acrobat is mainly designed for PDF form scenarios and does not provide the same multidimensional table structure and record collaboration workflow.
Official Source	—	Excel number format codes	Format numbers in Google Sheets	Notion formulas	Format form fields in Acrobat

Overall Conclusion
If you want a direct way to define numeric rules for structured records in a multidimensional table, WPS provides a more field-centered setup flow. Excel and Google Sheets remain strong choices for traditional spreadsheet cell formatting, while Notion and Adobe are better matched to database formulas or PDF form scenarios.

Use Cases

No.	Scenario	Suitable For	Main Challenge	How This Feature Helps
1	Product price management	Sales and operations teams	Prices are displayed inconsistently	Use number formatting to standardize integer or decimal display
2	Inventory quantity tracking	Warehouse and purchasing teams	Large numbers are hard to scan quickly	Turn on thousands separators for better readability
3	New record entry	Project members and data entry staff	Initial values must be entered repeatedly	Set a default value for the number field
4	Ratio and statistics entry	Finance and analysis teams	Numeric precision is inconsistent	Set the required number of decimal places
5	Table structure expansion	Team collaborators	Adding a new numeric column takes extra steps	Create a number field directly and start using it

Membership & Benefits

Free vs WPS Premium

Capability	Free Users	WPS Premium
Basic use of multidimensional number fields	✅ Available	✅ Available
Core WPS Office productivity features	✅ Available	✅ Available
Advanced PDF, AI, and broader advanced tools	Some features are limited	More features are available
Cloud storage and multi-user sharing plans	Basic allocation	Higher allocation or more plan options

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
You only need to create and configure number fields in a multidimensional table	Free	This feature is described as having no membership restriction
You also need broader PDF, template, AI, or extended productivity features	WPS Premium	Better suited to broader personal or team productivity needs

WPS membership center: Subscribe now