problem with scroll bar and formula

Posted by: sumathi on 8 September 2017, 1:30 pm EST

  • Posted 8 September 2017, 1:30 pm EST

    Hello,


     We are using windows spread sheet for C#.Net application.


    We have included formula text box to GUI. we made the allowuserformula = true.


    We are able to use formula text box perfectly. We can insert the formula in the cell correctly.


    i.e. in cell A1 I can give the formula =Sum(B1:F1). It is working correctly.


    I want to give the formula in A1 as Sum(AF1:AF14). I want to give this formula using mouse. I have type "=sum(" in the A1 and scrolled down using the scroll bar to select AF1 to AF14. But the text in A1 is disappeared.


     Please suggest how can I restrict the deeltion of text in the cell on scrolling.


     

  • Replied 8 September 2017, 1:30 pm EST

    Hello,


    Clicking on the scrollbar will cause the cell to go out of editmode. The only way to scroll the sheet and keep the formula editing is to click on the Spread in the visible area and with the mouse down make a selection to the part of the Spread that has the cells you want in your formula. Then, make a new selection of those cells. The first click is to allow the Spread to scroll to the area with the cells you want for the formula.

  • Replied 8 September 2017, 1:30 pm EST

    Hello,


     Please can you help by providing the code for this.


    I am unable to get you.


    Thank you.

  • Replied 8 September 2017, 1:30 pm EST

    Hello,


    There is not any code. You just click on the cell you want the formula (A1) and type the '=' character so Spread starts editing a formula for that cell. Now instead of clicking on the scrollbar to scroll to AF1 to start your cell selection you would need to scroll some other way. The way I suggested was to click on another cell (like D1) and move your mouse off the Spread toward AF1. This will cause the wrong cells to be selected, but it will scroll the Spread to the desired range of cells. Then let go of the mouse and then select the block of cells you do want (AF1:AF5). Now the formula in A1 should be correct.

  • Replied 8 September 2017, 1:30 pm EST

    Hello,


    I think this is the bug in the farpoint. can we expect that this will be resolved in the next patch or next release of farpoint.


    Please send us the link if farpoint rectifies this bug.

  • Replied 8 September 2017, 1:30 pm EST

    I think Scott will agree that this is not a bug.  You would see the same behavior if you put another cell into edit mode and then tried scrolling the sheet.  The cell would go out of edit mode.  The spread has always functioned in this way.  I will write this up as an enhancement for a future release to not let the cell go out of edit mode if the user is trying to add a range to the formula.
Need extra support?

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

Learn More

Forum Channels