Sort Score
Result 10 results
Languages All
Labels All
Results 151 - 160 of 3,365 for

workbook formulas

(0.14 sec)
  1. Calculating IFNA function using Aspose.Cells wi...

    How to calculate the IFNA function using the Aspose.Cells library with C++. By loading an existing Excel file or creating a new Excel file, you can use the methods provided by Aspose.Cells to calculate the IFNA function and obtain the result. Finally, you save the modified Excel file to disk....the value you specify if the formula returns the #N/A error value;...returns the result of the formula. Calculating IFNA function...

    docs.aspose.com/cells/cpp/calculating-ifna-func...
  2. Saving Excel as .Docx having an issue with cell...

    When I try to save a excel document having a table with cell values wider than the column width as Docx, it ends up distorting the values in the resulting table. this is the table I am trying to convert to a word table …...saveOptions = new DocxSaveOptions(); workbook.Save(ms, saveOptions); ms...saveOptions = new DocxSaveOptions(); workbook.Save(ms, saveOptions); ms...

    forum.aspose.com/t/saving-excel-as-docx-having-...
  3. Add Cells to Microsoft Excel Formula Watch Wind...

    How to use the Aspose.Cells library to add cells to the formula watch window in Excel using Node.js via C++. By loading an existing Excel file or creating a new one, you can manipulate the cells in it and set Formulas. Finally, you save the modified Excel file to disk....Add Cells to Microsoft Excel Formula Watch Window with Node.js via...watch cell values and their formulas conveniently in a window....

    docs.aspose.com/cells/nodejs-cpp/add-cells-to-m...
  4. How to Lock Cells to Protect Them with C++|Docu...

    This article shows you code explaining how to lock cells to protect them using the Aspose.Cells library with C++....modifying important data or formulas. This is especially useful...protected. Protecting Formulas: Formulas are often crucial for...

    docs.aspose.com/cells/cpp/how-to-lock-cells-to-...
  5. Excel Dynamic Array Formula Issues in XLSX to P...

    Dear Aspose.Cells Support Team, We are encountering a critical issue when converting an XLSX Workbook to PDF using Aspose.Cells. Specifically, several modern Excel dynamic array Formulas, which work correctly in the sou…...Excel Dynamic Array Formula Issues in XLSX to PDF Conversion...issue when converting an XLSX workbook to PDF using Aspose.Cells...

    forum.aspose.com/t/excel-dynamic-array-formula-...
  6. 使用JavaScript通过C++更新Power Query公式项。|Documentation

    学习如何使用Aspose.Cells for JavaScript通过C++在Excel文件中更新Power Query公式项的数据源。...body > < h1 > Power Query Formula Update Example </ h1 > < p...Select the workbook containing Power Query formulas and an optional...

    docs.aspose.com/cells/zh/javascript-cpp/update-...
  7. Setting Shared Formula with JavaScript via C++|...

    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....Setting Shared Formula with JavaScript via C++ Contents [ Hide...JavaScript via C++. Setting Shared Formula using Aspose.Cells for JavaScript...

    docs.aspose.com/cells/javascript-cpp/setting-sh...
  8. Implement Custom Calculation Engine to extend t...

    This article describes how to extend the default calculation engine in JavaScript by implementing a custom calculation engine using the Aspose.Cells library for JavaScript via C++. Load an existing Excel file or create a new one to use the methods provided and save the modified Excel file....all of the Microsoft Excel formulas. Nevertheless, it also allows...is called for all of your formulas. Inside this method, we intercept...

    docs.aspose.com/cells/javascript-cpp/implement-...
  9. Aspose.Cells: copied chart on second worksheet ...

    Subject: Aspose.Cells: copied chart on second worksheet renders incorrectly after manual worksheet normalization without Worksheet.Copy Product: Aspose.Cells for .NET Version: 26.4.0 Environment: .NET 10 Windows …...Scenario: We normalize Excel workbooks before saving them. The normalization...process is intended to: flatten formulas to values and formats unhide...

    forum.aspose.com/t/aspose-cells-copied-chart-on...
  10. How can I prepare large Excel files before zipp...

    I have been working with large Excel files that contain multiple sheets, Formulas, charts, and images. These files are often very heavy and when I try to compress them I worry about losing formatting or breaking Formulas…...that contain multiple sheets, formulas, charts, and images. These...losing formatting or breaking formulas. I have tried cleaning up...

    forum.aspose.com/t/how-can-i-prepare-large-exce...