How can I change cell size in widget Spreadsheet?

  • dstixrood
    Asked on November 20, 2018 at 4:21 PM

    I need to change the cell size and, if possible, be able to wrap in the widget spreadsheet.  No matter what I change the cell width to, it still only shows about 24 characters.  Can you help?

    Jotform Thread 1649282 Screenshot
  • Jan
    Replied on November 20, 2018 at 7:53 PM

    Please inject this custom CSS into the form:

    iframe#customFieldFrame_381 {
    width: 800px !important;
    max-width: none !important;
    position: relative;
    }

    Here's a guide: How-to-Inject-Custom-CSS-Codes.

    After that, you need to inject this CSS inside the Spreadsheet widget:

    .A {
    width:400px;
    }

    .B {
    width:300px;
    }

    Here's a guide: How-to-Inject-CSS-Codes-to-Widgets.

    154276156711 21 vludt Screenshot 10

    Here's the result:

    154276161411 21 gt90j Screenshot 21

    Hope that helps. Thank you.

  • dstixrood
    Replied on November 21, 2018 at 11:43 AM
    I still can’t seem to get it wide enough. I pasted the code in and changed the size of the cell, but it stopped getting any wider around 9000. What am I doing wrong?
    [cid:image001.png@01D48181.BCABD890]
    [cid:image002.png@01D48181.BCABD890]
    David
    ...
  • David JotForm Support
    Replied on November 21, 2018 at 1:09 PM

    If you want to increase the width further, increase the width of the widget:

    1542823692Capture Screenshot 10

    Once the widget width is increased it will allow for further increasing of the column widths.

  • dstixrood
    Replied on November 21, 2018 at 2:43 PM
    Almost there, thanks so much for all your help. I am trying to put in formulas for the six entries. Here is what I am putting in under Default Values
    b6=(b2+b3)-(b3+b4+b5)
    However, it is not populating b6. It remains blank.
    And, is there any way I can get column A to left justify?
    David
    ...
  • DonaldHag
    Replied on November 21, 2018 at 4:20 PM

    To Justify Left, add the following CSS to the Spreadsheet Widget:

    .A input {

    text-align:left;

    }

    Add this to the CSS already there.

    Add the formula without the brackets and well spaced. This should work as you require:

    b6 = b2 + b3 - b3 - b4 - b5  


  • dstixrood
    Replied on November 21, 2018 at 5:43 PM
    Absolutely perfect. Thanks for your patience and have a very Happy Thanksgiving.
    David
    ...