Cell.RemoveArrayFormula
Cell.RemoveArrayFormula method
Remove array formula.
public void RemoveArrayFormula(bool leaveNormalFormula)
Parameter | Type | Description |
---|---|---|
leaveNormalFormula | Boolean | True represents converting the array formula to normal formula. |
Examples
using System;
using Aspose.Cells;
namespace AsposeCellsExamples
{
public class CellMethodRemoveArrayFormulaWithBooleanDemo
{
public static void Run()
{
Workbook wb = new Workbook();
Worksheet sheet = wb.Worksheets[0];
Cells cells = sheet.Cells;
// Set array formula in single cell
Cell cell = cells["A1"];
cell.SetArrayFormula("=B1:D1", 1, 1);
cells["B1"].PutValue(10);
cells["C1"].PutValue(20);
cells["D1"].PutValue(30);
wb.CalculateFormula();
Console.WriteLine("Before RemoveArrayFormula(false):");
Console.WriteLine("IsArrayFormula: " + cell.IsArrayFormula);
Console.WriteLine("Value: " + cell.Value);
cell.RemoveArrayFormula(false);
Console.WriteLine("\nAfter RemoveArrayFormula(false):");
Console.WriteLine("IsFormula: " + cell.IsFormula);
Console.WriteLine("Value: " + cell.Value);
// Set array formula again and remove with true parameter
cell.SetArrayFormula("=B1:D1", 1, 1);
cell.RemoveArrayFormula(true);
Console.WriteLine("\nAfter RemoveArrayFormula(true):");
Console.WriteLine("IsArrayHeader: " + cell.IsArrayHeader);
Console.WriteLine("Formula: " + cell.Formula);
// Set array formula across multiple cells
cell = cells["A1"];
cell.SetArrayFormula("=B1:D1", 1, 3);
cell.RemoveArrayFormula(false);
Console.WriteLine("\nAfter multi-cell RemoveArrayFormula(false):");
for (int i = 0; i < 3; i++)
{
Console.WriteLine($"Cell {cells[0, i].Name}: Value = {cells[0, i].Value}");
}
// Set array formula again and remove with true parameter
cell.SetArrayFormula("=B1:D1", 1, 3);
cell.RemoveArrayFormula(true);
Console.WriteLine("\nAfter multi-cell RemoveArrayFormula(true):");
for (int i = 0; i < 3; i++)
{
Console.WriteLine($"Cell {cells[0, i].Name}: Formula = {cells[0, i].Formula}");
}
}
}
}
See Also
- class Cell
- namespace Aspose.Cells
- assembly Aspose.Cells