Sort Score
Result 10 results
Languages All
Labels All
Results 511 - 520 of 5,746 for

formula

(0.14 sec)
  1. 5115550.xlsx

    Sheet1 80 << Must be a whole number from 0 to 100 70.33 << Must be a whole or decimal number from 0 to 100 99 <Formula "=a3<100" Sheet2 Sheet3 2016-05-29T10:22:06Z 15.0300 U01581......100 99 <<Custom validation formula "=a3<100" Sheet2 Sheet3 2016-05-29T10:22:06Z...

    docs.aspose.com/cells/tr/net/aspose-cells-gridd...
  2. 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...
  3. 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...
  4. 使用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...
  5. How to Format Number to Time with C++|Documenta...

    This article will introduce how to format numbers to time using Aspose.Cells for C++ API....you can use the following formula to convert it to a time: =TIME(LEFT(A1...might need a slightly adjusted formula to handle the variability in...

    docs.aspose.com/cells/cpp/how-to-format-number-...
  6. 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...
  7. Find or Search Data|Documentation

    Learn how to find or search cells in a worksheet that contains specified data through the Aspose.Cells for Node.js via C++ 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/nodejs-cpp/find-or-search...
  8. Fields Overview in C#|Aspose.Words for .NET

    Fields feature in details, field codes and field results explained in Aspose.Words for .NET....Words: = (formula) ADDRESSBLOCK ASK AUTHOR AUTONUM...across multiple paragraphs Formula Fields Aspose.Words provides...

    docs.aspose.com/words/net/fields-overview/
  9. 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...
  10. 在使用C++的JavaScript中自动在表格或列表对象中输入新行时传播公式|Document...

    学习如何在使用C++的JavaScript中使用模板在输入新行时自动传播表格或列表对象中的公式...formula 属性。 ** 自动在新行输入时传播表格或列表对象中的公式**...displayName = "Table" ; // Set the formula of second column so that it...

    docs.aspose.com/cells/zh/javascript-cpp/propaga...