Change the names of columns and rows with a spreadsheet extension

  • Profile Image
    YGU
    Asked on December 07, 2017 at 02: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 teams1 changed in number 2 changed in number . . . 5 changed in total
    Can I do it? cordially   M Guillermin

    yves.guillermin@lyon.ort.asso.fr

  • Profile Image
    tina
    Answered on December 07, 2017 at 05: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.gif

    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.

     

  • Profile Image
    YGU
    Answered on December 07, 2017 at 07:48 AM
    thank you very much Now, I would like the numbers in the cells to be centered and in red font
  • Profile Image
    Mike_G
    Answered on December 07, 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.png

    Result:

    1512661079t10_37_11.png

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

  • Profile Image
    YGU
    Answered on December 07, 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
  • Profile Image
    YGU
    Answered on December 07, 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
  • Profile Image
    John_Benson
    Answered on December 07, 2017 at 01: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.