We are not able to change the content in spreadsheet header and we are not able to remove first column which shows 1,2,3

  • growth99
    Asked on December 11, 2017 at 4:28 AM
    3. We are not able to change the content in spreadsheet header and we are not able to remove first column which shows 1,2,3
  • Nik_C
    Replied on December 11, 2017 at 4:40 AM

    You can remove the 1,2 row names by inserting the below CSS to Custom CSS field of the Spreadsheet widget:

    th#row_1, #row_2, #spreadsheetContainer > table > tbody > tr:nth-child(1) > th:nth-child(1) {

        display: none;

    }

    1512985155Screen Shot 2017 12 11 at 10 Screenshot 10

    And this is how it will look like:

    1512985179Screen Shot 2017 12 11 at 10 Screenshot 21

    Is that what you had in mind?

    Thank you!

  • growth99
    Replied on December 11, 2017 at 2:54 PM

    This is great. How can we change the header A, B, C to custom heading along with customer width for each column. THanks 

  • Elton Support Team Lead
    Replied on December 11, 2017 at 3:48 PM

    Use this CSS codes.

    #col_A, #col_B, #col_C, #col_D, #col_E, #col_F {

        font-size: 0;

        color: #000;

    }

    th[id^="col_"]:after{

        font-size:12px !important;

        color:#ffffff !important;

    }

    #col_A:after{

        content:"Label 1";

    }

    #col_B:after{

        content:"Label 2";

    }

    #col_C:after{

        content:"Label 3";

    }

    #col_D:after{

        content:"Label 4";

    }

    Just replace the labels in the code with your custom labels.

    If you have more columns, just append the following code and then increment its column letter and change the label.

    #col_E:after{

        content:"Label 5";

    }

    Inject this CSS code in the same settings as instructed by my colleague.

  • growth99
    Replied on December 13, 2017 at 11:21 AM

    Hey Guys, When we click on print form the spredsheet print is not working correctly. Please check here. Let us know if you have any advice for us. 


    https://form.jotform.com/73415588949171

  • Nik_C
    Replied on December 13, 2017 at 12:52 PM

    I opened a separate thread for your last issue here and we will attend it here: https://www.jotform.com/answers/1322214

    Thank you!