Search
Sort Score
Result 10 results
Languages All
Labels All
Results 521 - 530 of 5,764 for

formula

(0.34 sec)

  1. Direct Calculation of Custom Function without W...

    This article introduces how to use Aspose.Cells library to directly calculate custom functions in Microsoft Excel without writing the function in a worksheet. By loading an existing Excel file or creating a new Excel file, we can use the methods provided by Aspose.Cells to calculate the custom function and get the result. Finally, we save the modified Excel file to disk....Worksheet::CalculateFormula(System::String formula, CalculationOptions opts) method...) override { // Check the formula name and calculate it yourself...

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

  2. 使用Node.js通过C++将单元格添加到Microsoft Excel公式监视窗口的方法|D...

    如何使用 Aspose.Cells 库通过 Node.js 和 C++ 向 Excel 的公式监视窗口添加单元格。通过加载已有的 Excel 文件或创建新文件，我们可以对其中的单元格进行操作并设置公式。最后，将修改后的 Excel 文件保存到磁盘。...Access cell C1 and set its formula. const c1 = ws . getCells ()...Access cell E1 and set its formula. const e1 = ws . getCells ()...

    docs.aspose.com/cells/zh/nodejs-cpp/add-cells-t...
    more..

  3. Aspose.Cells 8.7.1 中的公共 API 更改|Documentation

    Class Libraries & REST APIs for the developers to manipulate & process Files from Word, Excel, PowerPoint, Visio, PDF, CAD & several other categories in Web, Desktop or Mobile apps. Develop & deploy on Windows, Linux, MacOS & Android platforms....putValue ( 10 ); //Add Sum formula in cell D4 but customize it...( style ); //The result of formula will be 20 //but 20 will not...

    docs.aspose.com/cells/zh/java/public-api-change...
    more..

  4. Aspose.Cells.GridJs Basics|Documentation

    Class Libraries & REST APIs for the developers to manipulate & process Files from Word, Excel, PowerPoint, Visio, PDF, CAD & several other categories in Web, Desktop or Mobile apps. Develop & deploy on Windows, Linux, MacOS & Android platforms....spreadsheets with real‑time updates, formula support, and rich data‑visualization...Format, Spreadsheet Navigation, Formula Calculation, Data Manipulation...

    docs.aspose.com/cells/python-net/aspose-cells-g...
    more..

  5. Working with Cells|Documentation

    This article introduces the use of cell-related APIs in GridDesktop....the Value of a Cell Adding Formula to Cell Change Font and Color...

    docs.aspose.com/cells/net/aspose-cells-griddesk...
    more..

  6. Create Dynamic Charts with JavaScript via C++|D...

    Learn how to create dynamic charts in Aspose.Cells for JavaScript via C++. This guide will show you how to dynamically update chart data, series, and formatting based on your requirements, allowing you to present changing data visually in your worksheets....> </ html > Using Dynamic Formulas If you do not wish to use...is to use Excel functions (formulas) to create a dynamic range...

    docs.aspose.com/cells/javascript-cpp/create-dyn...
    more..

  7. Using ICustomFunction Feature|Documentation

    This article describes how to create a custom function in Microsoft Excel using the ICustomFunction feature in the Aspose.Cells library. By loading an existing Excel file or creating a new Excel file, we can use the methods provided by Aspose.Cells to define and register custom functions and get the results. Finally, we save the modified Excel file to disk....interface allows to add custom formula calculation functions to extend...reference corresponding with the formula’s position, you can use ReferredArea...

    docs.aspose.com/cells/net/how-to-calculate-cust...
    more..

  8. CellsException: Invalid shift option with inser...

    When I use the insertCutCells method exactly as outlined here and I provide the ShiftType.NONE option, I always get the error: com.aspose.cells.CellsException: Invalid shift option. I want to do a cut, but not insert t…...work for us because of the formula cell reference behavior. The...updating of dependent formulas and formulas in the target moved...

    forum.aspose.com/t/cellsexception-invalid-shift...
    more..

  9. Support for German Locale in Named Range Formul...

    Class Libraries & REST APIs for the developers to manipulate & process Files from Word, Excel, PowerPoint, Visio, PDF, CAD & several other categories in Web, Desktop or Mobile apps. Develop & deploy on Windows, Linux, MacOS & Android platforms....Named Range Formulae Contents [ Hide ] English formulas are written...locale; however, the English formula will be translated into German...

    docs.aspose.com/cells/net/support-for-german-lo...
    more..

  10. 2. Subscript and subscript in LaTeX

    This article discusses how to build math Formulas that contain subscripts and superscripts with TeX and LaTeX....on LaTeX Typesetting math formulas Subscript and subscript Live...instance, in the chemical formula for water, H₂O , the 2 is a...

    docs.aspose.com/tex/java/latex-math-subscripts-...
    more..