WPS Currency is a money field type in smart tables on iOS; this guide covers 2 core tasks, with 2 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 2 | Matches the number of rows in the How-to Index |
| Available without membership | 2 | Matches the number of Free rows in the index |
| Membership-related items | 0 | All listed tasks are available directly |
About This Feature
Overview
Currency is a money field in WPS smart tables on iOS. It is used to store and display amount data for quotes, expenses, budgets, and similar records.
Core tasks include:
- Create a currency field: set a table field type to Currency from the header editing panel.
- Enter an amount: open a record and type the amount directly in the currency field.
This feature fits expense tracking, quote management, budget follow-up, and dashboard reporting. Compared with a standard number field, a currency field is better suited to amount display because it presents values with a currency symbol, thousands separators, and fixed decimal places.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | An iPhone or iPad that can run WPS Office normally |
| App version | The latest WPS Office version is recommended so the full table field editing entry is available |
| Network | No strict requirement for local field creation or amount entry; keep a network connection available if you need sync |
| Other | Signing in with a WPS account is recommended for sync and cross-device viewing |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Installation | Install WPS Office on your iPhone or iPad, then sign in to your account |
| Check after installation | Open a smart table, tap a header, and confirm that Edit and Field Type are available |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | On iOS, smart tables let you create a Currency field and enter amounts in record details for quotes, expenses, and budgets. | Excel officially supports formatting cells as Currency or Accounting, with currency symbols and decimal-place options. | Google Sheets officially supports currency formatting and custom currency formats for cells. | Notion database Number properties can be formatted as currency for prices and expense tracking. | Acrobat officially supports number and currency formatting for form fields, mainly in PDF form workflows rather than spreadsheet-style tables. |
| WPS Advantages | Distinct: WPS defines Currency at the table field level and fits structured mobile record entry. | Compared with WPS: Excel focuses on cell formatting instead of a table field type for structured records. | Compared with WPS: Google Sheets focuses on cell formatting, with less emphasis on field-based table structure. | Compared with WPS: Notion supports currency in databases, but the workflow is more general database management than table field editing. | Compared with WPS: Acrobat handles currency mainly in PDF forms, not in the same kind of table editing workflow. |
| Official Source | — | Format numbers as currency in Excel | Format numbers in a spreadsheet | Database properties | Field formatting options |
Overall Conclusion: If your main goal is to create a money field and keep entering expense data in a mobile table workflow, WPS provides a more direct field-based setup. Excel and Google Sheets are stronger for cell formatting, Notion is more database-oriented, and Adobe is mainly focused on PDF forms.
Use Cases
| No. | Scenario | Suitable For | Main Pain Point | How Currency Helps |
|---|---|---|---|---|
| 1 | Daily expense logging | Individual users | Spending records are scattered and inconsistent | Create a currency field and enter each amount in one table |
| 2 | Quote tracking | Sales and business users | Project quotes need a consistent money format | Store quote values in a dedicated currency field |
| 3 | Budget follow-up | Team leads | Budget and actual spending are hard to compare quickly | Record budget items and actual amounts in the same table |
| 4 | Dashboard reporting | Table users | Amount fields need to support later reporting | Use the currency field for expense summaries and charts |
| 5 | Mobile data entry | Users working on the go | Entering amounts on a phone can be slow | Open record details and type amounts directly with the number keypad |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Create a currency field | ✅ Available | ✅ Available |
| Enter amounts | ✅ Available | ✅ Available |
| Basic PDF features and reading | ✅ Available | ✅ Available |
| More advanced PDF, template, and extended tools | Partly limited | More features available |
| Cloud storage | 1 GB | Higher-capacity plans available |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended Plan | Why |
|---|---|---|
| You only need to create currency fields and enter amounts in tables | Free | The listed Currency tasks are available without membership |
| You also need more PDF tools, templates, or more cloud storage | WPS Premium | Better suited to broader office needs beyond this field type |
How to Subscribe
- Membership page: Subscribe to WPS Premium
Source: WPS Office pricing page