Is it possible to adjust the column width in the Spreadsheet widget?

  • shamusm
    Asked on April 18, 2020 at 9:35 PM

    Is it possible for the column width of each column in the Spreadsheet widget to resize based on the pre-populated data?

    For example, if Column A is pre-populated with 'ABCDEFGHIJKLM', then the column width is wide enough to fully display 'ABCDEFGHIJKLM'.

    Alternatively, is it possible to assign column widths to each column of the Spreadsheet widget?

    Thank you.

  • jherwin
    Replied on April 19, 2020 at 1:54 AM

    You need to inject codes into the CSS area of the widget. For example, to do the "A" column wider, I have used the following code:

    .A {
      width: 400px!important;
    }

    For "B" column, you can use the CSS code below:

    .B {
      width: 400px!important;
    }

    Guide: How to Inject CSS Codes to Widgets.

    You can change the width to your preference.

    Please give it a try and let us know how it goes.

  • jherwin
    Replied on April 19, 2020 at 1:57 AM

    Is it possible for the column width of each column in the Spreadsheet widget to resize based on the pre-populated data?

    Unfortunately, It's not possible to auto-adjust the width of column/rows based on the user's input.