Each column of data must have a corresponding column in the X-Sheets configuration.
Fine-grained configuration can be updated by the Spreadsheet Settings menu.
Configuration of a column
Mandatory items :
| Name | Internal Name |
| Display name | User display name |
| Type | One of the following values : [STRING,DATE,NUMBER,PICTURE,DOCUMENT] |
Fomatting items
| Date format | Pattern with the following conventions : [M:month, d:day, y:year] By default : MM/dd/yyyy |
| Number format | Pattern with the following conventions : [# for any number, . for decimal, 0 for forced digit] Example : “###.0# 12.343 => 12.34 |
Other optional items
| Synchronized | Synchronize this resource (PICTURE and DOCUMENT only) |
| Mandatory | Set the current column as mandatory |
| Primary key | Set this column as primary key (see Normalization) |
| Target sheet | Target Sheet Name |
| Cascade delete | Delete the current item if the target item is deleted |