The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.

How to: Create Shared Formulas

This example demonstrates how to apply a shared formula in a range of cells to avoid duplicating the same formula for each cell in the range, and reduce the size of the spreadsheet file. To do this, assign the formula string to the Range.Formula property of the cell range. The shared formula will be created and applied automatically.

worksheet.Cells["A2"].Value = 1;

// Use the shared formula in the "A3:A11" range of cells.
worksheet.Range["A3:A11"].Formula = "=SUM(A2+1)";

// Use the shared formula in the "B2:B11" range of cells.
worksheet.Range["B2:B11"].Formula = "=A2+2";

The following image shows the result of executing the code above (the workbook is opened in Microsoft® Excel®).

Spreadsheet_Formula_Shared

See Also