// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/ namespace Aspose.Cells.Cloud.SDK.Example { using Aspose.Cells.Cloud.SDK.Api; using Aspose.Cells.Cloud.SDK.Request; using System; public partial class CellsApiExample { public void PostWorkbookCalculateFormulaExample() { CellsApi cellsApi = new CellsApi(Environment.GetEnvironmentVariable("CellsCloudTestClientId"), Environment.GetEnvironmentVariable("CellsCloudTestClientSecret")); PostWorkbookCalculateFormulaRequest request = new PostWorkbookCalculateFormulaRequest { name = "Book1.xlsx", options = new Model.CalculationOptions { IgnoreError = true, Recursive = true}, folder = "TestData/In" }; cellsApi.PostWorkbookCalculateFormula(request); } } } // Obsolete //CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration()); //string name = "Book1.xlsx"; //CalculationOptions options = new CalculationOptions(); //options.IgnoreError = true; //bool? ignoreError = true; //string folder = null; //UpdateDataFile(folder, name); //var response = instance.CellsWorkbookPostWorkbookCalculateFormula(name, options, ignoreError, folder);