object Contains all of the lookup tables that the format descriptor indexes refer to. Here the examples show the formatting options, the default value is used to denote each option. NOTE -- Indexes and their values are guaranteed never to change or be removed for a given major API version. However, new values could potentially be added to the ends of lookup tables. Because of this possibility, your code should handle the case where a cell might contain a format index value greater than the size of a lookup table your app has loaded. Your application should check for that case and reload the format tables if necessary. | |
supportedLocales | Array of strings Array of strings representing all Smartsheet-supported locales. |
{- "formats": {
- "defaults": ",,1,1,,,,,,,,,,,,,",
- "bold": [
- "none",
- "on"
], - "color": [
- "none",
- "transparent",
- "#000000",
- "#0B347D",
- "#1061C3",
- "#237F2E",
- "#40B14B",
- "#592C00",
- "#5FB3F9",
- "#61058B",
- "#757575",
- "#7ED085",
- "#9210AD",
- "#974C00",
- "#991310",
- "#B9DDFC",
- "#BDBDBD",
- "#C6E7C8",
- "#D0AF8F",
- "#D190DA",
- "#E2F2FE",
- "#E5E5E5",
- "#E7F5E9",
- "#EA352E",
- "#EA5000",
- "#EBC700",
- "#EBC7EF",
- "#EEDCCA",
- "#F2E8DE",
- "#F4E4F5",
- "#F87E7D",
- "#FEFF00",
- "#FEFF85",
- "#FF8D00",
- "#FFCCD2",
- "#FFCD7A",
- "#FFE1AF",
- "#FFEBEE",
- "#FFED00",
- "#FFF3DF",
- "#FFFEE6",
- "#FFFFFF"
], - "currency": [
- {
- "code": "none",
- "symbol": "none"
}, - {
- "code": "ARS",
- "symbol": "$"
}, - {
- "code": "AUD",
- "symbol": "$"
}, - {
- "code": "BRL",
- "symbol": "R$"
}, - {
- "code": "CAD",
- "symbol": "$"
}, - {
- "code": "CHF",
- "symbol": "CHF"
}, - {
- "code": "CLP",
- "symbol": "$"
}, - {
- "code": "CNY",
- "symbol": "¥"
}, - {
- "code": "DKK",
- "symbol": "kr."
}, - {
- "code": "EUR",
- "symbol": "€"
}, - {
- "code": "GBP",
- "symbol": "£"
}, - {
- "code": "HKD",
- "symbol": "$"
}, - {
- "code": "ILS",
- "symbol": "₪"
}, - {
- "code": "INR",
- "symbol": "₹"
}, - {
- "code": "JPY",
- "symbol": "¥"
}, - {
- "code": "KRW",
- "symbol": "₩"
}, - {
- "code": "MXN",
- "symbol": "$"
}, - {
- "code": "NOK",
- "symbol": "kr"
}, - {
- "code": "NZD",
- "symbol": "$"
}, - {
- "code": "RUB",
- "symbol": "₽"
}, - {
- "code": "SEK",
- "symbol": "kr"
}, - {
- "code": "SGD",
- "symbol": "$"
}, - {
- "code": "USD",
- "symbol": "$"
}, - {
- "code": "ZAR",
- "symbol": "R"
}
], - "dateFormat": [
- "LOCALE_BASED",
- "MMMM_D_YYYY",
- "MMM_D_YYYY",
- "D_MMM_YYYY",
- "YYYY_MM_DD_HYPHEN",
- "YYYY_MM_DD_DOT",
- "DWWWW_MMMM_D_YYYY",
- "DWWW_DD_MMM_YYYY",
- "DWWW_MM_DD_YYYY",
- "MMMM_D",
- "D_MMMM"
], - "decimalCount": [
- [
- "0",
- "1",
- "2",
- "3",
- "4",
- "5"
]
], - "fontFamily": [
- {
- "name": "Arial",
- "traits": [
- "sans-serif"
]
}, - {
- "name": "Roboto",
- "traits": [
- "sans-serif"
]
}, - {
- "name": "Tahoma",
- "traits": [
- "sans-serif"
]
}, - {
- "name": "Times New Roman",
- "traits": [
- "serif"
]
}, - {
- "name": "Verdana",
- "traits": [
- "sans-serif"
]
}
], - "fontSize": [
- "8",
- "9",
- "10",
- "12",
- "14",
- "16",
- "18",
- "20",
- "24",
- "28",
- "32",
- "36"
], - "horizontalAlign": [
- "default",
- "left",
- "center",
- "right"
], - "italic": [
- "none",
- "on"
], - "numberFormat": [
- "none",
- "NUMBER",
- "CURRENCY",
- "PERCENT"
], - "strikethrough": [
- "none",
- "on"
], - "textWrap": [
- "none",
- "on"
], - "thousandsSeparator": [
- "none",
- "on"
], - "underline": [
- "none",
- "on"
], - "verticalAlign": [
- "default",
- "top",
- "middle",
- "bottom"
]
}, - "supportedLocales": [
- "string"
]
}