Formula Evaluation

Posted by: fhcnunes-fp on 8 September 2017, 12:52 pm EST

  • Posted 8 September 2017, 12:52 pm EST

    Hello,<br><br>I know you are releasing Farpoint Windows Forms version 4.<br><br>I´d like to know if, in this version, it´ll be possible to generate formulas, like in Excel, using keystroke or mouse. For example, when I type "=" character, the spreadsheet begins to create a formula. If you type a cell, spreadsheet recognize it as a function argument. <br><br>If I´m in cell A1 and type "=" and, next, I click in cell G2, cell A1 will be the content "=G2". The same is true when I type "=sum(" and select a cell range, like "B2:D5". After the selection, content of cell A1 will be "=sum(B2:D5)". <br><br>I´d like to know if version 3 of FarPoint will permit me to do it.<br><br>I´m trying to implement this, but it´s being very difficult.<br><br>Thanks,<br><br>Flávio.<br>
  • Replied 8 September 2017, 12:52 pm EST

    <P>Hello,</P>
    <P>In version 4 we are adding a new control, FormulaInputEditor, that when used in conjunction with the Spread control will give you the functionality you are looking.</P> <PRE class=coloredcode> <SPAN class=kwd>Dim</SPAN> c <SPAN class=kwd>As New</SPAN> FarPoint.Win.Spread.FormulaInputEditor
    <SPAN class=kwd>Me</SPAN>.Controls.Add(c)
    c.Location = <SPAN class=kwd>New</SPAN> Point(0, 0)
    c.Size = <SPAN class=kwd>New</SPAN> Size(100, 20)
    c.Attach(FpSpread1)
    FpSpread1.AllowUserFormulas = <SPAN class=kwd>True</SPAN>
    </PRE> 
  • Replied 8 September 2017, 12:52 pm EST

    Scott,<br><br>So, will this FormulaInputEditor, in conjunction Spread control, permit the users to construct its formulas selecting their arguments using mouse or keystroke? <br><br>For example, is it possible to construct the formula "=sum(A1:B2, F10:I13)" typing "=sum(" and ")" and selecting the cells A1 to B2 and F10 to I13 using FormulaInputEditor control?<br><br>Thanks,<br><br>Flávio.<br>
  • Replied 8 September 2017, 12:52 pm EST

    <P>Flavio,</P>
    <P>Yes. It will.</P>
  • Replied 8 September 2017, 12:52 pm EST

    If this does not change, this is the basic behavior, "To use the formula bar, type the equal sign (=) and then start typing the name of the formula. This brings up a list of functions that start with that letter. You can then type the left parenthesis and either select a block of cells by dragging the mouse over that range or type cell values by absolute or relative reference."<br>
  • Replied 8 September 2017, 12:52 pm EST

    Hello,<br><br>I´d like to correct my message.<br>I´m just talking about version 4.<br><br>Thanks.<br><br>Flávio.<br>
  • Replied 8 September 2017, 12:52 pm EST

    Thanks, Gina.<br>
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels