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

  • Profile Image
    shamusm
    Asked on April 18, 2020 at 09: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.



    This is a re-post of a comment on How to Inject Custom CSS Codes

  • Profile Image
    jherwin
    Answered on April 19, 2020 at 01: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.

  • Profile Image
    jherwin
    Answered on April 19, 2020 at 01: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.