Microsoft Office Tutorials and References
In Depth Information
Excel formulae
The following screenshot shows the results of adding and executing the
preceding code:
Excel has numerous built-in options for recognizers, which can be disabled and
enabled as per the users' needs. In addition to this, VSTO offers an option to create
and manage document-level smart tags. When creating smart tags using VSTO, first
create the instance of the SmartTag class and provide the caption name and unique
identifier for your smart tag. Using the methods and properties, you can precede the
smart tag creation.
Excel formulae
Microsoft Office Excel formulae allow you to execute calculations on the data entered
in the spreadsheet cells. Using a formula is a method of performing calculations that
rely on a recognized approach. VSTO helps Office developers to automate Excel
solutions with formulae for calculation in the cells of the spreadsheet.
Formula is a property of the NamedRange control in the Microsoft.Office.Tools.
Excel object. If the NamedRange control contains a formula, the Formula property
returns the formula as a string.
Let's see an example of multiplying a range of cell values, and displaying the results
in the assigned cell. Open Visual Studio 2008 and create a new solution, as usual.
Write the following code in the Sheet1.cs file:
Search JabSto ::

Custom Search