Incorrect cell alignment

Issue #728 open
Cindy created an issue

We are seeing incorrect cell alignment on some of our reports on the left and right side of the freeze pane, see screenshot attached.

Comments (7)

  1. Ada Trajer
    • changed status to open

    Hi Cindy, thank you for raising a ticket, we are currently working on replicating the issue. We will reach out if more information is needed.

  2. Cindy reporter

    Thanks! It appears to be related to classes utilizing a border - when I remove the borders the issue does not occur

  3. Ada Trajer

    Hi Cindy, can you please send me the code (json) so I can see what exact formatting is applied in this view?

  4. Cindy reporter

    {
    "table": {
    "rowFormat": {
    "GMS*Retail": [
    {
    "className": "wwops_rowunbold"
    }
    ],
    "Units*Retail": [
    {
    "className": "wwops_rowunbold"
    }
    ],
    "Revenue*Retail": [
    {
    "className": "wwops_rowunbold"
    }
    ],
    "Net Revenue ex Ads*Retail": [
    {
    "className": "wwops_rowunbold"
    }
    ],
    "Operating Income ex Ads*Retail": [
    {
    "className": "wwops_rowunbold"
    }
    ],
    "": [
    {
    "attribute": "APQ Format"
    }
    ]
    },
    "columnFormat": {
    "": [
    {
    "attribute": "APQ Format"
    }
    ],
    "Variance $": [
    {
    "numberFormat": "#,##0,,;-#,##0,,; "
    }
    ],
    "% of Total": [
    {
    "numberFormat": "0.00%;-0.00%; "
    }
    ],
    "Variance %": [
    {
    "numberFormat": "0.00%;-0.00%; "
    }
    ],
    "Per Unit": [
    {
    "numberFormat": "#,##0.00;(#,##0.00); "
    }
    ],
    "Variance % of Total / GMS (bps)": [
    {
    "numberFormat": "#,##0;-#,##0; "
    }
    ],
    "Var Per Unit": [
    {
    "numberFormat": "#,##0.00;(#,##0.00); "
    }
    ]
    },
    "hiddenColumns": [],
    "hiddenRows": [],
    "tableFilters": {
    "conditionsStack": []
    },
    "insertedRowsAndColumns": {
    "columnDataIndex": 13,
    "rowDataIndex": 8,
    "columnData": [
    [],
    [],
    [],
    [],
    [],
    [],
    [],
    [],
    [],
    [],
    [],
    [],
    []
    ],
    "rowData": [
    [
    "",
    "",
    "",
    "",
    "",
    "",
    "",
    "",
    ""
    ],
    [
    "",
    "",
    "",
    "",
    "",
    "",
    "",
    "",
    ""
    ],
    [
    "",
    "",
    "",
    "",
    "",
    "",
    "",
    "",
    ""
    ],
    [
    "",
    "",
    "",
    "",
    "",
    "",
    "",
    "",
    ""
    ],
    [
    "",
    "",
    "",
    "",
    "",
    "",
    "",
    "",
    ""
    ],
    [
    "",
    "",
    "",
    "",
    "",
    "",
    "",
    "",
    ""
    ],
    [
    "",
    "",
    "",
    "",
    "",
    "",
    "",
    "",
    ""
    ],
    [
    "",
    "",
    "",
    "",
    "",
    "",
    "",
    "",
    ""
    ]
    ]
    },
    "columnsMap": [
    0,
    1,
    2,
    3,
    4,
    5,
    {
    "empty": true,
    "name": "",
    "groupNames": [
    "",
    ""
    ],
    "colData": 1,
    "numberFormat": "#,###;(#,###);0;-",
    "class": "noborder whiteBack",
    "priority": 10,
    "ibcsClass": "",
    "numberOfAdditionalRows": 0,
    "appliedNumberFormat": "#,###;(#,###);0;-"
    },
    6,
    7,
    8,
    9,
    10,
    {
    "empty": true,
    "name": "",
    "groupNames": [
    "",
    ""
    ],
    "colData": 2,
    "numberFormat": "#,###;(#,###);0;-",
    "class": "noborder whiteBack",
    "priority": 10,
    "ibcsClass": "",
    "numberOfAdditionalRows": 0,
    "appliedNumberFormat": "#,###;(#,###);0;-"
    },
    11,
    12,
    13,
    14,
    15,
    16,
    {
    "empty": true,
    "name": "",
    "groupNames": [
    "",
    ""
    ],
    "colData": 3,
    "numberFormat": "#,###;(#,###);0;-",
    "class": "noborder whiteBack",
    "priority": 10,
    "ibcsClass": "",
    "numberOfAdditionalRows": 0,
    "appliedNumberFormat": "#,###;(#,###);0;-"
    },
    17,
    18,
    19,
    20,
    21,
    {
    "empty": true,
    "name": "",
    "groupNames": [
    "",
    ""
    ],
    "colData": 4,
    "numberFormat": "#,###;(#,###);0;-",
    "class": "noborder whiteBack",
    "priority": 10,
    "ibcsClass": "",
    "numberOfAdditionalRows": 0,
    "appliedNumberFormat": "#,###;(#,###);0;-"
    },
    22,
    23,
    24,
    25,
    26,
    {
    "empty": true,
    "name": "",
    "groupNames": [
    "",
    ""
    ],
    "colData": 7,
    "numberFormat": "#,###;(#,###);0;-",
    "class": "noborder whiteBack",
    "priority": 10,
    "ibcsClass": "",
    "numberOfAdditionalRows": 0,
    "appliedNumberFormat": "#,###;(#,###);0;-"
    },
    27,
    28,
    29,
    30,
    31,
    32,
    {
    "empty": true,
    "name": "",
    "groupNames": [
    "",
    ""
    ],
    "colData": 9,
    "numberFormat": "#,###;(#,###);0;-",
    "class": "noborder whiteBack",
    "priority": 10,
    "ibcsClass": "",
    "numberOfAdditionalRows": 0,
    "appliedNumberFormat": "#,###;(#,###);0;-"
    },
    33,
    34,
    35,
    36,
    37
    ],
    "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
    ],
    "colWidths": [
    303,
    114,
    64,
    64,
    64,
    80,
    64,
    64,
    51,
    64,
    64,
    67,
    86,
    64,
    51,
    64,
    64,
    64,
    80,
    64,
    64,
    51,
    73,
    73,
    80,
    99,
    73,
    51,
    62,
    62,
    67,
    86,
    62,
    51,
    62,
    62,
    62,
    80,
    62,
    62,
    51,
    61,
    61,
    67,
    86,
    61
    ]
    },
    "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,
    "exportExcelButtonEnabled": true,
    "exportExcelPlainButtonEnabled": false,
    "exportPDFServlet": "print-v2.pdf",
    "columnFilterButtonEnabled": true,
    "exportCustomButtonEnabled": true,
    "exportPrintButtonEnabled": false
    }
    }

  5. Cindy reporter

    issue appears to be caused by the border-top class which is specified for certain elements with the “APQ Format” attribute

  6. Cindy reporter

    FYI, have added this parameter as suggested by Stuart: "viewportColumnRenderingOffset": 100

    I am now no longer able to reproduce this issue, but some of my users are still seeing it

  7. Log in to comment