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

  • Profile Image
    growth99
    Asked on December 11, 2017 at 04: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
  • Profile Image
    Nik_C
    Answered on December 11, 2017 at 04: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.4

    And this is how it will look like:

    1512985179Screen Shot 2017-12-11 at 10.4

    Is that what you had in mind?

    Thank you!

  • Profile Image
    growth99
    Answered on December 11, 2017 at 02: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 

  • Profile Image
    EltonCris
    Answered on December 11, 2017 at 03: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.

  • Profile Image
    growth99
    Answered 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

  • Profile Image
    Nik_C
    Answered 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!