Sort Score
Result 10 results
Languages All
Labels All
Results 481 - 490 of 5,514 for

formula

(0.24 sec)
  1. BUG: Datavalidation with REGEXTEST does not wor...

    I’m creating a Excel with .NET and trying to add a datavalidation to check if a cell value is an URL. Consider the following code: public void AddDataValidation(CellArea cellArea, Column column, Worksheet worksheet) { …... Formula Syntax : Double-check the syntax...syntax of your formula. While your regex appears to be correct...

    forum.aspose.com/t/bug-datavalidation-with-rege...
  2. 1. Simple formulas

    This article discusses how to create simple atomic math expressions for more complex Formulas with TeX and LaTeX....LaTeX Typesetting math formulas Simple formulas Live Demos Source...Pricing Buy 1. Simple formulas The simplest formula is a single letter...

    docs.aspose.com/tex/java/latex-math-simple-form...
  3. 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...
  4. Tracing Precedents and Dependents in Excel usin...

    This article guides for tracing precedents and dependents in Excel using Java. It explains how to find Excel cell reference using Java in other cells....class and set sample data and formulas in different cells Access...setting some sample data and formulas referring to other cells in...

    kb.aspose.com/cells/java/tracing-precedents-and...
  5. 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 you to add custom formula calculation functions to extend...reference corresponding with the formula’s position, you can use the...

    docs.aspose.com/cells/net/how-to-calculate-cust...
  6. 使用 JavaScript via C++ 计算数据表的数组公式|Documentation

    如何使用 Aspose.Cells 库通过 JavaScript 和 C++ 计算 Microsoft Excel 中数据表的数组公式。加载或创建 Excel 文件,计算数组公式,然后保存修改后的文件。...putValue ( 100 ); // Calculate formula, now it also calculates Data...Data Table array formula workbook . calculateFormula (); // Save...

    docs.aspose.com/cells/zh/javascript-cpp/calcula...
  7. Adding Table Footers|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....markers, Reporting Services formulas, and so on. Here, we’ve added...cell and a Reporting Services formula cell. The completed footer...

    docs.aspose.com/cells/reportingservices/adding-...
  8. 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...
  9. 使用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...
  10. Find or Search Data|Documentation

    Learn how to find or search cells in a worksheet that contains specified data through the Aspose.Cells for Python via .NET API....Containing a Formula Developers can find a specified formula in the...find methods: Finding Data or Formulas using FindOptions It is possible...

    docs.aspose.com/cells/python-net/find-or-search...