Replied 8 September 2017, 2:49 pm EST
You can make use of the FormulaTextBox which is similar to the Formula bar in Excel. Once you have attached it to the Spread, any formula you type into it, is entered in the active cell. It also provides you suggestion for the formulas and the variables required by it. Moreover, if you wish to use a cell range in the sheet as values to a formula, you can select them using the mouse, in the similar way as you do in Excel. You can refer to the following link to know how exactly this FormulaTextBox works:
Hope it will help you. Please let me know if you have any queries further.