On the widget "SPREADSHEET" formulas don't work well

  • marchitect
    Asked on June 12, 2015 at 6:31 AM
    hi, I need to use the widget "spreadsheet " but does not work well. I would have the need to use a part pre-set with of the written and other part with the formulas ( example d4 = a4xb4 ) . All these functions work when the amount , but if I upgrade or go to the preview widget is empty .
  • Carina
    Replied on June 12, 2015 at 9:57 AM

    Is it the form 51552395199364? I tested the Spreadsheet widget and the formulas are working well:

    On the widget SPREADSHEET formulas dont work well Image 1 Screenshot 40

    If you need to add preset values you can use the default values option:

    On the widget SPREADSHEET formulas dont work well Image 2 Screenshot 51

     

    ", but if I upgrade or go to the preview widget is empty . "

    I previewed the widget and it still showed the formulas and default values:

    On the widget SPREADSHEET formulas dont work well Image 3 Screenshot 62

    What do you mean "if I upgrade"?

    We'll wait for more details to continue.

  • marchitect
    Replied on June 13, 2015 at 1:50 PM

    HI, i resolved the problem but now i'have  another one. I canghed the first line (A-B-C-D) with other word and other color...it's go perfect! But i can't see the color posted in CHROME, it go perfect in FIREFOX and EXPLORER...but the background  color it's TRASPARENT in CHROME...  

    i USED THIS CSS CUSTOM:

    tr:first-child {
        background: none #DC143C;
      
    }
    th#col_A {
        max-width: 0;
        visibility: hidden;
    }
    th#col_A:before {
        content: "TIPOLOGIA";
        color: #000060;
        visibility: visible;
    }
    th#col_B {
        max-width: 0;
        visibility: hidden;
    }
    th#col_B:before {
        content: "n°PAX";
        color: #000060;
        visibility: visible;
    }
    th#col_C {
        max-width: 0;
        visibility: hidden;
    }
    th#col_C:before {
        content: "€ a PERSONA";
        color: #000060;
        visibility: visible;
    }
    th#col_D {
        max-width: 0;
        visibility: hidden;
    }
    th#col_D:before {
        content: "€ TOTALE";
        color: #000060;
        visibility: visible;
    }

    .A input{width: 120px;text-align:left;}
    .A input{height: 16px;text-align:left;}
    .B input{width: 120px;text-align:right;}
    .C input{width: 120px;text-align:right;}
    .D input{width: 130px;text-align:right;}

  • marchitect
    Replied on June 13, 2015 at 2:35 PM

    Another problem is that i have to chage "," in ".". The real problem is that the form is used to make calculations. being able to enter a comma (,)
    as a decimal divider (in Italy and is widely used)

    that happens : if 10.5 + 10.5 = 11  10.5 + 10.5 = 10 . THIS ' A PROBLEM . HELP ME
    .
  • Carina
    Replied on June 13, 2015 at 6:16 PM

    I moved these last questions to new threads as they were different issues. You can find them here:

    http://www.jotform.com/answers/588052 

    http://www.jotform.com/answers/588048 

    Let us know if we can assist you further.