Search
Sort Score
Result 10 results
Languages All
Labels All
Results 411 - 420 of 5,558 for

formula

(0.07 sec)

  1. Apply Shading to Alternate Rows and Columns wit...

    How to use the Aspose.Cells library in Python to apply conditional formatting shading for alternating rows and columns. By adjusting these criteria, you have more control over how cells look....you have to do is change the formula =MOD(ROW(),2)=0 to =MOD(COLUMN()...the row index, modify the formula to retrieve the column index...

    docs.aspose.com/cells/python-net/apply-shading-...
    more..

  2. 用C++更新Power Query公式项|Documentation

    学习如何使用Aspose.Cells for C++更新Power Query公式项，以修改Excel文件中的数据源文件位置。...++ i ) { PowerQueryFormula formula = powerQueryFormulas . Get...PowerQueryFormulaIte powerQueryFormulaIte = formula . GetPowerQueryFormula ();...

    docs.aspose.com/cells/zh/cpp/update-power-query...
    more..

  3. 用C++计算数据表的数组公式|Documentation

    如何使用Aspose.Cells库在Microsoft Excel中用C++计算数据表的数组公式。通过加载现有Excel文件或创建新Excel文件，利用Aspose.Cells提供的方法计算数组公式并获取结果。最后保存修改后的Excel文件。...PutValue ( 100 ); // Calculate formula, now it also calculates Data...Data Table array formula workbook . CalculateFormula (); // Save...

    docs.aspose.com/cells/zh/cpp/calculation-of-arr...
    more..

  4. 使用 AbstractCalculationEngine 和 Node.js via C++ ...

    本文介绍了使用 Node.js via C++ 的 Aspose.Cells 库实现返回 Excel 中一系列值的抽象计算引擎。学习如何加载或创建 Excel 文件并将修改后的文件保存到磁盘。... getCells (); // Set formula const cell = cells . get (...Set calculation options for formula const calculationOptions =...

    docs.aspose.com/cells/zh/nodejs-cpp/returning-a...
    more..

  5. Set External Links in Formulas|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....Ask AI Set External Links in Formulas Contents [ Hide ] Sometimes...links to external files in formulas, for example, to evaluate...

    docs.aspose.com/cells/python-net/set-external-l...
    more..

  6. GroupBy Excel function - Free Support Forum - a...

    Is it on the roadmap to support the Excel groupby function? Please add. Thanks, Dean...summary of your data via a formula. Thanks, Dean Professionalize...@Moonglum , Aspose.Cells’ formula calculation engine have not...

    forum.aspose.com/t/groupby-excel-function/315022
    more..

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

    Learn how to handle named range Formulae in German locale using Aspose.Cells with Golang via C++....German Locale in Named Range Formulae with Golang via C++ Contents...Contents [ Hide ] English formulae are written into named regions...

    docs.aspose.com/cells/go-cpp/support-for-german...
    more..

  8. How to Insert Tick Symbol|Documentation

    This article will introduce how to insert a tick symbol using the Aspose.Cells for .NET API....Conditional Formatting with a Formula You can create automatic tick...with formulas and conditional formatting: Enter a formula like:...

    docs.aspose.com/cells/net/how-to-insert-tick-sy...
    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 formulae are written...Locale however the English formula shall be translated to the...

    docs.aspose.com/cells/java/support-for-german-l...
    more..

  10. Add calculated field in Pivot Table with C++|Do...

    How to add a calculated field in pivot table with Aspose.Cells for C++....and set the corresponding formula for calculation, then perform...field. In the Formula field, enter the formula for the calculation...

    docs.aspose.com/cells/cpp/add-calculated-field-...
    more..