Posted 8 September 2017, 1:30 pm EST
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.