This example demonstrates how to use custom cell editors to create a data entry form that allows users to quickly generate invoices. The required data entry fields are marked with an asterisk. To add a new record to the invoice or delete the existing one, a user should switch to the Invoice tab and click the Add or Remove button, respectively. All other content is protected to prevent inappropriate modifications.
Data for the invoice is provided based on the document template (DevAVInvoicing.xltx), which includes the following worksheets:
- Invoice – contains a sales entry form;
- Customers (hidden) – contains customer info;
- Employees (hidden) – contains a list of employees;
- Products (hidden) – contains product data;
- Stores (hidden) – contains information about stores owned by customers.
To retrieve the required data from worksheets, the Spreadsheet uses the VLOOKUP and DGET functions. For example, when a user selects a customer's name in the Billing Address section, VLOOKUP is used to find and display the customer's billing address. In the same way, the DGET function is used to automatically display the shipping address based on the customer's name and the selected city of the store to which the order should be delivered.