How to Use WPS Calculation Options on iOS

This how-to guide includes 3 topics: turning on the persistent sum and count panel, showing summary results from the floating edit bar, and copying a summary result; 3 topics are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Turn on the persistent sum and count panel

Entry: View tab → Turn on persistent sum and count

1. Select the cells or range that you want to calculate and count.
2. Tap the View tab at the bottom of the screen.
3. Tap Turn on persistent sum and count.
4. Review the summary panel at the top of the screen for sum, average, maximum, minimum, count, and numerical count.
5. To close the persistent display, tap the X button on the left side of the summary panel.

Success Criteria

• Interface result: A summary panel appears at the top of the screen.
• What you can do next: You can switch to another selection and continue reviewing updated summary values.
• No side effect: The spreadsheet content is not changed.

Tips While Using

• Common mistake: If you do not select cells first, the summary results may not appear as expected.
• Environment note: The displayed results depend on the current selection, and blank or non-numeric content can affect some values.

2. Show summary results from the floating edit bar

Entry: Floating edit bar → More actions → Show sum

1. Select the cells or range that you want to calculate and count to open the floating edit bar.
2. Tap More actions on the floating edit bar.
3. Tap Show sum.
4. Review the summary panel that appears at the top of the screen.

Success Criteria

• Interface result: A summary panel appears at the top of the screen.
• What you can do next: You can continue checking sum, average, and other summary values.
• No side effect: No formula is inserted, and the original data is not changed.

Tips While Using

• Common mistake: If no range is selected first, the related option may not appear in the floating edit bar.
• Environment note: The floating edit bar can appear slightly differently depending on the current editing state.

3. Copy a summary result

Entry: Any summary item in the summary panel

1. First display the summary panel by using either method above.
2. Find the summary value you need, such as sum or average.
3. Tap the corresponding summary item.
4. Paste the copied result into a target cell, chat window, or note.

Success Criteria

• Interface result: After tapping a summary item, you can proceed to paste the copied value.
• What you can do next: You can reuse the copied result in another location.
• No side effect: Copying does not change the original selected data.

Tips While Using

• Common mistake: If the summary panel is not displayed first, you cannot tap a summary result to copy it.
• Environment note: The final paste result depends on whether the target app supports the current clipboard content.