Table Format Wizard for SaveToDB Add-In
The SaveToDB add-in lets you share Excel table formats using database tables (see the Developer Guide).
When a user connects to an object for the first time, the add-in applies table formats from the database. If the user reconnects to an object, the wizard applies formats from the workbook.
You can manage table formats using this wizard. Additionally, you can use the Save Table Format button from the Save Menu and the Reload Table Format button from the Reload Menu.
Table Format Wizard Controls
- Save in Workbook
- Saves the formats of the selected tables in the workbook.
- Restore from Workbook
- Restores the formats of the selected tables from the workbook.
- Clear in Workbook
- Deletes the formats of the selected tables in the workbook.
- Save in Database
- Saves the formats of the selected tables in the database.
Note: This button is disabled if the user lacks permission. - Restore from Database
- Restores the formats of the selected tables from the database.
Note: This button is disabled if there are no saved table formats in the database. - Clear in Database
- Clears the formats of the selected tables in the database.
Note: This button is disabled if the user lacks permission. - Clear Table Format
- Clears cell formats and data validation in the selected tables.
Conditional formatting remains unchanged. - Apply Default Format
- Applies the default table formatting.
Use the Clear Table Format button to remove existing formatting first. - OK
- Closes the dialog box.
- Cancel
- Closes the dialog box.
Table Format Elements
The SaveToDB add-in saves and restores the following formatting elements:
- Cell formats
- Conditional formatting
- Applied filters
- Sort order rules
- Table totals
- Data validation
- Window properties
- Formula columns
Default Table Formatting
The SaveToDB add-in applies these default rules:
- Auto-sizes columns (maximum width: 500px)
- Hides the row number column
- Sets column A width to 18px if it’s unused and the row number column is present
- Applies date and time formats for date and time columns
- Sets data validation for database tables and views that support saving data changes
- Applies special conditional formatting for non-NULL columns