Spread Silverlight Documentation
Allowing the User to Enter Formulas
Spread Silverlight Documentation > Developer's Guide > Managing the User Interface > Using Formulas > 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). Use Ctrl + Shift + Enter to create an array formula after entering the formula.

You can use the CanUserEditFormula property to prevent this.

Using Code

The following example allows the user to enter formulas.

CS
Copy Code 
gcSpreadSheet1.CanUserEditFormula = true;
VB.NET
Copy Code 
GcSpreadSheet1.CanUserEditFormula = True
See Also
Creating Custom Formulas
Creating Custom Names

Formula Reference

Formula Functions
Array Formulas

 

 

Copyright © GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page