Change the names of columns and rows with a spreadsheet extension

  • YGU
    Asked on December 7, 2017 at 2:45 AM
    Hello, I'm going to use your spreadsheet extension and I want to change the names of columns and rows, example A changed solo B changed to duets C changed into teams 1 changed in number 2 changed in number . . . 5 changed in total
    Can I do it? cordially   M Guillermin

    yves.guillermin@lyon.ort.asso.fr

  • tina JotForm Developer
    Replied on December 7, 2017 at 5:00 AM

    Yes, you can manage the column and row names of the Spreadsheet table with using custom CSS.

    I tried to replicate your needs. Here you can see an example form with Spreadsheet:

    https://form.jotform.com/73402286623959

     

    1512640563re Screenshot 10

    Just copy the code below and paste it into CUSTOM CSS tab:

     

     

    #col_A, #col_B, #col_C,#row_1,#row_2,#row_3,#row_4,#row_5 {

       color: transparent;

       font-size: 1px;

    }

     

    #col_A:before, #col_B:before,#col_C:before,#row_1:before,#row_2:before,#row_3:before,#row_4:before,#row_5:before  {

        color: #FFF;

        font-size: 14px;

    }

     

    #col_A:before {

       content: "Solo";

    }

     

    #col_B:before {

       content: "Duets";

    }

    #col_C:before {

       content: "Teams";

    }

    #row_1:before {

    content: "Number";

    }

    #row_2:before {

    content: "Number";

    }

    #row_3:before {

    content: "Number";

    }

    #row_4:before {

    content: "Number";

    }

    #row_5:before {

    content: "Total";

    }

    I hope it helps.

     

  • YGU
    Replied on December 7, 2017 at 7:48 AM
    thank you very much Now, I would like the numbers in the cells to be centered and in red font
  • Mike_G JotForm Support
    Replied on December 7, 2017 at 10:38 AM

    If I'm understanding your new concern correctly, here are the CSS codes you need to meet your requirements — How-to-Inject-CSS-Codes-to-Widgets

    .cell-input {

        color: red !important;

        text-align: center !important;

        font-weight: bold !important;

    }

    1512661017t10 34 06 Screenshot 10

    Result:

    1512661079t10 37 11 Screenshot 21

    If you have other questions or concerns, please feel free to contact us again anytime.

  • YGU
    Replied on December 7, 2017 at 12:13 PM
    I thank you for all your answers, I do not speak English well, but I can understand you a little cordially
    YVES
  • YGU
    Replied on December 7, 2017 at 12:23 PM
    The cells are in red and that's perfect,
    one last question: I did some calculations and I would like to lock cell C1 where the total runs EXAMPLE C1 = A1 + A2 I do not want the user to delete cell C1thank you
  • John_Benson
    Replied on December 7, 2017 at 1:34 PM

    To avoid confusion, we will be addressing your new question to a new thread. Please wait for our response to this link: https://www.jotform.com/answers/1317285

    Thank you.