How Can I do the Selected FormulaData like Excel's dotted line

Posted by: lo20061 on 8 September 2017, 2:38 pm EST

  • Posted 8 September 2017, 2:38 pm EST

    Excuse me sir,
    I have a problem with spread which is seleted formula data?I hoped it that when I selected the formula data then it can be like excel's dotted line.just like the image:

    What I can do for it?Can you give me some code?

  • Replied 8 September 2017, 2:38 pm EST

    <IMG src="">

    <IMG src="">

  • Replied 8 September 2017, 2:38 pm EST


    Yes you can select the data in spread in the
    same way as that of excel with a dotted line, by simply adding a formula
    text box to your spread control wherein you can then make selection by mouseclick on data area of Spread control :

                fpSpread1.AllowUserFormulas = true;
                FarPoint.Win.Spread.FormulaTextBox editor = new FarPoint.Win.Spread.FormulaTextBox();
                editor.Location = new Point(0, 0);
                editor.Size = new Size(80, 20);


    We have set AllowUserFormulas property to true as well because
    by doing so the user can now enter formula either in a cell or in the
    Formula Text Box.

    Hope it will help you. Thanks.

  • Replied 8 September 2017, 2:38 pm EST

    Thank you Reeva Dhingra,
             but it has an error when I try to make it work well with this code which is "Each Spread control can be attached to only one FormulaTextBox control." ?I promise there is only one FormulaTextBox which you gived me.
  • Replied 8 September 2017, 2:38 pm EST

    Hello Reeva Dhingra,
             I make it in a new form,then it has no error.But I,cant's see the dotted line when I selected the data.It just has an FormulaBox.
  • Replied 8 September 2017, 2:38 pm EST


    Once the FormulaTextBox is attached
    with the Spread control it will work for all the SpreadSheets. Please make sure that you have properly attached the FormulaTextBox with the Spread control wherein then you will be able to select the cell/cellRange using mouse click.


    Let us know your further observations on the same. Hope it will help you.

Need extra support?

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

Learn More

Forum Channels