Allowing the User to Enter Formulas

Users can enter a formula in a cell by starting with an equals sign (=). Type the equal sign and then the formula such as = sum(A1+B1) once the cell is in edit mode.

You can use the CanUserEditFormula property to prevent this.

Using Code

This example allows the user to enter formulas.

CS
Copy Code
gcSpreadSheet1.CanUserEditFormula = true;
VB
Copy Code
gcSpreadSheet1.CanUserEditFormula = True
See Also

 

 


Copyright © GrapeCity, inc. All rights reserved.