Sort Score
Result 10 results
Languages All
Labels All
Results 501 - 510 of 5,643 for

formula

(0.85 sec)
  1. Returning a Range of Values using AbstractCalcu...

    This article introduces an abstract calculation engine that returns a range of values in Microsoft Excel using 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 get a range of values and return the result. Finally, we save the modified Excel file to disk....Add Cells to Microsoft Excel Formula Watch Window Analyzing your...

    docs.aspose.com/cells/net/returning-a-range-of-...
  2. Detecting Empty Worksheets with C++|Documentation

    This article shows you code explaining how to detect empty worksheets of Excel workbooks programmatically using C++ API with Aspose.Cells library....numeric, date/time) or a formula or a formula‑based value. In such...

    docs.aspose.com/cells/cpp/detecting-empty-works...
  3. 设置共享公式(用 C++)|Documentation

    学习如何在 Excel 工作表中用 Aspose.Cells 设置共享公式,使用 C++。...GetCells (); // Apply the shared formula in the range i.e.., B2:B14...); std :: cout << "Shared formula applied and file saved successfully...

    docs.aspose.com/cells/zh/cpp/setting-shared-for...
  4. 使用 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...
  5. 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...
  6. Excel Specifications and Limits|Documentation

    In this article, find all workbook, worksheet, and feature specifications and limits. In Excel 2010, the maximum worksheet size is 1,048,576 rows by 16,384 columns....allowed positive number via formula 1.7976931348623158e+308 Largest...number via formula -1.7976931348623158e+308 Length of formula contents...

    docs.aspose.com/cells/net/excel-specifications-...
  7. #NAME error when inserting a chart as an image ...

    Hi Aspose Team, I’m having an issue with some charts where I’m inserting it into a word document and one of the footnotes for the chart comes in as #NAME? even though the name range from which it is pulled into the char…...what Excel returns when a formula refers to a name that cannot...box (or footnote) contains a formula like =MyFootnote , the rendering...

    forum.aspose.com/t/name-error-when-inserting-a-...
  8. Filter objects while loading workbook in GridDe...

    This article describes how to use loading filter in GridDesktop....DefinedNames DocumentProperties Formula Hyperlinks MergedArea PivotTable...

    docs.aspose.com/cells/net/aspose-cells-griddesk...
  9. 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...
  10. 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...