topic the formulas of a script don't apply in Discussions https://community.jmp.com/t5/Discussions/the-formulas-of-a-script-don-t-apply/m-p/430959#M68067 <P>hi,</P><P>I wrote a script to import an excel sheet.</P><P>Some formulas do not apply.&nbsp;</P><P>&nbsp;</P><P>you can see the extract of the script with the formulas.</P><P>the data base after running script with some empties columns (the formulas don't apply);</P><P>if I make "Apply" in the colum property, then the formula apply.</P><P>I don't understand why.</P><P>&nbsp;</P><P>best regards.</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="extract of my script to show formulas.JPG" style="width: 839px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/37067i4352AAE99F50A981/image-size/large?v=v2&amp;px=999" role="button" title="extract of my script to show formulas.JPG" alt="extract of my script to show formulas.JPG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="The data base .JPG" style="width: 999px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/37068i47C7589257186AB3/image-size/large?v=v2&amp;px=999" role="button" title="The data base .JPG" alt="The data base .JPG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture 1.JPG" style="width: 999px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/37069i2F9A37F9057E9B64/image-size/large?v=v2&amp;px=999" role="button" title="Capture 1.JPG" alt="Capture 1.JPG" /></span></P> Fri, 09 Jun 2023 18:04:00 GMT Françoise 2023-06-09T18:04:00Z the formulas of a script don't apply https://community.jmp.com/t5/Discussions/the-formulas-of-a-script-don-t-apply/m-p/430959#M68067 <P>hi,</P><P>I wrote a script to import an excel sheet.</P><P>Some formulas do not apply.&nbsp;</P><P>&nbsp;</P><P>you can see the extract of the script with the formulas.</P><P>the data base after running script with some empties columns (the formulas don't apply);</P><P>if I make "Apply" in the colum property, then the formula apply.</P><P>I don't understand why.</P><P>&nbsp;</P><P>best regards.</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="extract of my script to show formulas.JPG" style="width: 839px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/37067i4352AAE99F50A981/image-size/large?v=v2&amp;px=999" role="button" title="extract of my script to show formulas.JPG" alt="extract of my script to show formulas.JPG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="The data base .JPG" style="width: 999px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/37068i47C7589257186AB3/image-size/large?v=v2&amp;px=999" role="button" title="The data base .JPG" alt="The data base .JPG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture 1.JPG" style="width: 999px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/37069i2F9A37F9057E9B64/image-size/large?v=v2&amp;px=999" role="button" title="Capture 1.JPG" alt="Capture 1.JPG" /></span></P> Fri, 09 Jun 2023 18:04:00 GMT https://community.jmp.com/t5/Discussions/the-formulas-of-a-script-don-t-apply/m-p/430959#M68067 Françoise 2023-06-09T18:04:00Z Re: the formulas of a script don't apply https://community.jmp.com/t5/Discussions/the-formulas-of-a-script-don-t-apply/m-p/430978#M68068 <P>hi,</P><P>&nbsp;</P><P>the problem is solved.</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 28 Oct 2021 06:55:23 GMT https://community.jmp.com/t5/Discussions/the-formulas-of-a-script-don-t-apply/m-p/430978#M68068 Françoise 2021-10-28T06:55:23Z