WPS Currency Field is a currency-formatted number field in Multi-Dimensional Tables for prices, reimbursements, budgets, and other financial records; 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 index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
| Version limit | None | No version gate is described for this feature |
| Membership limit | None | The feature can be used directly |
About This Feature
Overview
Currency Field is a special number field in Multi-Dimensional Tables. After you enter a value, the field displays it in a currency format, making it suitable for product prices, reimbursement amounts, budget values, and other financial data.
Its main capabilities include:
- Create a currency field directly from the field type list.
- Set a currency symbol such as RMB (¥) or USD ($).
- Set decimal places for consistent amount display.
- Set a default value for new records.
Because the field remains numeric, it works well in table workflows that need both currency display and numeric calculation.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office normally |
| App version | The latest version of WPS Office is recommended |
| Network | No mandatory network connection for local editing; network access is needed for sign-in or sync |
| Other | Access to Multi-Dimensional Tables and permission to edit fields |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Installation notes | Download and install WPS Office for Windows, then open a Multi-Dimensional Table to use field-related features |
| Post-install check | Open a Multi-Dimensional Table, click the + button on the header, and confirm that Currency appears in the field type list |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Multi-Dimensional Tables can create a Currency Field, set the currency symbol, decimal places, and default value, and display amounts in a currency format. | Microsoft Lists and SharePoint lists support a Currency column for financial calculations and predefined currency formats. | Google Sheets supports currency formatting for cells, including custom currency formats and decimal-place settings. | Notion database Number properties can be formatted as currency, and new properties can be added with Add property or the + button. | Adobe Acrobat form fields support Number and Currency formatting categories, but the feature is designed for PDF forms rather than table fields. |
| WPS Advantages | Advantage: WPS handles field creation, symbol selection, decimal-place settings, and default values directly at the table-field level, which fits structured amount entry. | Compared with WPS: Microsoft focuses more on list column storage and formatting rules in list-based workflows. | Compared with WPS: Google focuses more on cell formatting inside spreadsheets. | Compared with WPS: Notion supports database property formatting, but the workflow is more database-oriented than table-field entry. | Compared with WPS: Adobe mainly targets PDF form amount input instead of table or database field management. |
| Official Source | — | List and library column types and options | Format numbers in a spreadsheet | Database properties | Format form fields in Acrobat |
Overall Conclusion
WPS Currency Field is well suited to structured amount management in Multi-Dimensional Tables, especially when teams need consistent field formatting, default values, and later calculations. Other products also support currency display or amount input, but they focus more on list columns, spreadsheet cells, database properties, or PDF forms.
Use Cases
| No. | Scenario | Suitable For | Main Pain Point | How Currency Field Helps |
|---|---|---|---|---|
| 1 | Product price management | Sales and operations teams | Prices in one column are not displayed consistently | Use a Currency Field to standardize amount display |
| 2 | Reimbursement tracking | Admin and finance teams | It is hard to identify the currency quickly after entry | Set a fixed currency symbol for the field |
| 3 | Budget tracking | Project managers and team leads | Decimal precision is inconsistent across records | Set uniform decimal places |
| 4 | Faster record entry | Data entry staff | Repeatedly entering common amounts takes time | Set a default value for new records |
| 5 | Financial calculations | Finance and analysis teams | Amounts need to look like currency and still stay numeric | Store amount data in a currency-formatted numeric field |
Membership & Benefits
Free vs WPS Premium
| Capability | Free Users | WPS Premium |
|---|---|---|
| Basic Writer, Spreadsheet, and Presentation components | ✅ | ✅ |
| Basic use of Currency Field | ✅ | ✅ |
| Some advanced PDF and extended features | Limited or unavailable depending on the feature | Broader access |
| Cloud storage and some value-added services | Basic quota | Higher quota or more benefits |
Source: Why do I need to pay for WPS Office?; WPS Office pricing page
Recommendations
| Scenario | Recommended Plan | Why |
|---|---|---|
| Daily price, reimbursement, or budget tracking | Free | Currency Field itself has no membership limit for basic setup and entry |
| Workflows that also need more PDF, cloud, or extended office features | WPS Premium | A better fit when amount management is only one part of a broader office workflow |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page