igGrid columns initialization is not the same as columns retrieved by "option", "columns"

Tomas Barton posted over 3 years ago
Hello, here is my grid initialization and my question and problem at the same time is about the columns.
Columns are defined with group columns and MultiColumnHeadres are used. as JSON bellow.
I will call igGrid("option", "columns") immediately after initialization and get different result of columns then I initialize in the beginning.
Used CDN igniteUI version 2019.2, and AngularJS 1.4.8
{
 "dataSchemaName": "data",
 "expandCollapseAnimations": true,
 "animationDuration": 1000,
 "width": "100%",
 "dataSource": [
 {
 "IdIncomeItem": 0,
 "IdPremise": 15,
 "PremiseName": "Lékárna Horálek",
 "DateStart": null,
 "CustomerCount": 1,
 "DocumentCount": 1,
 "IncomeSummaryIssueType": 0,
 "Margin": 31.46,
 "RawPriceTotal": 0,
 "SalePriceCustomerWithVatTotal": 25,
 "SalePriceInsurerWithVatTotal": 0,
 "SalePriceWithVatTotal": 25,
 "SalePriceWOVatTotal": 21.74,
 "SumCostPriceWithVatTotal": 17.14,
 "SumCostPriceWOVatTotal": 14.9,
 "TaxaLaborumTotal": 0,
 "PrescriptionCount": 1,
 "FreeSaleCount": 0,
 "StockStateCostPriceWOVat": null,
 "StockStateCostPriceWithVat": null,
 "ReceiptsCostPriceWOVat": null,
 "ReceiptsCostPriceWithVat": null,
 "AvgSalePriceWithVatPerCustomer": 25,
 "AvgSalePriceWOVatPerCustomer": 21.74,
 "DivideDateColumn": null,
 "PredefinedPeriodType": 1,
 "GrossProfit": 6.84,
 "SivCount": 0,
 "RowNumber": 0,
 "DiscountSalePriceWithVatTotal": 0,
 "NoDiscountSalePriceWOVatTotal": 0,
 "NoDiscountSumCostPriceWithVatTotal": null,
 "NoDiscountSumCostPriceWOVatTotal": null,
 "NoDiscountSalePriceWithVatTotal": 0,
 "DiscountSalePriceWOVatTotal": 0,
 "_groupByKey": [
 15,
 null,
 -1
 ],
 "TooltipName": "Lékárna Horálek",
 "TooltipValue": "31,46 %"
 },
 {
 "IdIncomeItem": 0,
 "IdPremise": 11,
 "PremiseName": "Lékárna Váňa",
 "DateStart": null,
 "CustomerCount": 7011,
 "DocumentCount": 9441,
 "IncomeSummaryIssueType": 0,
 "Margin": 22.113789,
 "RawPriceTotal": 42293.06,
 "SalePriceCustomerWithVatTotal": 1599468.39,
 "SalePriceInsurerWithVatTotal": 1675868.97,
 "SalePriceWithVatTotal": 3384224.06,
 "SalePriceWOVatTotal": 3032505.09,
 "SumCostPriceWithVatTotal": 2639153.57,
 "SumCostPriceWOVatTotal": 2361884.3,
 "TaxaLaborumTotal": 45473.86,
 "PrescriptionCount": 4718,
 "FreeSaleCount": 4698,
 "StockStateCostPriceWOVat": null,
 "StockStateCostPriceWithVat": null,
 "ReceiptsCostPriceWOVat": 953417.4428,
 "ReceiptsCostPriceWithVat": 1064982.9716,
 "AvgSalePriceWithVatPerCustomer": 482.70204820995579,
 "AvgSalePriceWOVatPerCustomer": 432.5353145057766,
 "DivideDateColumn": null,
 "PredefinedPeriodType": 1,
 "GrossProfit": 670620.79,
 "SivCount": 5152,
 "RowNumber": 1,
 "DiscountSalePriceWithVatTotal": 0,
 "NoDiscountSalePriceWOVatTotal": 0,
 "NoDiscountSumCostPriceWithVatTotal": null,
 "NoDiscountSumCostPriceWOVatTotal": null,
 "NoDiscountSalePriceWithVatTotal": 0,
 "DiscountSalePriceWOVatTotal": 0,
 "_groupByKey": [
 11,
 null,
 -1
 ],
 "TooltipName": "Lékárna Váňa",
 "TooltipValue": "22,11 %"
 }
 ],
 "autoCommit": true,
 "dataSourceType": "json",
 "renderCheckboxes": true,
 "virtualization": false,
 "virtualizationMode": "fixed",
 "autoGenerateLayouts": false,
 "autoGenerateColumns": false,
 "showReadonlyEditors": false,
 "columns": [
 {
 "key": "PremiseName",
 "headerText": "Provozovna",
 "dataType": "string",
 "summaries": false,
 "columnCssClass": "text-left",
 "unbound": false,
 "format": "string",
 "group": null,
 "template": null,
 "width": 166.25,
 "formatter": null,
 "visible": true,
 "level": 0,
 "level0": true,
 "hidden": false,
 "rowspan": 2,
 "allowResizing": true,
 "visibleIndex": 0,
 "settings": {
 "columnIndex": 0,
 "columnKey": "PremiseName",
 "allowResizing": true,
 "minimumWidth": 100,
 "handleThreshold": 10,
 "maximumWidth": 300
 },
 "formatted": true,
 "fixed": true
 },
 {
 "key": "multiColumn1",
 "headerText": "Celkem",
 "dataType": "string",
 "summaries": false,
 "columnCssClass": "text-left",
 "unbound": false,
 "format": "string",
 "group": [
 {
 "key": "SalePriceWOVatTotal",
 "headerText": "PC bez DPH",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": "60px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "allowHiding": true,
 "visibleIndex": 1,
 "settings": {
 "columnKey": "SalePriceWOVatTotal",
 "allowHiding": true,
 "hidden": false
 },
 "formatted": true
 },
 {
 "key": "SalePriceWithVatTotal",
 "headerText": "PC s DPH",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": "60px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "allowHiding": true,
 "visibleIndex": 2,
 "settings": {
 "columnKey": "SalePriceWithVatTotal",
 "allowHiding": true,
 "hidden": false
 },
 "formatted": true
 },
 {
 "key": "SumCostPriceWOVatTotal",
 "headerText": "NC bez DPH",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": "60px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "allowHiding": true,
 "visibleIndex": 3,
 "settings": {
 "columnKey": "SumCostPriceWOVatTotal",
 "allowHiding": true,
 "hidden": false
 },
 "formatted": true
 },
 {
 "key": "SumCostPriceWithVatTotal",
 "headerText": "NC s DPH",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": "60px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "allowHiding": true,
 "visibleIndex": 4,
 "settings": {
 "columnKey": "SumCostPriceWithVatTotal",
 "allowHiding": true,
 "hidden": false
 },
 "formatted": true
 }
 ],
 "template": null,
 "width": "240px",
 "formatter": null,
 "identifier": "multiColumn1",
 "colspan": 4,
 "children": [
 {
 "key": "SalePriceWOVatTotal",
 "headerText": "PC bez DPH",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": "60px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "allowHiding": true,
 "visibleIndex": 1,
 "settings": {
 "columnKey": "SalePriceWOVatTotal",
 "allowHiding": true,
 "hidden": false
 },
 "formatted": true
 },
 {
 "key": "SalePriceWithVatTotal",
 "headerText": "PC s DPH",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": "60px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "allowHiding": true,
 "visibleIndex": 2,
 "settings": {
 "columnKey": "SalePriceWithVatTotal",
 "allowHiding": true,
 "hidden": false
 },
 "formatted": true
 },
 {
 "key": "SumCostPriceWOVatTotal",
 "headerText": "NC bez DPH",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": "60px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "allowHiding": true,
 "visibleIndex": 3,
 "settings": {
 "columnKey": "SumCostPriceWOVatTotal",
 "allowHiding": true,
 "hidden": false
 },
 "formatted": true
 },
 {
 "key": "SumCostPriceWithVatTotal",
 "headerText": "NC s DPH",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": "60px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "allowHiding": true,
 "visibleIndex": 4,
 "settings": {
 "columnKey": "SumCostPriceWithVatTotal",
 "allowHiding": true,
 "hidden": false
 },
 "formatted": true
 }
 ],
 "level": 1,
 "allowResizing": false
 },
 {
 "key": "multiColumn2",
 "headerText": "Výdej bez slev celkem",
 "dataType": "string",
 "summaries": false,
 "columnCssClass": "text-left",
 "unbound": false,
 "format": "string",
 "group": [
 {
 "key": "NoDiscountSalePriceWOVatTotal",
 "headerText": "PC bez DPH",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": "60px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "formatted": true
 },
 {
 "key": "NoDiscountSalePriceWithVatTotal",
 "headerText": "PC s DPH",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": "60px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "formatted": true
 },
 {
 "key": "DiscountSalePriceWOVatTotal",
 "headerText": "Sleva bez DPH",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": "60px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "formatted": true
 },
 {
 "key": "DiscountSalePriceWithVatTotal",
 "headerText": "Sleva s DPH",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": "60px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "formatted": true
 }
 ],
 "template": null,
 "width": "240px",
 "formatter": null,
 "identifier": "multiColumn2",
 "colspan": 4,
 "children": [
 {
 "key": "NoDiscountSalePriceWOVatTotal",
 "headerText": "PC bez DPH",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": "60px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "formatted": true
 },
 {
 "key": "NoDiscountSalePriceWithVatTotal",
 "headerText": "PC s DPH",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": "60px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "formatted": true
 },
 {
 "key": "DiscountSalePriceWOVatTotal",
 "headerText": "Sleva bez DPH",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": "60px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "formatted": true
 },
 {
 "key": "DiscountSalePriceWithVatTotal",
 "headerText": "Sleva s DPH",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": "60px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "formatted": true
 }
 ],
 "level": 1,
 "allowResizing": false
 },
 {
 "key": "AvgSalePriceWOVatPerCustomer",
 "headerText": "Průměrná PC <br />bez DPH za zákazníka",
 "dataType": "number",
 "summaries": [
 "AVG"
 ],
 "columnCssClass": "text-right",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": "120px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "rowspan": 2,
 "formatted": true
 },
 {
 "key": "AvgSalePriceWithVatPerCustomer",
 "headerText": "Průměrná PC <br />s DPH za zákazníka",
 "dataType": "number",
 "summaries": [
 "AVG"
 ],
 "columnCssClass": "text-right",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": "120px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "rowspan": 2,
 "formatted": true
 },
 {
 "key": "multiColumn3",
 "headerText": "Počet",
 "dataType": "string",
 "summaries": false,
 "columnCssClass": "text-left",
 "unbound": false,
 "format": "string",
 "group": [
 {
 "key": "PrescriptionCount",
 "headerText": "Rp",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
 "unbound": false,
 "format": "int",
 "group": null,
 "template": null,
 "width": "50px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "formatted": true
 },
 {
 "key": "FreeSaleCount",
 "headerText": "VP",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
 "unbound": false,
 "format": "int",
 "group": null,
 "template": null,
 "width": "50px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "formatted": true
 },
 {
 "key": "CustomerCount",
 "headerText": "Zákazníci",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
 "unbound": false,
 "format": "int",
 "group": null,
 "template": null,
 "width": "50px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "formatted": true
 },
 {
 "key": "SivCount",
 "headerText": "Siv",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
 "unbound": false,
 "format": "int",
 "group": null,
 "template": null,
 "width": "50px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "formatted": true
 }
 ],
 "template": null,
 "width": "200px",
 "formatter": null,
 "identifier": "multiColumn3",
 "colspan": 4,
 "children": [
 {
 "key": "PrescriptionCount",
 "headerText": "Rp",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
 "unbound": false,
 "format": "int",
 "group": null,
 "template": null,
 "width": "50px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "formatted": true
 },
 {
 "key": "FreeSaleCount",
 "headerText": "VP",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
 "unbound": false,
 "format": "int",
 "group": null,
 "template": null,
 "width": "50px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "formatted": true
 },
 {
 "key": "CustomerCount",
 "headerText": "Zákazníci",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
 "unbound": false,
 "format": "int",
 "group": null,
 "template": null,
 "width": "50px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "formatted": true
 },
 {
 "key": "SivCount",
 "headerText": "Siv",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
 "unbound": false,
 "format": "int",
 "group": null,
 "template": null,
 "width": "50px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "allowResizing": false,
 "rowspan": 1,
 "formatted": true
 }
 ],
 "level": 1,
 "allowResizing": false
 },
 {
 "key": "GrossProfit",
 "headerText": "Hrubý zisk",
 "dataType": "number",
 "summaries": [
 "SUM"
 ],
 "columnCssClass": "text-right",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": "120px",
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "rowspan": 2,
 "formatted": true
 },
 {
 "key": "Margin",
 "headerText": "Marže",
 "dataType": "number",
 "summaries": false,
 "columnCssClass": "text-right",
 "unbound": false,
 "format": "0.00",
 "group": null,
 "template": null,
 "width": 393,
 "formatter": null,
 "level": 0,
 "level0": true,
 "hidden": false,
 "rowspan": 2,
 "formatted": true,
 "oWidth": "70px",
 "difference": 378
 },
 {
 "key": "RowNumber",
 "headerText": "Id",
 "dataType": "string",
 "summaries": false,
 "columnCssClass": "text-left",
 "unbound": false,
 "format": "string",
 "group": null,
 "template": null,
 "width": "378px",
 "formatter": null,
 "primary": true,
 "level": 0,
 "level0": true,
 "hidden": true,
 "oWidth": "20px",
 "difference": 358,
 "rowspan": 2,
 "_initiallyHidden": true,
 "_shouldAutoSize": true
 }
 ],
 "initialDataBindDepth": -1,
 "language": "cs",
 "showHeaders": true,
 "fixedHeaders": true,
 "featureChooserIconDisplay": "always",
 "features": [
 {
 "name": "Updating",
 "enableAddRow": false,
 "enableDeleteRow": false,
 "editMode": "none",
 "language": "cs"
 },
 {
 "name": "Sorting",
 "type": "local",
 "persist": false,
 "language": "cs"
 },
 {
 "name": "Summaries",
 "type": "local",
 "calculateRenderMode": "onselect",
 "compactRenderingMode": true,
 "showSummariesButton": false,
 "showDropDownButton": false,
 "columnSettings": [
 {
 "columnKey": "PremiseName",
 "allowSummaries": false
 },
 {
 "columnKey": "multiColumn1",
 "allowSummaries": false
 },
 {
 "columnKey": "multiColumn2",
 "allowSummaries": false
 },
 {
 "columnKey": "AvgSalePriceWOVatPerCustomer",
 "allowSummaries": true,
 "summaryOperands": [
 {
 "type": "AVG",
 "rowDisplayLabel": "&#248;",
 "style": "text-align: right"
 }
 ]
 },
 {
 "columnKey": "AvgSalePriceWithVatPerCustomer",
 "allowSummaries": true,
 "summaryOperands": [
 {
 "type": "AVG",
 "rowDisplayLabel": "&#248;",
 "style": "text-align: right"
 }
 ]
 },
 {
 "columnKey": "multiColumn3",
 "allowSummaries": false
 },
 {
 "columnKey": "GrossProfit",
 "allowSummaries": true,
 "summaryOperands": [
 {
 "type": "SUM",
 "rowDisplayLabel": "&#8721;",
 "style": "text-align: right"
 }
 ]
 },
 {
 "columnKey": "Margin",
 "allowSummaries": false
 },
 {
 "columnKey": "RowNumber",
 "allowSummaries": false
 },
 {
 "columnKey": "SalePriceWOVatTotal",
 "allowSummaries": true,
 "summaryOperands": [
 {
 "type": "SUM",
 "rowDisplayLabel": "&#8721;",
 "style": "text-align: right"
 }
 ]
 },
 {
 "columnKey": "SalePriceWithVatTotal",
 "allowSummaries": true,
 "summaryOperands": [
 {
 "type": "SUM",
 "rowDisplayLabel": "&#8721;",
 "style": "text-align: right"
 }
 ]
 },
 {
 "columnKey": "SumCostPriceWOVatTotal",
 "allowSummaries": true,
 "summaryOperands": [
 {
 "type": "SUM",
 "rowDisplayLabel": "&#8721;",
 "style": "text-align: right"
 }
 ]
 },
 {
 "columnKey": "SumCostPriceWithVatTotal",
 "allowSummaries": true,
 "summaryOperands": [
 {
 "type": "SUM",
 "rowDisplayLabel": "&#8721;",
 "style": "text-align: right"
 }
 ]
 },
 {
 "columnKey": "NoDiscountSalePriceWOVatTotal",
 "allowSummaries": true,
 "summaryOperands": [
 {
 "type": "SUM",
 "rowDisplayLabel": "&#8721;",
 "style": "text-align: right"
 }
 ]
 },
 {
 "columnKey": "NoDiscountSalePriceWithVatTotal",
 "allowSummaries": true,
 "summaryOperands": [
 {
 "type": "SUM",
 "rowDisplayLabel": "&#8721;",
 "style": "text-align: right"
 }
 ]
 },
 {
 "columnKey": "DiscountSalePriceWOVatTotal",
 "allowSummaries": true,
 "summaryOperands": [
 {
 "type": "SUM",
 "rowDisplayLabel": "&#8721;",
 "style": "text-align: right"
 }
 ]
 },
 {
 "columnKey": "DiscountSalePriceWithVatTotal",
 "allowSummaries": true,
 "summaryOperands": [
 {
 "type": "SUM",
 "rowDisplayLabel": "&#8721;",
 "style": "text-align: right"
 }
 ]
 },
 {
 "columnKey": "PrescriptionCount",
 "allowSummaries": true,
 "summaryOperands": [
 {
 "type": "SUM",
 "rowDisplayLabel": "&#8721;",
 "style": "text-align: right"
 }
 ]
 },
 {
 "columnKey": "FreeSaleCount",
 "allowSummaries": true,
 "summaryOperands": [
 {
 "type": "SUM",
 "rowDisplayLabel": "&#8721;",
 "style": "text-align: right"
 }
 ]
 },
 {
 "columnKey": "CustomerCount",
 "allowSummaries": true,
 "summaryOperands": [
 {
 "type": "SUM",
 "rowDisplayLabel": "&#8721;",
 "style": "text-align: right"
 }
 ]
 },
 {
 "columnKey": "SivCount",
 "allowSummaries": true,
 "summaryOperands": [
 {
 "type": "SUM",
 "rowDisplayLabel": "&#8721;",
 "style": "text-align: right"
 }
 ]
 }
 ],
 "language": "cs"
 },
 {
 "name": "Filtering",
 "type": "local",
 "persist": false,
 "filterSummaryAlwaysVisible": false,
 "filterDropDownAnimations": "none",
 "language": "cs"
 },
 {
 "name": "Hiding",
 "columnSettings": [
 {
 "columnKey": "PremiseName",
 "allowHiding": false,
 "hidden": false
 },
 {
 "columnKey": "DateStart",
 "allowHiding": false,
 "hidden": false
 },
 {
 "columnKey": "SalePriceWOVatTotal",
 "allowHiding": true,
 "hidden": false
 },
 {
 "columnKey": "SalePriceWithVatTotal",
 "allowHiding": true,
 "hidden": false
 },
 {
 "columnKey": "SumCostPriceWOVatTotal",
 "allowHiding": true,
 "hidden": false
 },
 {
 "columnKey": "SumCostPriceWithVatTotal",
 "allowHiding": true,
 "hidden": false
 },
 {
 "columnKey": "multiColumn1",
 "allowHiding": true,
 "hidden": false
 },
 {
 "columnKey": "NoDiscountSalePriceWOVatTotal",
 "allowHiding": false,
 "hidden": false
 },
 {
 "columnKey": "NoDiscountSalePriceWithVatTotal",
 "allowHiding": false,
 "hidden": false
 },
 {
 "columnKey": "DiscountSalePriceWOVatTotal",
 "allowHiding": false,
 "hidden": false
 },
 {
 "columnKey": "DiscountSalePriceWithVatTotal",
 "allowHiding": false,
 "hidden": false
 },
 {
 "columnKey": "multiColumn2",
 "allowHiding": false,
 "hidden": false
 },
 {
 "columnKey": "AvgSalePriceWOVatPerCustomer",
 "allowHiding": false,
 "hidden": false
 },
 {
 "columnKey": "AvgSalePriceWithVatPerCustomer",
 "allowHiding": false,
 "hidden": false
 },
 {
 "columnKey": "PrescriptionCount",
 "allowHiding": false,
 "hidden": false
 },
 {
 "columnKey": "FreeSaleCount",
 "allowHiding": false,
 "hidden": false
 },
 {
 "columnKey": "CustomerCount",
 "allowHiding": false,
 "hidden": false
 },
 {
 "columnKey": "SivCount",
 "allowHiding": false,
 "hidden": false
 },
 {
 "columnKey": "multiColumn3",
 "allowHiding": false,
 "hidden": false
 },
 {
 "columnKey": "GrossProfit",
 "allowHiding": false,
 "hidden": false
 },
 {
 "columnKey": "Margin",
 "allowHiding": false,
 "hidden": false
 },
 {
 "columnKey": "ReceiptsCostPriceWOVat",
 "allowHiding": false,
 "hidden": false
 },
 {
 "columnKey": "ReceiptsCostPriceWithVat",
 "allowHiding": false,
 "hidden": false
 },
 {
 "columnKey": "multiColumn4",
 "allowHiding": false,
 "hidden": false
 },
 {
 "columnKey": "RowNumber",
 "allowHiding": false,
 "hidden": true
 }
 ],
 "language": "cs"
 },
 {
 "name": "ColumnMoving",
 "columnSettings": [
 {
 "columnKey": "PremiseName",
 "allowMoving": false
 },
 {
 "columnKey": "DateStart",
 "allowMoving": false
 },
 {
 "columnKey": "SalePriceWOVatTotal",
 "allowMoving": false
 },
 {
 "columnKey": "SalePriceWithVatTotal",
 "allowMoving": false
 },
 {
 "columnKey": "SumCostPriceWOVatTotal",
 "allowMoving": false
 },
 {
 "columnKey": "SumCostPriceWithVatTotal",
 "allowMoving": false
 },
 {
 "columnKey": "multiColumn1",
 "allowMoving": false
 },
 {
 "columnKey": "NoDiscountSalePriceWOVatTotal",
 "allowMoving": false
 },
 {
 "columnKey": "NoDiscountSalePriceWithVatTotal",
 "allowMoving": false
 },
 {
 "columnKey": "DiscountSalePriceWOVatTotal",
 "allowMoving": false
 },
 {
 "columnKey": "DiscountSalePriceWithVatTotal",
 "allowMoving": false
 },
 {
 "columnKey": "multiColumn2",
 "allowMoving": false
 },
 {
 "columnKey": "AvgSalePriceWOVatPerCustomer",
 "allowMoving": false
 },
 {
 "columnKey": "AvgSalePriceWithVatPerCustomer",
 "allowMoving": false
 },
 {
 "columnKey": "PrescriptionCount",
 "allowMoving": false
 },
 {
 "columnKey": "FreeSaleCount",
 "allowMoving": false
 },
 {
 "columnKey": "CustomerCount",
 "allowMoving": false
 },
 {
 "columnKey": "SivCount",
 "allowMoving": false
 },
 {
 "columnKey": "multiColumn3",
 "allowMoving": false
 },
 {
 "columnKey": "GrossProfit",
 "allowMoving": false
 },
 {
 "columnKey": "Margin",
 "allowMoving": true
 },
 {
 "columnKey": "ReceiptsCostPriceWOVat",
 "allowMoving": false
 },
 {
 "columnKey": "ReceiptsCostPriceWithVat",
 "allowMoving": false
 },
 {
 "columnKey": "multiColumn4",
 "allowMoving": false
 },
 {
 "columnKey": "RowNumber",
 "allowMoving": false
 }
 ],
 "language": "cs"
 },
 {
 "name": "MultiColumnHeaders",
 "columnSettings": [],
 "language": "cs"
 },
 {
 "name": "Resizing",
 "columnSettings": [
 {
 "columnKey": "PremiseName",
 "allowResizing": true,
 "handleThreshold": 10,
 "minimumWidth": 100,
 "maximumWidth": 300
 },
 {
 "columnKey": "DateStart",
 "allowResizing": false
 },
 {
 "columnKey": "multiColumn1",
 "allowResizing": false
 },
 {
 "columnKey": "multiColumn2",
 "allowResizing": false
 },
 {
 "columnKey": "AvgSalePriceWOVatPerCustomer",
 "allowResizing": false
 },
 {
 "columnKey": "AvgSalePriceWithVatPerCustomer",
 "allowResizing": false
 },
 {
 "columnKey": "multiColumn3",
 "allowResizing": false
 },
 {
 "columnKey": "GrossProfit",
 "allowResizing": false
 },
 {
 "columnKey": "Margin",
 "allowResizing": false
 },
 {
 "columnKey": "multiColumn4",
 "allowResizing": false
 },
 {
 "columnKey": "RowNumber",
 "allowResizing": false
 }
 ],
 "language": "cs"
 },
 {
 "name": "ColumnFixing",
 "fixingDirection": "left",
 "showFixButtons": true,
 "columnSettings": [
 {
 "columnKey": "PremiseName",
 "isFixed": true,
 "allowFixing": true
 },
 {
 "columnKey": "DateStart",
 "isFixed": false,
 "allowFixing": false
 },
 {
 "columnKey": "multiColumn1",
 "isFixed": false,
 "allowFixing": false
 },
 {
 "columnKey": "multiColumn2",
 "isFixed": false,
 "allowFixing": false
 },
 {
 "columnKey": "AvgSalePriceWOVatPerCustomer",
 "isFixed": false,
 "allowFixing": false
 },
 {
 "columnKey": "AvgSalePriceWithVatPerCustomer",
 "isFixed": false,
 "allowFixing": false
 },
 {
 "columnKey": "multiColumn3",
 "isFixed": false,
 "allowFixing": false
 },
 {
 "columnKey": "GrossProfit",
 "isFixed": false,
 "allowFixing": false
 },
 {
 "columnKey": "Margin",
 "isFixed": false,
 "allowFixing": false
 },
 {
 "columnKey": "multiColumn4",
 "isFixed": false,
 "allowFixing": false
 },
 {
 "columnKey": "RowNumber",
 "isFixed": false,
 "allowFixing": false
 }
 ],
 "language": "cs"
 },
 {
 "name": "RowSelectors",
 "enableCheckBoxes": false,
 "enableRowNumbering": false,
 "language": "cs"
 },
 {
 "name": "Selection",
 "mode": "row",
 "multipleSelection": false,
 "language": "cs",
 "inherit": true
 }
 ],
 "primaryKey": "RowNumber"
}


Separated column definition used when initialize grid.
"columns": [
		{
			"key": "PremiseName",
			"headerText": "Provozovna",
			"dataType": "string",
			"summaries": false,
			"columnCssClass": "text-left",
			"unbound": false,
			"format": "string",
			"group": null,
			"template": null,
			"width": 166.25,
			"formatter": null,
			"visible": true,
			"level": 0,
			"level0": true,
			"hidden": false,
			"rowspan": 2,
			"allowResizing": true,
			"visibleIndex": 0,
			"settings": {
				"columnIndex": 0,
				"columnKey": "PremiseName",
				"allowResizing": true,
				"minimumWidth": 100,
				"handleThreshold": 10,
				"maximumWidth": 300
			},
			"formatted": true,
			"fixed": true
		},
		{
			"key": "multiColumn1",
			"headerText": "Celkem",
			"dataType": "string",
			"summaries": false,
			"columnCssClass": "text-left",
			"unbound": false,
			"format": "string",
			"group": [
				{
					"key": "SalePriceWOVatTotal",
					"headerText": "PC bez DPH",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
					"unbound": false,
					"format": "0.00",
					"group": null,
					"template": null,
					"width": "60px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"allowHiding": true,
					"visibleIndex": 1,
					"settings": {
						"columnKey": "SalePriceWOVatTotal",
						"allowHiding": true,
						"hidden": false
					},
					"formatted": true
				},
				{
					"key": "SalePriceWithVatTotal",
					"headerText": "PC s DPH",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
					"unbound": false,
					"format": "0.00",
					"group": null,
					"template": null,
					"width": "60px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"allowHiding": true,
					"visibleIndex": 2,
					"settings": {
						"columnKey": "SalePriceWithVatTotal",
						"allowHiding": true,
						"hidden": false
					},
					"formatted": true
				},
				{
					"key": "SumCostPriceWOVatTotal",
					"headerText": "NC bez DPH",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
					"unbound": false,
					"format": "0.00",
					"group": null,
					"template": null,
					"width": "60px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"allowHiding": true,
					"visibleIndex": 3,
					"settings": {
						"columnKey": "SumCostPriceWOVatTotal",
						"allowHiding": true,
						"hidden": false
					},
					"formatted": true
				},
				{
					"key": "SumCostPriceWithVatTotal",
					"headerText": "NC s DPH",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
					"unbound": false,
					"format": "0.00",
					"group": null,
					"template": null,
					"width": "60px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"allowHiding": true,
					"visibleIndex": 4,
					"settings": {
						"columnKey": "SumCostPriceWithVatTotal",
						"allowHiding": true,
						"hidden": false
					},
					"formatted": true
				}
			],
			"template": null,
			"width": "240px",
			"formatter": null,
			"identifier": "multiColumn1",
			"colspan": 4,
			"children": [
				{
					"key": "SalePriceWOVatTotal",
					"headerText": "PC bez DPH",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
					"unbound": false,
					"format": "0.00",
					"group": null,
					"template": null,
					"width": "60px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"allowHiding": true,
					"visibleIndex": 1,
					"settings": {
						"columnKey": "SalePriceWOVatTotal",
						"allowHiding": true,
						"hidden": false
					},
					"formatted": true
				},
				{
					"key": "SalePriceWithVatTotal",
					"headerText": "PC s DPH",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
					"unbound": false,
					"format": "0.00",
					"group": null,
					"template": null,
					"width": "60px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"allowHiding": true,
					"visibleIndex": 2,
					"settings": {
						"columnKey": "SalePriceWithVatTotal",
						"allowHiding": true,
						"hidden": false
					},
					"formatted": true
				},
				{
					"key": "SumCostPriceWOVatTotal",
					"headerText": "NC bez DPH",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
					"unbound": false,
					"format": "0.00",
					"group": null,
					"template": null,
					"width": "60px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"allowHiding": true,
					"visibleIndex": 3,
					"settings": {
						"columnKey": "SumCostPriceWOVatTotal",
						"allowHiding": true,
						"hidden": false
					},
					"formatted": true
				},
				{
					"key": "SumCostPriceWithVatTotal",
					"headerText": "NC s DPH",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
					"unbound": false,
					"format": "0.00",
					"group": null,
					"template": null,
					"width": "60px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"allowHiding": true,
					"visibleIndex": 4,
					"settings": {
						"columnKey": "SumCostPriceWithVatTotal",
						"allowHiding": true,
						"hidden": false
					},
					"formatted": true
				}
			],
			"level": 1,
			"allowResizing": false
		},
		{
			"key": "multiColumn2",
			"headerText": "Výdej bez slev celkem",
			"dataType": "string",
			"summaries": false,
			"columnCssClass": "text-left",
			"unbound": false,
			"format": "string",
			"group": [
				{
					"key": "NoDiscountSalePriceWOVatTotal",
					"headerText": "PC bez DPH",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
					"unbound": false,
					"format": "0.00",
					"group": null,
					"template": null,
					"width": "60px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"formatted": true
				},
				{
					"key": "NoDiscountSalePriceWithVatTotal",
					"headerText": "PC s DPH",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
					"unbound": false,
					"format": "0.00",
					"group": null,
					"template": null,
					"width": "60px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"formatted": true
				},
				{
					"key": "DiscountSalePriceWOVatTotal",
					"headerText": "Sleva bez DPH",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
					"unbound": false,
					"format": "0.00",
					"group": null,
					"template": null,
					"width": "60px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"formatted": true
				},
				{
					"key": "DiscountSalePriceWithVatTotal",
					"headerText": "Sleva s DPH",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
					"unbound": false,
					"format": "0.00",
					"group": null,
					"template": null,
					"width": "60px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"formatted": true
				}
			],
			"template": null,
			"width": "240px",
			"formatter": null,
			"identifier": "multiColumn2",
			"colspan": 4,
			"children": [
				{
					"key": "NoDiscountSalePriceWOVatTotal",
					"headerText": "PC bez DPH",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
					"unbound": false,
					"format": "0.00",
					"group": null,
					"template": null,
					"width": "60px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"formatted": true
				},
				{
					"key": "NoDiscountSalePriceWithVatTotal",
					"headerText": "PC s DPH",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
					"unbound": false,
					"format": "0.00",
					"group": null,
					"template": null,
					"width": "60px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"formatted": true
				},
				{
					"key": "DiscountSalePriceWOVatTotal",
					"headerText": "Sleva bez DPH",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
					"unbound": false,
					"format": "0.00",
					"group": null,
					"template": null,
					"width": "60px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"formatted": true
				},
				{
					"key": "DiscountSalePriceWithVatTotal",
					"headerText": "Sleva s DPH",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
					"unbound": false,
					"format": "0.00",
					"group": null,
					"template": null,
					"width": "60px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"formatted": true
				}
			],
			"level": 1,
			"allowResizing": false
		},
		{
			"key": "AvgSalePriceWOVatPerCustomer",
			"headerText": "Průměrná PC <br />bez DPH za zákazníka",
			"dataType": "number",
			"summaries": [
				"AVG"
			],
			"columnCssClass": "text-right",
			"unbound": false,
			"format": "0.00",
			"group": null,
			"template": null,
			"width": "120px",
			"formatter": null,
			"level": 0,
			"level0": true,
			"hidden": false,
			"rowspan": 2,
			"formatted": true
		},
		{
			"key": "AvgSalePriceWithVatPerCustomer",
			"headerText": "Průměrná PC <br />s DPH za zákazníka",
			"dataType": "number",
			"summaries": [
				"AVG"
			],
			"columnCssClass": "text-right",
			"unbound": false,
			"format": "0.00",
			"group": null,
			"template": null,
			"width": "120px",
			"formatter": null,
			"level": 0,
			"level0": true,
			"hidden": false,
			"rowspan": 2,
			"formatted": true
		},
		{
			"key": "multiColumn3",
			"headerText": "Počet",
			"dataType": "string",
			"summaries": false,
			"columnCssClass": "text-left",
			"unbound": false,
			"format": "string",
			"group": [
				{
					"key": "PrescriptionCount",
					"headerText": "Rp",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
					"unbound": false,
					"format": "int",
					"group": null,
					"template": null,
					"width": "50px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"formatted": true
				},
				{
					"key": "FreeSaleCount",
					"headerText": "VP",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
					"unbound": false,
					"format": "int",
					"group": null,
					"template": null,
					"width": "50px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"formatted": true
				},
				{
					"key": "CustomerCount",
					"headerText": "Zákazníci",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
					"unbound": false,
					"format": "int",
					"group": null,
					"template": null,
					"width": "50px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"formatted": true
				},
				{
					"key": "SivCount",
					"headerText": "Siv",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
					"unbound": false,
					"format": "int",
					"group": null,
					"template": null,
					"width": "50px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"formatted": true
				}
			],
			"template": null,
			"width": "200px",
			"formatter": null,
			"identifier": "multiColumn3",
			"colspan": 4,
			"children": [
				{
					"key": "PrescriptionCount",
					"headerText": "Rp",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
					"unbound": false,
					"format": "int",
					"group": null,
					"template": null,
					"width": "50px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"formatted": true
				},
				{
					"key": "FreeSaleCount",
					"headerText": "VP",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
					"unbound": false,
					"format": "int",
					"group": null,
					"template": null,
					"width": "50px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"formatted": true
				},
				{
					"key": "CustomerCount",
					"headerText": "Zákazníci",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
					"unbound": false,
					"format": "int",
					"group": null,
					"template": null,
					"width": "50px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"formatted": true
				},
				{
					"key": "SivCount",
					"headerText": "Siv",
					"dataType": "number",
					"summaries": [
						"SUM"
					],
					"columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
					"unbound": false,
					"format": "int",
					"group": null,
					"template": null,
					"width": "50px",
					"formatter": null,
					"level": 0,
					"level0": true,
					"hidden": false,
					"allowResizing": false,
					"rowspan": 1,
					"formatted": true
				}
			],
			"level": 1,
			"allowResizing": false
		},
		{
			"key": "GrossProfit",
			"headerText": "Hrubý zisk",
			"dataType": "number",
			"summaries": [
				"SUM"
			],
			"columnCssClass": "text-right",
			"unbound": false,
			"format": "0.00",
			"group": null,
			"template": null,
			"width": "120px",
			"formatter": null,
			"level": 0,
			"level0": true,
			"hidden": false,
			"rowspan": 2,
			"formatted": true
		},
		{
			"key": "Margin",
			"headerText": "Marže",
			"dataType": "number",
			"summaries": false,
			"columnCssClass": "text-right",
			"unbound": false,
			"format": "0.00",
			"group": null,
			"template": null,
			"width": 393,
			"formatter": null,
			"level": 0,
			"level0": true,
			"hidden": false,
			"rowspan": 2,
			"formatted": true,
			"oWidth": "70px",
			"difference": 378
		},
		{
			"key": "RowNumber",
			"headerText": "Id",
			"dataType": "string",
			"summaries": false,
			"columnCssClass": "text-left",
			"unbound": false,
			"format": "string",
			"group": null,
			"template": null,
			"width": "378px",
			"formatter": null,
			"primary": true,
			"level": 0,
			"level0": true,
			"hidden": true,
			"oWidth": "20px",
			"difference": 358,
			"rowspan": 2,
			"_initiallyHidden": true,
			"_shouldAutoSize": true
		}
	],


The result after igGrid("option", "columns") has been called.

[
	{
		"key": "PremiseName",
		"headerText": "Provozovna",
		"dataType": "string",
		"summaries": false,
		"columnCssClass": "text-left",
		"unbound": false,
		"format": "string",
		"group": null,
		"template": null,
		"width": 166.25,
		"formatter": null,
		"visible": true,
		"level": 0,
		"level0": true,
		"hidden": false,
		"rowspan": 2,
		"allowResizing": true,
		"visibleIndex": 0,
		"settings": {
			"columnIndex": 0,
			"columnKey": "PremiseName",
			"allowResizing": true,
			"minimumWidth": 100,
			"handleThreshold": 10,
			"maximumWidth": 300
		},
		"formatted": true,
		"fixed": true
	},
	{
		"key": "SalePriceWOVatTotal",
		"headerText": "PC bez DPH",
		"dataType": "number",
		"summaries": [
			"SUM"
		],
		"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
		"unbound": false,
		"format": "0.00",
		"group": null,
		"template": null,
		"width": "60px",
		"formatter": null,
		"level": 0,
		"level0": true,
		"hidden": false,
		"allowResizing": false,
		"rowspan": 1,
		"allowHiding": true,
		"visibleIndex": 1,
		"settings": {
			"columnKey": "SalePriceWOVatTotal",
			"allowHiding": true,
			"hidden": false
		},
		"formatted": true
	},
	{
		"key": "SalePriceWithVatTotal",
		"headerText": "PC s DPH",
		"dataType": "number",
		"summaries": [
			"SUM"
		],
		"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
		"unbound": false,
		"format": "0.00",
		"group": null,
		"template": null,
		"width": "60px",
		"formatter": null,
		"level": 0,
		"level0": true,
		"hidden": false,
		"allowResizing": false,
		"rowspan": 1,
		"allowHiding": true,
		"visibleIndex": 2,
		"settings": {
			"columnKey": "SalePriceWithVatTotal",
			"allowHiding": true,
			"hidden": false
		},
		"formatted": true
	},
	{
		"key": "SumCostPriceWOVatTotal",
		"headerText": "NC bez DPH",
		"dataType": "number",
		"summaries": [
			"SUM"
		],
		"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
		"unbound": false,
		"format": "0.00",
		"group": null,
		"template": null,
		"width": "60px",
		"formatter": null,
		"level": 0,
		"level0": true,
		"hidden": false,
		"allowResizing": false,
		"rowspan": 1,
		"allowHiding": true,
		"visibleIndex": 3,
		"settings": {
			"columnKey": "SumCostPriceWOVatTotal",
			"allowHiding": true,
			"hidden": false
		},
		"formatted": true
	},
	{
		"key": "SumCostPriceWithVatTotal",
		"headerText": "NC s DPH",
		"dataType": "number",
		"summaries": [
			"SUM"
		],
		"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
		"unbound": false,
		"format": "0.00",
		"group": null,
		"template": null,
		"width": "60px",
		"formatter": null,
		"level": 0,
		"level0": true,
		"hidden": false,
		"allowResizing": false,
		"rowspan": 1,
		"allowHiding": true,
		"visibleIndex": 4,
		"settings": {
			"columnKey": "SumCostPriceWithVatTotal",
			"allowHiding": true,
			"hidden": false
		},
		"formatted": true
	},
	{
		"key": "NoDiscountSalePriceWOVatTotal",
		"headerText": "PC bez DPH",
		"dataType": "number",
		"summaries": [
			"SUM"
		],
		"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
		"unbound": false,
		"format": "0.00",
		"group": null,
		"template": null,
		"width": "60px",
		"formatter": null,
		"level": 0,
		"level0": true,
		"hidden": false,
		"allowResizing": false,
		"rowspan": 1,
		"formatted": true
	},
	{
		"key": "NoDiscountSalePriceWithVatTotal",
		"headerText": "PC s DPH",
		"dataType": "number",
		"summaries": [
			"SUM"
		],
		"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
		"unbound": false,
		"format": "0.00",
		"group": null,
		"template": null,
		"width": "60px",
		"formatter": null,
		"level": 0,
		"level0": true,
		"hidden": false,
		"allowResizing": false,
		"rowspan": 1,
		"formatted": true
	},
	{
		"key": "DiscountSalePriceWOVatTotal",
		"headerText": "Sleva bez DPH",
		"dataType": "number",
		"summaries": [
			"SUM"
		],
		"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
		"unbound": false,
		"format": "0.00",
		"group": null,
		"template": null,
		"width": "60px",
		"formatter": null,
		"level": 0,
		"level0": true,
		"hidden": false,
		"allowResizing": false,
		"rowspan": 1,
		"formatted": true
	},
	{
		"key": "DiscountSalePriceWithVatTotal",
		"headerText": "Sleva s DPH",
		"dataType": "number",
		"summaries": [
			"SUM"
		],
		"columnCssClass": "text-right min-width-price-undefined max-width-price-undefined",
		"unbound": false,
		"format": "0.00",
		"group": null,
		"template": null,
		"width": "60px",
		"formatter": null,
		"level": 0,
		"level0": true,
		"hidden": false,
		"allowResizing": false,
		"rowspan": 1,
		"formatted": true
	},
	{
		"key": "AvgSalePriceWOVatPerCustomer",
		"headerText": "Průměrná PC <br />bez DPH za zákazníka",
		"dataType": "number",
		"summaries": [
			"AVG"
		],
		"columnCssClass": "text-right",
		"unbound": false,
		"format": "0.00",
		"group": null,
		"template": null,
		"width": "120px",
		"formatter": null,
		"level": 0,
		"level0": true,
		"hidden": false,
		"rowspan": 2,
		"formatted": true
	},
	{
		"key": "AvgSalePriceWithVatPerCustomer",
		"headerText": "Průměrná PC <br />s DPH za zákazníka",
		"dataType": "number",
		"summaries": [
			"AVG"
		],
		"columnCssClass": "text-right",
		"unbound": false,
		"format": "0.00",
		"group": null,
		"template": null,
		"width": "120px",
		"formatter": null,
		"level": 0,
		"level0": true,
		"hidden": false,
		"rowspan": 2,
		"formatted": true
	},
	{
		"key": "PrescriptionCount",
		"headerText": "Rp",
		"dataType": "number",
		"summaries": [
			"SUM"
		],
		"columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
		"unbound": false,
		"format": "int",
		"group": null,
		"template": null,
		"width": "50px",
		"formatter": null,
		"level": 0,
		"level0": true,
		"hidden": false,
		"allowResizing": false,
		"rowspan": 1,
		"formatted": true
	},
	{
		"key": "FreeSaleCount",
		"headerText": "VP",
		"dataType": "number",
		"summaries": [
			"SUM"
		],
		"columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
		"unbound": false,
		"format": "int",
		"group": null,
		"template": null,
		"width": "50px",
		"formatter": null,
		"level": 0,
		"level0": true,
		"hidden": false,
		"allowResizing": false,
		"rowspan": 1,
		"formatted": true
	},
	{
		"key": "CustomerCount",
		"headerText": "Zákazníci",
		"dataType": "number",
		"summaries": [
			"SUM"
		],
		"columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
		"unbound": false,
		"format": "int",
		"group": null,
		"template": null,
		"width": "50px",
		"formatter": null,
		"level": 0,
		"level0": true,
		"hidden": false,
		"allowResizing": false,
		"rowspan": 1,
		"formatted": true
	},
	{
		"key": "SivCount",
		"headerText": "Siv",
		"dataType": "number",
		"summaries": [
			"SUM"
		],
		"columnCssClass": "text-right min-width-count-undefined max-width-count-undefined",
		"unbound": false,
		"format": "int",
		"group": null,
		"template": null,
		"width": "50px",
		"formatter": null,
		"level": 0,
		"level0": true,
		"hidden": false,
		"allowResizing": false,
		"rowspan": 1,
		"formatted": true
	},
	{
		"key": "GrossProfit",
		"headerText": "Hrubý zisk",
		"dataType": "number",
		"summaries": [
			"SUM"
		],
		"columnCssClass": "text-right",
		"unbound": false,
		"format": "0.00",
		"group": null,
		"template": null,
		"width": "120px",
		"formatter": null,
		"level": 0,
		"level0": true,
		"hidden": false,
		"rowspan": 2,
		"formatted": true
	},
	{
		"key": "Margin",
		"headerText": "Marže",
		"dataType": "number",
		"summaries": false,
		"columnCssClass": "text-right",
		"unbound": false,
		"format": "0.00",
		"group": null,
		"template": null,
		"width": 393,
		"formatter": null,
		"level": 0,
		"level0": true,
		"hidden": false,
		"rowspan": 2,
		"formatted": true,
		"oWidth": "70px",
		"difference": 378
	},
	{
		"key": "RowNumber",
		"headerText": "Id",
		"dataType": "string",
		"summaries": false,
		"columnCssClass": "text-left",
		"unbound": false,
		"format": "string",
		"group": null,
		"template": null,
		"width": "378px",
		"formatter": null,
		"primary": true,
		"level": 0,
		"level0": true,
		"hidden": true,
		"oWidth": "20px",
		"difference": 358,
		"rowspan": 2,
		"_initiallyHidden": true,
		"_shouldAutoSize": true
	}
]


This is totaly different column settings. There is no grouping columns and all columns are at the same level.
Top Replies

1080

Offline Martin Asenov posted over 3 years ago +1 verified
Hello, When using multicolumn headers, the columns option will return the flattened version of the collection. My suggestion is to use the getMultiColumnHeaders...view reply »
Parents
1080

Verified Answer
Offline Martin Asenov posted over 3 years ago

Hello,

When using multicolumn headers, the columns option will return the flattened version of the collection. My suggestion is to use the getMultiColumnHeaders method instead.

Please let me know if you need any further assistance with this matter.
Cancel
Reply

Reject Answer

Cancel
Reply
35

Offline Tomas Barton posted over 3 years ago in reply to Martin Asenov

Thanks,

works as expected.
Cancel
Reply

Cancel
Children
1080

Offline Martin Asenov posted over 3 years ago in reply to Tomas Barton

Hi,

I am glad that you have resolved your issue.

Thank you for using Infragistics components.
Cancel
Reply

Cancel