Ordering of Advanced Settings Corrupt HOT on Expand and Collapse

Issue #886 open
Ryan Clapp created an issue

When using the same settings but in a different order results in expand and collapse HOT corruption.

Working:

{
    "table": {
      "viewportColumnRenderingOffset": 100,
      "fixedRowHeaders": {
        "numberOfColumns": "2"
      },
      "exportExcel": {
        "exportDBRWFormulaAsText": false,
        "exportActiveForm": true,
        "exportToExcelAsSlice": true
      },
      "allowTraceRule": true,
      "elementSelection": {
        "disableElementSelection": true
      },
      "ibcsHeaders": true,
      "rowFormat": {
        "GMS*All Channels": [
          {
            "className": "bg-black"
          }
        ],
        "Units Served*All Channels": [
          {
            "className": "bg-black"
          }
        ],
        "Revenue*All Channels": [
          {
            "className": "bg-black"
          }
        ],
        "Net Revenue Ex Ads*All Channels": [
          {
            "className": "bg-black"
          }
        ],
        "Operating Income": [
          {
            "className": "bg-black"
          }
        ],
        "Operating Income Ex - Ads*All Channels": [
          {
            "className": "bg-black"
          }
        ],
        "": [
          {
            "attribute": "APQ Format"
          }
        ]
      },
      "colWidths": [
        331,
        156,
        75,
        80,
        80,
        80,
        80,
        80,
        80,
        20,
        80,
        80,
        80,
        80,
        80,
        20,
        80,
        80,
        80,
        80,
        80,
        80,
        22,
        80,
        80,
        80,
        80,
        80,
        48,
        80,
        80,
        80,
        80,
        80,
        20,
        80,
        80,
        80,
        80,
        80,
        80,
        20,
        80,
        80,
        80,
        80,
        80
      ],
      "columnFormat": {
        "": [
          {
            "attribute": "APQ Format"
          }
        ]
      },
      "insertedRowsAndColumns": {
        "columnDataIndex": 16,
        "rowDataIndex": 8,
        "columnData": [
          [],
          [],
          [],
          [],
          [],
          [],
          [],
          [],
          [],
          [],
          [],
          [],
          [],
          [],
          [],
          []
        ],
        "rowData": [
          [
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            ""
          ],
          [
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            ""
          ],
          [
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            ""
          ],
          [
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            ""
          ],
          [
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            ""
          ],
          [
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            ""
          ],
          [
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            ""
          ],
          [
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            ""
          ]
        ]
      },
      "columnsMap": [
        0,
        1,
        2,
        3,
        4,
        5,
        6,
        {
          "empty": true,
          "name": "",
          "groupNames": [
            "",
            ""
          ],
          "colData": 1,
          "numberFormat": "#,###;(#,###);0;-",
          "class": "noborder whiteBack",
          "priority": 10,
          "ibcsClass": "",
          "numberOfAdditionalRows": 0,
          "appliedNumberFormat": "#,###;(#,###);0;-"
        },
        7,
        8,
        9,
        10,
        11,
        {
          "empty": true,
          "name": "",
          "groupNames": [
            "",
            ""
          ],
          "colData": 9,
          "numberFormat": "#,###;(#,###);0;-",
          "class": "noborder whiteBack",
          "priority": 10,
          "ibcsClass": "",
          "numberOfAdditionalRows": 0,
          "appliedNumberFormat": "#,###;(#,###);0;-"
        },
        12,
        13,
        14,
        15,
        16,
        17,
        {
          "empty": true,
          "name": "",
          "groupNames": [
            "",
            ""
          ],
          "colData": 10,
          "numberFormat": "#,###;(#,###);0;-",
          "class": "noborder whiteBack",
          "priority": 10,
          "ibcsClass": "",
          "numberOfAdditionalRows": 0,
          "appliedNumberFormat": "#,###;(#,###);0;-"
        },
        18,
        19,
        20,
        21,
        22,
        {
          "empty": true,
          "name": "",
          "groupNames": [
            "",
            ""
          ],
          "colData": 11,
          "numberFormat": "#,###;(#,###);0;-",
          "class": "noborder whiteBack",
          "priority": 10,
          "ibcsClass": "",
          "numberOfAdditionalRows": 0,
          "appliedNumberFormat": "#,###;(#,###);0;-"
        },
        23,
        24,
        25,
        26,
        27,
        {
          "empty": true,
          "name": "",
          "groupNames": [],
          "colData": 14,
          "numberFormat": "#,###;(#,###);0;-",
          "class": "noborder whiteBack",
          "priority": 10,
          "ibcsClass": "",
          "numberOfAdditionalRows": 0,
          "appliedNumberFormat": "#,###;(#,###);0;-"
        },
        28,
        29,
        30,
        31,
        32,
        33,
        {
          "empty": true,
          "name": "",
          "groupNames": [],
          "colData": 15,
          "numberFormat": "#,###;(#,###);0;-",
          "class": "noborder whiteBack",
          "priority": 10,
          "ibcsClass": "",
          "numberOfAdditionalRows": 0,
          "appliedNumberFormat": "#,###;(#,###);0;-"
        },
        34,
        35,
        36,
        37,
        38
      ],
      "rowsMap": [
        0,
        1,
        2,
        3,
        4,
        5,
        6,
        7,
        8,
        9,
        10,
        11,
        12,
        13,
        14,
        15,
        16,
        17,
        18,
        19,
        20,
        21,
        22,
        23,
        24,
        25,
        26,
        27,
        28,
        29,
        30,
        31,
        32,
        33,
        34,
        35,
        36,
        37,
        38,
        39,
        40,
        41,
        42,
        43,
        44,
        45,
        46,
        47,
        48,
        49,
        50,
        51,
        52,
        53,
        54,
        55,
        56,
        57,
        58,
        59,
        60,
        61,
        62,
        63,
        64,
        65,
        66,
        67,
        68
      ]
    },
    "wizard": {
      "hideBackButton": true,
      "hideNextButton": true
    },
    "toolbar": {
      "collapseButtonEnabled": true,
      "searchEnabled": true,
      "rowFiltersEnabled": true,
      "columnButtonEnabled": true,
      "columnFiltersEnabled": true,
      "modalButtonsEnabled": true,
      "processButtonEnabled": true,
      "refreshButtonEnabled": true,
      "batchPrintButtonEnabled": true,
      "exportButtonEnabled": true,
      "exportPDFButtonEnabled": false,
      "exportExcelWithFiltersButtonEnabled": true,
      "exportAsDBRWSliceButtonEnabled": true,
      "exportAsDBRWActiveFormButtonEnabled": false,
      "exportExcelButtonEnabled": true,
      "exportExcelPlainButtonEnabled": true,
      "exportPDFServlet": "print-v2.pdf",
      "columnFilterButtonEnabled": true,
      "sandboxEnabled": false,
      "exportPDFA3ButtonEnabled": false,
      "realTimeButtonEnabled": true,
      "realTimeEnabled": true,
      "excelHeadersButtonEnabled": true,
      "exportCustomButtonEnabled": true,
      "exportPrintButtonEnabled": false,
      "exportExcelAllTablesWithFiltersButtonEnabled": true,
      "exportPDFDefaultOptions": [
        "A4",
        "PORTRAIT",
        "pdf"
      ],
      "customExportOptions": {
        "pageSize": [
          "LETTER",
          "LEGAL",
          "TABLOID",
          "A0",
          "A1",
          "A2",
          "A3",
          "A4",
          "A5"
        ],
        "pageOrientation": [
          "LANDSCAPE",
          "PORTRAIT"
        ],
        "pageOutputTypes": [
          "pdf",
          "jpeg",
          "png"
        ]
      }
    }
  }

Broken:

{
  "table": {
    "viewportColumnRenderingOffset": 100,
    "rowFormat": {
      "GMS*All Channels": [
        {
          "className": "bg-black"
        }
      ],
      "Units Served*All Channels": [
        {
          "className": "bg-black"
        }
      ],
      "Revenue*All Channels": [
        {
          "className": "bg-black"
        }
      ],
      "Net Revenue Ex Ads*All Channels": [
        {
          "className": "bg-black"
        }
      ],
      "Operating Income": [
        {
          "className": "bg-black"
        }
      ],
      "Operating Income Ex - Ads*All Channels": [
        {
          "className": "bg-black"
        }
      ],
      "": [
        {
          "attribute": "APQ Format"
        }
      ]
    },
    "columnFormat": {
      "": [
        {
          "attribute": "APQ Format"
        }
      ]
    },
    "colWidths": [
      331,
      156,
      75,
      80,
      80,
      80,
      80,
      80,
      80,
      20,
      80,
      80,
      80,
      80,
      80,
      20,
      80,
      80,
      80,
      80,
      80,
      80,
      22,
      80,
      80,
      80,
      80,
      80,
      48,
      80,
      80,
      80,
      80,
      80,
      20,
      80,
      80,
      80,
      80,
      80,
      80,
      20,
      80,
      80,
      80,
      80,
      80
    ],
    "hiddenColumns": [],
    "hiddenRows": [],
    "tableFilters": {
      "conditionsStack": [],
      "filterOptions": {}
    },
    "insertedRowsAndColumns": {
      "columnDataIndex": 16,
      "rowDataIndex": 8,
      "columnData": [
        [],
        [],
        [],
        [],
        [],
        [],
        [],
        [],
        [],
        [],
        [],
        [],
        [],
        [],
        [],
        []
      ],
      "rowData": [
        [
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          ""
        ],
        [
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          ""
        ],
        [
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          ""
        ],
        [
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          ""
        ],
        [
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          ""
        ],
        [
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          ""
        ],
        [
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          ""
        ],
        [
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          "",
          ""
        ]
      ]
    },
    "columnsMap": [
      0,
      1,
      2,
      3,
      4,
      5,
      6,
      {
        "empty": true,
        "name": "",
        "groupNames": [
          "",
          ""
        ],
        "colData": 1,
        "numberFormat": "#,###;(#,###);0;-",
        "class": "noborder whiteBack",
        "priority": 10,
        "ibcsClass": "",
        "numberOfAdditionalRows": 0,
        "appliedNumberFormat": "#,###;(#,###);0;-"
      },
      7,
      8,
      9,
      10,
      11,
      {
        "empty": true,
        "name": "",
        "groupNames": [
          "",
          ""
        ],
        "colData": 9,
        "numberFormat": "#,###;(#,###);0;-",
        "class": "noborder whiteBack",
        "priority": 10,
        "ibcsClass": "",
        "numberOfAdditionalRows": 0,
        "appliedNumberFormat": "#,###;(#,###);0;-"
      },
      12,
      13,
      14,
      15,
      16,
      17,
      {
        "empty": true,
        "name": "",
        "groupNames": [
          "",
          ""
        ],
        "colData": 10,
        "numberFormat": "#,###;(#,###);0;-",
        "class": "noborder whiteBack",
        "priority": 10,
        "ibcsClass": "",
        "numberOfAdditionalRows": 0,
        "appliedNumberFormat": "#,###;(#,###);0;-"
      },
      18,
      19,
      20,
      21,
      22,
      {
        "empty": true,
        "name": "",
        "groupNames": [
          "",
          ""
        ],
        "colData": 11,
        "numberFormat": "#,###;(#,###);0;-",
        "class": "noborder whiteBack",
        "priority": 10,
        "ibcsClass": "",
        "numberOfAdditionalRows": 0,
        "appliedNumberFormat": "#,###;(#,###);0;-"
      },
      23,
      24,
      25,
      26,
      27,
      {
        "empty": true,
        "name": "",
        "groupNames": [],
        "colData": 14,
        "numberFormat": "#,###;(#,###);0;-",
        "class": "noborder whiteBack",
        "priority": 10,
        "ibcsClass": "",
        "numberOfAdditionalRows": 0,
        "appliedNumberFormat": "#,###;(#,###);0;-"
      },
      28,
      29,
      30,
      31,
      32,
      33,
      {
        "empty": true,
        "name": "",
        "groupNames": [],
        "colData": 15,
        "numberFormat": "#,###;(#,###);0;-",
        "class": "noborder whiteBack",
        "priority": 10,
        "ibcsClass": "",
        "numberOfAdditionalRows": 0,
        "appliedNumberFormat": "#,###;(#,###);0;-"
      },
      34,
      35,
      36,
      37,
      38
    ],
    "rowsMap": [
      0,
      1,
      2,
      3,
      4,
      5,
      6,
      7,
      8,
      9,
      10,
      11,
      12,
      13,
      14,
      15,
      16,
      17,
      18,
      19,
      20,
      21,
      22,
      23,
      24,
      25,
      26,
      27,
      28,
      29,
      30,
      31,
      32,
      33,
      34,
      35,
      36,
      37,
      38,
      39,
      40,
      41,
      42,
      43,
      44,
      45,
      46,
      47,
      48,
      49,
      50,
      51,
      52,
      53,
      54,
      55,
      56,
      57,
      58,
      59,
      60,
      61,
      62,
      63,
      64,
      65,
      66,
      67,
      68
    ],
    "fixedRowHeaders": {
      "numberOfColumns": "1"
    },
    "exportExcel": {
      "exportDBRWFormulaAsText": false,
      "exportActiveForm": true,
      "exportToExcelAsSlice": true
    },
    "allowTraceRule": true,
    "elementSelection": {
      "disableElementSelection": true
    },
    "ibcsHeaders": true
  },
  "wizard": {
    "hideBackButton": true,
    "hideNextButton": true
  },
  "toolbar": {
    "collapseButtonEnabled": true,
    "searchEnabled": true,
    "rowFiltersEnabled": true,
    "columnButtonEnabled": true,
    "columnFiltersEnabled": true,
    "modalButtonsEnabled": true,
    "processButtonEnabled": true,
    "refreshButtonEnabled": true,
    "batchPrintButtonEnabled": true,
    "exportButtonEnabled": true,
    "exportPDFButtonEnabled": false,
    "exportExcelWithFiltersButtonEnabled": true,
    "exportAsDBRWSliceButtonEnabled": true,
    "exportAsDBRWActiveFormButtonEnabled": false,
    "exportExcelButtonEnabled": true,
    "exportExcelPlainButtonEnabled": true,
    "exportPDFServlet": "print-v2.pdf",
    "columnFilterButtonEnabled": true,
    "sandboxEnabled": false,
    "exportPDFA3ButtonEnabled": false,
    "realTimeButtonEnabled": true,
    "realTimeEnabled": true,
    "excelHeadersButtonEnabled": true,
    "exportCustomButtonEnabled": true,
    "exportPrintButtonEnabled": false,
    "exportExcelAllTablesWithFiltersButtonEnabled": true,
    "exportPDFDefaultOptions": [
      "A4",
      "PORTRAIT",
      "pdf"
    ],
    "customExportOptions": {
      "pageSize": [
        "LETTER",
        "LEGAL",
        "TABLOID",
        "A0",
        "A1",
        "A2",
        "A3",
        "A4",
        "A5"
      ],
      "pageOrientation": [
        "LANDSCAPE",
        "PORTRAIT"
      ],
      "pageOutputTypes": [
        "pdf",
        "jpeg",
        "png"
      ]
    }
  }
}

Comments (2)

  1. Log in to comment