How can I show the fomular list as Excel

Posted by: levanduyet-fp on 8 September 2017, 3:01 pm EST

  • Posted 8 September 2017, 3:01 pm EST

    Hi,

    How can I show the fomular list as Excel as the following picture

     Thanks,

     Duyet

  • Replied 8 September 2017, 3:01 pm EST

    Hello,

    You can get the position of the cell on the sheet using the GetCellRectangle method, please refer to the following link that describes the same:

              http://www.gcpowertools.com/help/spreadnet6/WF2/FarPoint.Win.Spread~FarPoint.Win.Spread.FpSpread~GetCellRectangle.html

    Hope it will help you. Please let me know if you have any queries further.

    Thanks,

    Manpreet Kaur

  • Replied 8 September 2017, 3:01 pm EST

    Hello,

    Please refer to the following link that describes the same:

           http://www.gcpowertools.com/help/spreadnet6/WF2/spwin-formulabar.html

    Hope it will help you. Please let me know if you have any queries further.

    Thanks,

    Manpreet Kaur

  • Replied 8 September 2017, 3:01 pm EST

    Hi Manpreet Kaur,

    Tks for your reply. It's a difference that Excel show the fomular list when the user enter the fomular in the cell.

    I don't want to show the fomular bar, I want to show only the fomular list.

    Tks,

    Duyet

  • Replied 8 September 2017, 3:01 pm EST

    Hello,

    I would like you to know that this is an intended behavior and the only way this Excel functionality is implemented in Spread. There is not a way to get the formula list in the cell, you would need to show the formula bar and type the formula in the same to show the formula list.

    Hope it will help you. Please let me know if you have any queries further.

    Thanks,

    Manpreet Kaur

  • Replied 8 September 2017, 3:01 pm EST

    Hi Manpreet Kaur,

    If so, how can I define the position of the active cell, so that I can set the possition of the fomular box in this active cell.

    Tks,

    Duyet

  • Replied 8 September 2017, 3:01 pm EST

    Hello,

    I am not sure about this GetCellRectangle. Let's say, If I want to get the position of the cell C10, then my code should be

    Rectangle r
    r = fpSpread1.GetCellRectangle(10, 10, 1, 1);
    Is it correct?
    Tks,
    Duyet 
  • Replied 8 September 2017, 3:01 pm EST

    Hello,

    The GetCellRectangle method takes four arguments i.e RowViewPortIndex, ColumnViewPortIndex, row and column. The Spread can be divided into multiple rowviewports and columnviewports to show different views of huge data in the same Spread. By default it has one rowviewport and one columnviewport with 0 index for each. Secondly the indexing in Spread starts at 0, so cell C10 would have row index = 9 and column index = 2. Now, since you have only one rowviewport and one columnviewport, the RowViewPortIndex and ColumnViewPortIndex are both 0, and row index is 9, column index is 2, hence you would call the GetCellRectangle method as follows to get the position of cell C10:

                                                 Rectangle r;

    r = fpSpread1.GetCellRectangle(0, 0, 9, 2);
    Hope it will help you. Please let me know if you have any queries further.
    Thanks,
    Manpreet Kaur 
  • Replied 8 September 2017, 3:01 pm EST

    Hi Manpreet Kaur,

    I have tried but can not move the formula textbox to the ActiveCell position.

    Duyet

  • Replied 8 September 2017, 3:01 pm EST

    Hello,

    It would not be possible to move the FormulaTextBox  to the cell location using the GetCellRectangle method as the FormulaTextBox is added to the form on the location returned by the GetCellRectangle method and not to the Spread cell. If you want to place the same, then you may do the same in the form design by dragging the FormulaTextBox from toolbox and dropping the same on the cell. Hope it will help you. Please let me know if you have any queries further.

    Thanks,

    Manpreet Kaur

Need extra support?

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

Learn More

Forum Channels