EXCEL

[MKTK123]

HELLO I AM NEW MANAGING LABVIEW, I HAVE A PROBLEM, I NEED TO ENTER FORMULA ONE CELL BUT THE PROBLEM FORMULA THAT IF TYPE IN THE CELL SPECIFIED ME BUT NEEDED TO BE CALCULATE

DEPUTY PROGRAM

THANKS

[MikeS81]

Hi MKTK123,

i´m not sure if i understand your problem. But here what i do. If i insert the formula with the property Node "FormulaArray" and connect a 2D Array of string to it (containing the formula in the first cell), then it works. The ExcelSheet contain a field with my formula and shows the correct result.

see the pictures.

Mike

[MKTK123]

Thanks, the indication was of great assistance.

Now I have a concern, as I adjust when I write a text in a box to excel.

I am grateful to the person that I can collaborate

[Michael_Munroe]

MikeS81,

<property Node "FormulaArray" and connect a 2D Array of string >

FYI:  The FormulaArray property is not indended for entering an array of formulas.  The property needed here is the Formula property.  Formula arrays are special formulas which contain multiple ranges to be calculated at the same time (ie. ={SUM(B2:D2*B3:D3)}). They are clearly indicated by the brackets which are visible in the cell shown in your formula.  Enter a formula array in Excel requires pressing CNTL+SHIFT+ENTER.

MKTK123,

Another option is the property node FormulaR1C1.  If the formula needs to be determined at run time by the size or contents of the data, it is much easier to use R1C1 notation rather than A1 notation.  In Mike's example, substitute the formula "=SUM(R1C1:R3C1)" or "=SUM(r[-3]c[0]:r[-1]c[0])" if it is easier to use relative references.