Sidebar
Advanced Use of Excel Range Wizard 2.0
The Excel Range Wizard 2.0 features several advanced configuration options, with which some of the default behavior of the Wizard can be overridden. They are presented in three panels at the bottom of the 'Choose Excel File' window.
| Creation Rules | |
|---|---|
| Application Style | By default, the wizard will attempt to replicate the visual style of the Excel spreadsheet. To disable this behavior, select ‘Web Form’ style. |
| Container type | By default an Excel range in the Range Wizard will generate Child GUI objects on a LAYOUT PANEL. An earlier version only created a SUB PANE, which is the other option. |
| Tab Creation | By default, ranges selected from different sheets will be placed in different TABBED PANE's to preserve the structure of the Excel workbook. To place all selected ranges on a single TABBED PANE, select ‘Single Tab’. |
| Excess Spacers | Since empty cells are converted into SPACER's, this can result in a large number of SPACER's on the Tree. By default, these SPACER's are merged where possible, this option to disables this behavior. |
| Extracts | To ignore images, form controls or charts during the creation process, unselect them with the check boxes shown here. |
| Optional Rules | |
| Remove | The wizard may completely ignore columns smaller than a defined width, and rows smaller than a defined height with this option. |
| Ignore contents | Similar to Remove options, however the rows or columns will still be represented. The contents of the cells within will not. |
| Ignore empty | Override the Wizard’s default behavior of processing empty general cells that are referenced by other cells, and processing empty formatted cells. |
| Exclude Rules | |
| Exclude Formulas | Not implemented |
| Simplify Formulas | Simplify certain formulas such as OFFSET, by ignoring irrelevant parameters. |
| Exclude Sheets | Specify excluded sheets. Formulas in excluded sheets will not be considered during dependency calculation. |