Spreadsheet widge: column width and row numbers

  • eriediocese
    Asked on October 20, 2015 at 6:14 AM

    I need column A to be large than column B.   Can you provide the CSS code?

    Also, is it possible to hide the row numbers?

    Lastly, I need to tabulate the figures in column b at the bottom of column b.  Is that possible?

  • beril JotForm UI Developer
    Replied on October 20, 2015 at 8:48 AM

    Hi,

    1) You can chance the size of column with the code below:

    div#spreadsheetContainer {

    width: 500px !important;

    }

    table {

    width: 500px;

    }

    tr.c2 {

    width: 250px !important;

    }

    .B input {

    width: 250px !important;

    }

    2) add the code below to your custom CSS.

     

    th { display: none; }

     

    3) You can use survey matrix for this:

    Here is the guide:

    http://www.jotform.com/answers/645975-How-To-Create-a-Table-Within-The-Form#1

     

  • eriediocese
    Replied on October 20, 2015 at 6:54 PM

    IF I follow #2, the row numbers disappear as do the column headings.  Is there a way to hide just the row numbers.

    Additionally, the custom column headings that I created disappear in Internet Explorer.   This is if I visit the from on your web page not an embedded version of the form.

     

    Lastly, I chose the spreadsheet because I need the last row in the table to sum up the numbers entered in column b.   Would you still use the other matrix that you suggested?

  • Chriistian Jotform Support
    Replied on October 21, 2015 at 2:08 AM

    Hi,

     

    You can try to inject this custom CSS code in your form to hide the row numbers column.

    th:first-child {

        display: none !important;

    }

     

    As for the computation on your form, Spreadsheet widget is the applicable field/widget you need to achieve your requirement. I checked the form and I see you have already setup the formula for the sum of column b in the last row. 

     

    Here is a sample cloned form that I used for testing - https://form.jotformpro.com/52931086690965.


    Do let us know if you need further assistance.
    Regards.