Sort Score
Result 10 results
Languages All
Labels All
Results 331 - 340 of 3,359 for

workbook formulas

(0.15 sec)
  1. 通过 C++ 在 Node.js 中为命名区域设置公式|Documentation

    学习如何使用 Aspose.Cells for Node.js via C++ 为电子表格中的命名区域设置公式。...instance of Workbook const book = new AsposeCells . Workbook (); //...of the Named Range to a formula. Formula references another cell...

    docs.aspose.com/cells/zh/nodejs-cpp/setting-for...
  2. Calculating IFNA function using Aspose.Cells fo...

    How to calculate the IFNA function using the Aspose.Cells library for JavaScript via C++. Load an existing Excel file or create a new one, calculate the IFNA function to get the result, and finally 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 the IFNA function...

    docs.aspose.com/cells/javascript-cpp/calculatin...
  3. Copy and Move Worksheets Within and Between Wor...

    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....Worksheets Within and Between Workbooks Contents [ Hide ] Sometimes...you might want to create a workbook with sheets that contain the...

    docs.aspose.com/cells/net/copy-and-move-workshe...
  4. Convert XLS File with Images or Charts to PDF w...

    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...."text/javascript" > const { Workbook , SaveFormat , Utils } = AsposeCells...arrayBuffer (); // Instantiating a Workbook object by opening the Excel...

    docs.aspose.com/cells/javascript-cpp/convert-xl...
  5. Update references in other worksheets while del...

    Learn how to maintain references in other worksheets when deleting blank columns and rows in a worksheet using Aspose.Cells for Node.js via C++....the second worksheet has a formula =Sheet1!C3 which refers to...getUpdateReference() property to true , this formula will be updated and become...

    docs.aspose.com/cells/nodejs-cpp/update-referen...
  6. Save Specified Worksheets to PDF|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....all visible worksheets in a workbook to a PDF file. With the PdfSaveOptions...indicates visible sheets in a workbook, and SheetSet.All indicates...

    docs.aspose.com/cells/java/save-specified-works...
  7. 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) { …...Workbook.Settings.MaxRow, StartColumn...not recognize this function. Formula Syntax : Double-check the syntax...

    forum.aspose.com/t/bug-datavalidation-with-rege...
  8. Spill function is not updating - Free Support F...

    Dear Aspose Team, I am using Aspose.Cells 25.11.0. .NET 9.0 We have Spill Function includes LET with XLOOKUP and run RefreshDynamicArrayFormulas and CalculateFormula Spill function does not update correctly. If I s…...xlsx"; Workbook? wbc; using (var ms = new...FileMode.Open)) wbc = new Workbook(ms, new LoadOptions(LoadFormat...

    forum.aspose.com/t/spill-function-is-not-updati...
  9. About HtmlSaveOptions.setExcludeUnusedStyles(tr...

    When using Aspose.Cells 20.12 to convert Excel to HTML, if excludeUnusedStyles is set to true, the content of cells D3 and E3 might all turn black. Upon checking the browser console, it was found that the CSS style corr…...code like this: Workbook workbook = new Workbook("test.xlsx");...HiddenRowDisplay.HIDDEN); workbook.save("test.html", options);...

    forum.aspose.com/t/about-htmlsaveoptions-setexc...
  10. Java Excel API | products.aspose.com

    Aspose.Cells for Java library to create, repair, merge, parse and convert excel files. Convert excel to PDF, JSON, CSV, HTML and so on....& calculate complex formulas using formula calculation engine...Formatting Create Charts Apply Formulas Summarize Smart Markers Supports...

    products.aspose.com/cells/java/