Formula Evaluation

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

  • Posted 8 September 2017, 12:52 pm EST

    Hello,

    I know you are releasing Farpoint Windows Forms version 4.

    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.

    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)".

    I´d like to know if version 3 of FarPoint will permit me to do it.

    I´m trying to implement this, but it´s being very difficult.

    Thanks,

    Flávio.
  • Replied 8 September 2017, 12:52 pm EST

    Hello,


    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.

     
        Dim c As New FarPoint.Win.Spread.FormulaInputEditor
    Me.Controls.Add(c)
    c.Location = New Point(0, 0)
    c.Size = New Size(100, 20)
    c.Attach(FpSpread1)
    FpSpread1.AllowUserFormulas = True
     
  • Replied 8 September 2017, 12:52 pm EST

    Scott,

    So, will this FormulaInputEditor, in conjunction Spread control, permit the users to construct its formulas selecting their arguments using mouse or keystroke?

    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?

    Thanks,

    Flávio.
  • Replied 8 September 2017, 12:52 pm EST

    Flavio,


    Yes. It will.

  • 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."
  • Replied 8 September 2017, 12:52 pm EST

    Hello,

    I´d like to correct my message.
    I´m just talking about version 4.

    Thanks.

    Flávio.
  • Replied 8 September 2017, 12:52 pm EST

    Thanks, Gina.
Need extra support?

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

Learn More

Forum Channels