When using WPS Currency in Spreadsheet on Android, common questions usually involve currency symbols, field differences, and summary calculations. This section covers 3 frequent questions and a short glossary.
FAQ
Which currency symbols are supported in the currency field?
- The currency field supports common symbols such as RMB, USD, EUR, and GBP.
- On Android, you can enter and view amount values directly.
- For some symbol changes, it is practical to complete the setting on desktop first and then view it on mobile.
What is the difference between a currency field and a number field?
- A currency field is better suited to amount data and displays values in a currency style.
- A number field is better for general numeric records and does not emphasize currency symbol display.
- For quotes, expenses, and budgets, a currency field is easier to identify.
Can the currency field be used in summary calculations?
- Yes. The currency field can be used for totals, averages, and similar summary methods.
- Summary results are displayed in the related currency style.
- You can continue filtering and editing records in the same data table for further analysis.
Glossary
| Term | Definition |
|---|---|
| Currency field | A field type used to store and display amount data. |
| Record details | The panel where you view and edit the current record after tapping a cell. |
| Summary calculation | A calculation such as total or average applied to field data. |