Column width setting not working in some columns

I have set colWidths in settings for same width with all the columns (except the 1st column), however the last three columns are showing wider than the others, how should I fix this? Thanks!

{
  "cardConfig": {
    "height": "500",
    "showTopBorder": true,
    "shouldShowTitlesSeparator": true,
    "showSpinner": false,
    "subTitle": false,
    "showFooter": false,
    "footer": {
      "showFilterInFooter": false,
      "iconClass": "",
      "text": "",
      "callBackFn": "",
      "href": ""
    }
  },
  "table": {
    "columnFormat": {
      "Fail": [
        {
          "condition": ">",
          "value": "0",
          "className": "bg-orange-200"
        }
      ]
    },
    "colWidths": [
      100,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75
    ],
    "hiddenColumns": [],
    "tableFilters": {
      "conditionsStack": []
    },
    "insertedRowsAndColumns": {
      "columnDataIndex": 0,
      "rowDataIndex": 0,
      "columnData": [],
      "rowData": []
    },
    "hiddenRows": [],
    "columnsMap": [
      0,
      1,
      2,
      3,
      4,
      5,
      6,
      7,
      8,
      9,
      10,
      11,
      12,
      13,
      14,
      15,
      16,
      17,
      18,
      19
    ],
    "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
    ]
  }
}

How many columns are in the table? You have set a width of 75 for the first 36 columns. If the table now includes more than 36 columns then the width from the 37th column onwards will be determined be the header text.

there are only 22 columns, and when I adjust a bit the column width in edit mode, settings code will show the actual width (below code), but still not working if i edit the width into 75

{
  "cardConfig": {
    "height": "500",
    "showTopBorder": true,
    "shouldShowTitlesSeparator": true,
    "showSpinner": false,
    "subTitle": false,
    "showFooter": false,
    "footer": {
      "showFilterInFooter": false,
      "iconClass": "",
      "text": "",
      "callBackFn": "",
      "href": ""
    }
  },
  "table": {
    "columnFormat": {
      "Fail": [
        {
          "condition": ">",
          "value": "0",
          "className": "bg-orange-200"
        }
      ]
    },
    "colWidths": [
      100,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      75,
      147,
      156,
      76
    ],
    "hiddenColumns": [],
    "tableFilters": {
      "conditionsStack": []
    },
    "insertedRowsAndColumns": {
      "columnDataIndex": 0,
      "rowDataIndex": 0,
      "columnData": [],
      "rowData": []
    },
    "hiddenRows": [],
    "columnsMap": [
      0,
      1,
      2,
      3,
      4,
      5,
      6,
      7,
      8,
      9,
      10,
      11,
      12,
      13,
      14,
      15,
      16,
      17,
      18,
      19
    ],
    "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
    ]
  }
}

"columnsMap": [ 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21 ],
notice the amount of columns also have to be added to the columnMap array to get mapped correctly, added 20,21

still not working after editing columnsMap… :frowning:

Ideally, you shouldn’t need to edit the colWidths in the Advanced Options.

The best way to set the column widths is to be in edit mode and adjust the column width by sliding the divider between the columns. This will then save the widths to the advanced options.

If you wish to change the width of multiple columns at the same time then select multiple columns before adjusting the column width.

also not working for manually adjust the column width, clicking publish then refresh automatically, the column width getting wider again… not sure if css setting causing this issue?

as this seems a bug so i have created ticket
apliqoc3ux / apq-c3-ux / issues / #411 - Column width setting not working in some columns — Bitbucket

Did you clear the entire advanced settings, save and then readjust the width manually as Stuart suggested? There might be an error we couldn’t see in the code syntax/format.

also tried clear all the settings then manual adjust then save, still those last few columns will just get wider…:smiling_face_with_tear:

If you are able to reproduce the issue on Apliqo Demo db that would be useful. From my attempts I have been unable to reproduce the behaviour that you are experiencing.

Could you confirm whether you have any filters defined, either column or Default View? If so, please disable and see if this helps with the column width definitions

I encountered a similar problem with grouped columns, especially when the column names are lengthy.