All versions of Clarion are supported from C55 through the latest C11 releases for both the Legacy and ABC template chains. Multi-dll, standard .dll, and Single EXE targets are all supported directly and automatically based on your project settings.
To add the Spreadsheet Wizard features to an application you simply add a new global extension to your app. Then for each spreadsheet you add the local extension to a process procedure. At that point you can further customize the Spreadsheet Wizard interface by answering the prompts in the template. The standard Clarion process template is supported as well as several third-party templates when used as the base for the Spreadsheet Wizard templates.
The Spreadsheet Wizard template options allow you to fine tune the features that you would like to present to the end user. Here are some of the major options:
- Dynamic sort configuration
- Virtual fields and field overrides
- File exclusions
- Runtime column header setting
- Inherit from browse procedure templates
Developer Embed Points
Developer embed points are provided to offer additional customization of the Excel output. You can automate the process, add totals, or automatically attach a template that will format the spreadsheet display.
With a few template switches the Wizards will speak your language. To use the builtin translation capabilities that come with Query Wizard, you must own a license to Query Wizard and have it installed in your application. In that case, you can access the predefined translation strings for the included languages.
If you don’t have Query Wizard, each product has simple embeds where you can add your translation pairs. This is also convenient if you just want to change the wording on just a few select strings.
Using dictionary options can save time by allowing you to selectively include and/or exclude fields to Wizard field selection. You can also customize override and expressions directly in the dictionary. Careful usage of the dictionary option can speed up development if you have many procedures that use the same tables.
If you need it, the Access Levels features of the Wizards will allow you to setup user and/or group access control for all the saved definitions. You can also use this feature to create developer definitions that the user can have customized access to. It is easy to interface with your own home grown security or any of the third-party security solutions out there.
The interface graphics can all be replaced with images of your choice and ship with 5 different color schemes that you can select to differentiate the different Wizard products. This is useful when you add all the Wizard products to your application or when you just want the interface to more closely match your application look and feel.
The images are all stored in a simple .LIB file so are easily replaced with your own custom images.