Search
Sort Score
Result 10 results
Languages All
Labels All
Results 291 - 300 of 5,799 for

formula

(2.02 sec)

  1. Use Error Checking Options with C++|Documentation

    In this article, you will find sample code that will programmatically use error checking options of Excel worksheets e.g. Numbers stored as Text using C++ API or Library....error checks when creating formulas, a small triangle at the top...Errors that mean that the formula cannot return a result — such...

    docs.aspose.com/cells/cpp/use-error-checking-op...
    more..

  2. How to Update Excel File in Java

    In this step-by-step tutorial we will learn how to update Excel file in Java using a simple code. This code can be executed in many operating systems supporting Java like Windows, macOS and Linux....in second sheet and update formula in the cell Call calculateFormula...calculateFormula function as formula is changed Save the updated file...

    kb.aspose.com/cells/java/how-to-update-excel-fi...
    more..

  3. Apply Conditional Formatting in Worksheets|Docu...

    How to use Aspose.Cells library in C# to apply conditional formatting in worksheets. By adjusting these criteria, you have more control over how cells look and appear....the value of the cell or a formula. For example, the background...Conditional Formatting Based on Formula Applying conditional formatting...

    docs.aspose.com/cells/net/apply-conditional-for...
    more..

  4. Search Data using Original Values|Documentation

    Learn how to Search Data using Original Values through the Aspose.Cells for JavaScript via C++ API....example, suppose cell D4 has formula =Sum(A1:A2) and its value is...). value = 10 ; // Add Sum formula in cell D4 but customize it...

    docs.aspose.com/cells/javascript-cpp/search-dat...
    more..

  5. 用JavaScript通过C++指定共享公式的最大行数|Documentation

    学习如何使用C++的JavaScript指定共享公式的最大行数。...Specify Maximum Rows Of Shared Formula Example </ title > </ head...Specify Maximum Rows Of Shared Formula Example </ h1 > < input type...

    docs.aspose.com/cells/zh/javascript-cpp/specify...
    more..

  6. What's new in Aspose.Cells for .NET|Documentation

    Aspose.Cells for .NET expands and enhances daily. On this page, you can learn about the huge and most interesting features of the product....from another workbook Shift formulas after insert cut ranges Support...some advanced functions in formula for XLSB Support to parse legend...

    docs.aspose.com/cells/net/what-s-new-in-aspose-...
    more..

  7. 使用FormulaText函数在Aspose.Cells与C++中|Documentation

    本文介绍了如何使用Aspose.Cells库中的FormulaText函数处理Microsoft Excel中的公式。通过加载现有的Excel文件或创建新的Excel文件，我们可以使用Aspose.Cells提供的方法获取和设置单元格的公式文本并获取结果。最后，我们将修改后的Excel文件保存到磁盘。... Get ( 0 ); // Put some formula in cell A1 Cell cellA1 = worksheet...); // Get the text of the formula in cell A2 using FORMULATEXT...

    docs.aspose.com/cells/zh/cpp/using-formulatext-...
    more..

  8. 使用 C++ 通过 Script 计算 IFNA 函数 Aspose.Cells for Ja...

    如何使用 Aspose.Cells 库通过 C++ 的 JavaScript 计算 IFNA 函数。加载现有 Excel 文件或创建新文件，并计算 IFNA 函数以获取结果。最后保存修改后的 Excel 文件到磁盘。...Assign IFNA formula to A5 and A6 cellA5 . formula = '=IFNA(VLOOKUP("Pear"...0),"Not found")' ; cellA6 . formula = '=IFNA(VLOOKUP("Orange",$A$1:$A$3...

    docs.aspose.com/cells/zh/javascript-cpp/calcula...
    more..

  9. Calculation of Excel 2016 MINIFS and MAXIFS fun...

    This article introduces how to use the Aspose.Cells library to calculate MINIFS and MAXIFS functions in Microsoft Excel 2016 using C++....CalculateFormula() method to perform the formula calculation via Aspose.Cells...); // Perform Aspose.Cells formula calculation workbook . CalculateFormula...

    docs.aspose.com/cells/cpp/calculation-of-excel-...
    more..

  10. Working with Formulas | Aspose.Tasks Documentation

    Learn how to create, modify and save Formulas in Microsoft Project MPP files using Aspose.Tasks for .NET....Developer Guide Working with Formulas Live Demos High Code APIs...Working with Formulas Contents [ Hide Show ] Formulas in Microsoft...

    docs.aspose.com/tasks/net/working-with-formulas/
    more..