Find 4 common question types about WPS Form, including entry location, supported controls, macro requirements, and suitable scenarios.
FAQ
Where can I find the Form feature?
- Open WPS Spreadsheets and enter a workbook.
- Click the Tools tab.
- Open Developer Tools and then check the Form Controls area.
What form controls can I insert?
- Open the Developer Tools area.
- Check the Form Controls section.
- Select from controls such as buttons, checkboxes, option buttons, list boxes, combo boxes, and scroll bars.
Why are the controls not working as expected?
- Confirm that the control was inserted into the worksheet successfully.
- Check whether the workbook is editable.
- If you need related automation behavior, enable macros and test again.
What scenarios is Form suitable for?
- It is suitable for building data entry layouts in a worksheet.
- It works well for option collection, simple interactive panels, and demo-style forms.
- If you need online survey distribution or PDF collection, choose a tool that matches that scenario.
Glossary
| Term | Definition |
|---|---|
| Form control | An interactive element inserted into a worksheet, such as a button, checkbox, or list box. |
| Developer Tools | The WPS Spreadsheets area used to access advanced tools such as form controls. |
| Macro | An execution mechanism used for some automation behavior and certain control-related scenarios. |
| Combo box | A control that lets users choose from a list of options for fixed-choice input. |