General

General settings allows you to manage checks for whether the data is outdated and whether to commit certain actions.

 

Check whether data is outdated

Refresh data before activating Edit Mode

If selected, data will be re-imported before starting edit session when you click the Edit Mode button.

 

Show warning about outdated data

If selected, you will see a warning message in a specified interval after the last data import or refresh.

 

Outdated time interval

A warning about outdated data will be displayed in the specified time interval.

 

Edit

Advanced Edit Mode

This check box enables advanced edit mode, available in newer Excel Add-ins versions. It provides a lot of new editing features, such as pasting multiple new records, using auto-fill, preserving formulas and user data below the table with the imported data, and many more. Clear this check box to return to an older Edit Mode used in 1.6 and older versions of Excel Add-ins in case of any problem with a newer Edit Mode.

 

 

Confirm commit, rollback or end edit actions

Select this check box if you want to see a confirmation dialog box every time you commit changes, rollback them, or switch off Edit Mode.

 

Continue after commit or rollback

Defines whether to continue Edit Mode or switch it off after changes are committed or rolled back.

 

Refresh all columns after commit

Determines whether to refresh values for all columns after commit, or only for the columns, for which values are explicitly set on the server side (Identity columns, computed columns, columns with no value set, but having default values, etc.). Can be useful, for example, when a trigger changes data values when performing an update operation. Selected by default.

 

Read-only primary key columns for the existing (committed) records

Determines whether to disable editing for primary key columns of already existing records (show them as read-only). It doesn't disable setting a value for a new record. Applicable in Devart Excel Add-ins for databases.

 

Validate required (not null without default value) columns for relational databases

Determines whether to check if a value is set for relational database columns that are declared as NOT NULL in the database and have no default value. If a value is not set, a cell will have the corresponding validation warning.

 

Validate enum values for cloud data sources

Determines whether to query allowed values for cloud picklist/enum fields and create picklists of these values for such fields in Excel. If this check box is selected, you will be able to select a value from the list of the corresponding cloud picklist values, which is more convenient and less error-prone than to enter the corresponding value manually. We recommend to keep this check box selected, unless there is some problem with retrieving picklist field values or you need to work with an enum/picklist field that allows custom values, not from the list of allowed values.

If this check box is selected, you won't be able to enter custom values, so if your picklist field allows custom values and you need to assign them, clear this check box. In the latter case, picklist values are not queried from the data source, and you can work with a picklist field like with a text field. However, if this check box is not selected, you need to make sure that you are entering correct values for such fields, not allowing custom values, yourself.

 

Save line breaks in multi-line text cells as

Determines how line breaks in multi-line cells are saved in the data source: as CR LF or only as one LF character.