Hi,

Thanks for considering Aspose.

Well, you may call Workbook.CalculateFormula() method and replace the cell's value with the formula string by inputing the calculated value.

May the following code help you for you need, kindly consult it. In the example, suppose we have two formulated cell in the first worksheet i.e., A10 and G1, I will remove the formulas on those cells and input the calculated values only.

Workbook workbook = new Workbook();

workbook.Open("d:\\test\\bkform.xls");

Worksheet worksheet = workbook.Worksheets[0];

Cells cells = worksheet.Cells;

//First Calculate all the formulas.

workbook.CalculateFormula(false);

//Get the formulated cell.

Cell cell1 = cells["A10"];

//Replace by the calculated value, the formula of the cell

//will be eliminated.

cell1.PutValue(cell1.IntValue);

//Get the formulated cell.

Cell cell2 = cells["G1"];

//Replace by the calculated value, the formula of the cell

//will be eliminated.

cell2.PutValue(cell2.StringValue);

workbook.Save("d:\\test\\bkform1.xls");

Thank you.