Use Export as Numeric Table through 3 indexed topics, with 0 free items and 3 membership-related items; choose a topic below and follow the steps in order.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Open the Export as Numeric Table entry | WPS Premium required |
| 2 | 2. Review detected worksheet and formula counts | WPS Premium required |
| 3 | 3. Start the export and create a new file | WPS Premium required |
How-to Guide
1. Open the Export as Numeric Table entry
Feature entry: Top menu bar More → More output conversion → Export as Numeric Table
- Open a spreadsheet that contains formulas in WPS Office on Android.
- Tap More on the top menu bar.
- Select More output conversion from the menu.
- Tap Export as Numeric Table to enter the feature page.
Success Criteria
- Interface result: The Export as Numeric Table page opens.
- Next action available: You can review the detected worksheet and formula information.
Tips While Using
- Membership: This feature requires WPS Premium.
- Environment: It is helpful to confirm that the current spreadsheet contains formulas before starting the export.
2. Review detected worksheet and formula counts
Feature entry: Automatic detection after entering the feature page
- After opening the feature page, wait while WPS scans the current spreadsheet.
- Check the number of worksheets shown on the page.
- Check the total number of formulas shown on the page.
- Confirm that the current file is the one you want to export as numeric values.
Success Criteria
- Interface result: The page shows the worksheet count and total formula count.
- Next action available: You can continue to the export step.
Tips While Using
- Common issue: If the file contains no formulas, the exported result may look very similar to the original file.
- Membership: This feature requires WPS Premium.
3. Start the export and create a new file
Feature entry: Export as Numeric Table page → Start Export
- After confirming the detected information, tap Start Export.
- Wait while WPS replaces formulas with their numeric results.
- Open the newly generated file after the export finishes.
- Check that the cells in the new file keep values instead of formulas.
Success Criteria
- Interface result: A new spreadsheet file is created.
- Next action available: You can save, share, or continue editing the new file.
- No side effect: The original file remains available for later formula editing.
Tips While Using
- Common issue: The exported file no longer keeps the original formula relationships, so changing a value there will not trigger recalculation.
- Membership: This feature requires WPS Premium.