aggrid-8.x-1.x-dev/config/install/aggrid.general.yml

version: 'Community'
source: 'cdn'
license_key: ''
aggridoptions: "{\r\n  \"enableRangeSelection\": true,\r\n  \"ensureDomOrder\": true,\r\n  \"domLayout\": \"autoHeight\",\r\n  \"stopEditingWhenGridLosesFocus\": true,\r\n  \"enterMovesDownAfterEdit\": true,\r\n  \"enterMovesDown\": true,\r\n  \"defaultColDef\": {\r\n    \"suppressMovable\": true,\r\n    \"suppressMenu\": true\r\n  }\r\n}"
aggridgsjson: "{\r\n  \"parserTypes\": {\r\n    \"int\": {\r\n      \"regEx\": \"^\\\\d+$\",\r\n      \"restrictInput\": \"numeric\",\r\n      \"errorMsg\": \"Value must be a positive integer only. No decimals, commas, or other characters.\"\r\n    },\r\n    \"intN\": {\r\n      \"regEx\": \"^-\\\\d+$\",\r\n      \"restrictInput\": \"numeric\",\r\n      \"errorMsg\": \"Value must be a negative integer only. No decimals, commas, or other characters.\"\r\n    },\r\n    \"intPN\": {\r\n      \"regEx\": \"^-?\\\\d+$\",\r\n      \"restrictInput\": \"numeric\",\r\n      \"errorMsg\": \"Value must be a positive/negative integer only. No decimals, commas, or other characters.\"\r\n    },\r\n    \"dateUSASTD\": {\r\n      \"regEx\": \"(?=\\\\d)^(?:(?!(?:10\\\\D(?:0?[5-9]|1[0-4])\\\\D(?:1582))|(?:0?9\\\\D(?:0?[3-9]|1[0-3])\\\\D(?:1752)))((?:0?[13578]|1[02])|(?:0?[469]|11)(?!\\\\/31)(?!-31)(?!\\\\.31)|(?:0?2(?=.?(?:(?:29.(?!000[04]|(?:(?:1[^0-6]|[2468][^048]|[3579][^26])00))(?:(?:(?:\\\\d\\\\d)(?:[02468][048]|[13579][26])(?!\\\\x20BC))|(?:00(?:42|3[0369]|2[147]|1[258]|09)\\\\x20BC))))))|(?:0?2(?=.(?:(?:\\\\d\\\\D)|(?:[01]\\\\d)|(?:2[0-8])))))([-.\\\\/])(0?[1-9]|[12]\\\\d|3[01])\\\\2(?!0000)((?=(?:00(?:4[0-5]|[0-3]?\\\\d)\\\\x20BC)|(?:\\\\d{4}(?!\\\\x20BC)))\\\\d{4}(?:\\\\x20BC)?)(?:$|(?=\\\\x20\\\\d)\\\\x20))?((?:(?:0?[1-9]|1[012])(?::[0-5]\\\\d){0,2}(?:\\\\x20[aApP][mM]))|(?:[01]\\\\d|2[0-3])(?::[0-5]\\\\d){1,2})?$\",\r\n      \"restrictInput\": \"date\",\r\n      \"errorMsg\": \"Value must be a date in the following format: mm/dd/yyyy\"\r\n    },\r\n    \"dec\": {\r\n      \"regEx\": \"^\\\\d*\\\\.?\\\\d+$\",\r\n      \"restrictInput\": \"numeric\",\r\n      \"errorMsg\": \"Value must be a positive decimal only.\"\r\n    },\r\n    \"decN\": {\r\n      \"regEx\": \"^-\\\\d*\\\\.?\\\\d+$\",\r\n      \"restrictInput\": \"numeric\",\r\n      \"errorMsg\": \"Value must be a negative decimal only.\"\r\n    },\r\n    \"decPN\": {\r\n      \"regEx\": \"^-?\\\\d*\\\\.?\\\\d+$\",\r\n      \"restrictInput\": \"numeric\",\r\n      \"errorMsg\": \"Value must be a positive/negative decimal only.\"\r\n    },\r\n    \"dropdown\": {\r\n      \"errorMsg\": \"Value must match an item provided in the drop down options. Double click the field to view.\"\r\n    }\r\n  },\r\n  \"formatTypes\": {\r\n    \"numDec\": {\r\n      \"type\": \"number\",\r\n      \"locale\": \"en\",\r\n      \"excelType\": \"excelDecimal\",\r\n      \"options\": {\r\n        \"maximumFractionDigits\": 8\r\n      }\r\n    },\r\n    \"numInt\": {\r\n      \"type\": \"number\",\r\n      \"locale\": \"en\",\r\n      \"excelType\": \"excelNumber\",\r\n      \"options\": {\r\n        \"maximumFractionDigits\": 0\r\n      }\r\n    },\r\n    \"numPer\": {\r\n      \"type\": \"number\",\r\n      \"locale\": \"en\",\r\n      \"excelType\": \"excelPercent\",\r\n      \"options\": {\r\n        \"style\": \"percent\",\r\n        \"maximumFractionDigits\": 2,\r\n        \"minimumFractionDigits\": 2\r\n      }\r\n    },\r\n    \"numUsd\": {\r\n      \"type\": \"number\",\r\n      \"locale\": \"en\",\r\n      \"excelType\": \"excelUSCurrency\",\r\n      \"options\": {\r\n        \"style\": \"currency\",\r\n        \"currency\": \"USD\",\r\n        \"maximumFractionDigits\": 2\r\n      }\r\n    }\r\n  },\r\n  \"restrictInput\": {\r\n    \"numeric\": {\r\n      \"regEx\": \"[^-\\\\.\\\\d]\"\r\n    },\r\n    \"date\": {\r\n      \"regEx\": \"[^\\\\d\\\\/]\"\r\n    }\r\n  }\r\n}"
aggridexcelstyles: "[\r\n  {\r\n    \"id\": \"header\",\r\n    \"interior\": {\r\n      \"color\": \"#f5f7f7\",\r\n      \"pattern\": \"Solid\"\r\n    },\r\n    \"font\": {\r\n      \"bold\": true\r\n    },\r\n    \"alignment\": {\r\n      \"wrapText\": true\r\n    },\r\n    \"borders\": {\r\n      \"borderBottom\": {\r\n        \"color\": \"#000000\",\r\n        \"lineStyle\": \"Continuous\",\r\n        \"weight\": 1\r\n      },\r\n      \"borderLeft\": {\r\n        \"color\": \"#000000\",\r\n        \"lineStyle\": \"Continuous\",\r\n        \"weight\": 1\r\n      },\r\n      \"borderRight\": {\r\n        \"color\": \"#000000\",\r\n        \"lineStyle\": \"Continuous\",\r\n        \"weight\": 1\r\n      },\r\n      \"borderTop\": {\r\n        \"color\": \"#000000\",\r\n        \"lineStyle\": \"Continuous\",\r\n        \"weight\": 1\r\n      }\r\n    }\r\n  },\r\n  {\r\n    \"id\": \"aggrid-cell-section\",\r\n    \"interior\": {\r\n      \"color\": \"#f5f7f7\",\r\n      \"pattern\": \"Solid\"\r\n    },\r\n    \"font\": {\r\n      \"bold\": true\r\n    },\r\n    \"alignment\": {\r\n      \"wrapText\": true\r\n    },\r\n    \"borders\": {\r\n      \"borderBottom\": {\r\n        \"color\": \"#000000\",\r\n        \"lineStyle\": \"Continuous\",\r\n        \"weight\": 1\r\n      },\r\n      \"borderLeft\": {\r\n        \"color\": \"#000000\",\r\n        \"lineStyle\": \"Continuous\",\r\n        \"weight\": 1\r\n      },\r\n      \"borderRight\": {\r\n        \"color\": \"#000000\",\r\n        \"lineStyle\": \"Continuous\",\r\n        \"weight\": 1\r\n      },\r\n      \"borderTop\": {\r\n        \"color\": \"#000000\",\r\n        \"lineStyle\": \"Continuous\",\r\n        \"weight\": 1\r\n      }\r\n    }\r\n  },\r\n  {\r\n    \"id\": \"aggrid-cell-label\",\r\n    \"interior\": {\r\n      \"color\": \"#fbfdfd\",\r\n      \"pattern\": \"Solid\"\r\n    },\r\n    \"font\": {\r\n      \"old\": true\r\n    },\r\n    \"alignment\": {\r\n      \"wrapText\": true\r\n    },\r\n    \"borders\": {\r\n      \"borderBottom\": {\r\n        \"color\": \"#000000\",\r\n        \"lineStyle\": \"Continuous\",\r\n        \"weight\": 1\r\n      },\r\n      \"borderLeft\": {\r\n        \"color\": \"#000000\",\r\n        \"lineStyle\": \"Continuous\",\r\n        \"weight\": 1\r\n      },\r\n      \"borderRight\": {\r\n        \"color\": \"#000000\",\r\n        \"lineStyle\": \"Continuous\",\r\n        \"weight\": 1\r\n      },\r\n      \"borderTop\": {\r\n        \"color\": \"#000000\",\r\n        \"lineStyle\": \"Continuous\",\r\n        \"weight\": 1\r\n      }\r\n    }\r\n  },\r\n  {\r\n    \"id\": \"aggrid-cell-disabled\",\r\n    \"interior\": {\r\n      \"color\": \"#CCCCCC\",\r\n      \"pattern\": \"Solid\"\r\n    }\r\n  },\r\n  {\r\n    \"id\": \"aggrid-cell-indent\",\r\n    \"alignment\": {\r\n      \"indent\": 1\r\n    }\r\n  },\r\n  {\r\n    \"id\": \"aggrid-cell-indent-dbl\",\r\n    \"alignment\": {\r\n      \"indent\": 2\r\n    }\r\n  },\r\n  {\r\n    \"id\": \"excelDateTime\",\r\n    \"dataType\": \"dateTime\",\r\n    \"numberFormat\": {\r\n      \"format\": \"mm/dd/yyyy hh:mm:ss;;;\"\r\n    }\r\n  },\r\n  {\r\n    \"id\": \"excelDate\",\r\n    \"dataType\": \"dateTime\",\r\n    \"numberFormat\": {\r\n      \"format\": \"mm/dd/yyyy;@\"\r\n    }\r\n  },\r\n  {\r\n    \"id\": \"excelPercent\",\r\n    \"dataType\": \"number\",\r\n    \"numberFormat\": {\r\n      \"format\": \"0.00%\"\r\n    }\r\n  },\r\n  {\r\n    \"id\": \"excelCurrency\",\r\n    \"dataType\": \"number\",\r\n    \"numberFormat\": {\r\n      \"format\": \"#,##0.00\"\r\n    }\r\n  },\r\n  {\r\n    \"id\": \"excelCurrencyNC\",\r\n    \"dataType\": \"number\",\r\n    \"numberFormat\": {\r\n      \"format\": \"0.00\"\r\n    }\r\n  },\r\n  {\r\n    \"id\": \"excelUSCurrency\",\r\n    \"dataType\": \"number\",\r\n    \"numberFormat\": {\r\n      \"format\": \"$#,##0.00\"\r\n    }\r\n  },\r\n  {\r\n    \"id\": \"excelGreenBackground\",\r\n    \"interior\": {\r\n      \"color\": \"#b5e6b5\",\r\n      \"pattern\": \"Solid\"\r\n    }\r\n  },\r\n  {\r\n    \"id\": \"excelRedFont\",\r\n    \"font\": {\r\n      \"fontName\": \"Calibri Light\",\r\n      \"underline\": \"Single\",\r\n      \"italic\": true,\r\n      \"color\": \"#ff0000\"\r\n    }\r\n  },\r\n  {\r\n    \"id\": \"excelDarkGreyBackground\",\r\n    \"interior\": {\r\n      \"color\": \"#888888\",\r\n      \"pattern\": \"Solid\"\r\n    },\r\n    \"font\": {\r\n      \"fontName\": \"Calibri Light\",\r\n      \"color\": \"#ffffff\"\r\n    }\r\n  },\r\n  {\r\n    \"id\": \"excelBoldBorders\",\r\n    \"borders\": {\r\n      \"borderBottom\": {\r\n        \"color\": \"#000000\",\r\n        \"lineStyle\": \"Continuous\",\r\n        \"weight\": 3\r\n      },\r\n      \"borderLeft\": {\r\n        \"color\": \"#000000\",\r\n        \"lineStyle\": \"Continuous\",\r\n        \"weight\": 3\r\n      },\r\n      \"borderRight\": {\r\n        \"color\": \"#000000\",\r\n        \"lineStyle\": \"Continuous\",\r\n        \"weight\": 3\r\n      },\r\n      \"borderTop\": {\r\n        \"color\": \"#000000\",\r\n        \"lineStyle\": \"Continuous\",\r\n        \"weight\": 3\r\n      }\r\n    }\r\n  },\r\n  {\r\n    \"id\": \"excelTextFormat\",\r\n    \"dataType\": \"string\"\r\n  }\r\n]"