Search
Sort Score
Result 10 results
Languages All
Labels All
Results 111 - 120 of 3,355 for

workbook formulas

(0.27 sec)

  1. Check if Workbook contains hidden External Link...

    Learn how to check if a Workbook contains hidden external links using Aspose.Cells for JavaScript via C++....Check if Workbook contains hidden External Links with JavaScript...Usage Scenarios Sometimes, the workbook contains external links that...

    docs.aspose.com/cells/javascript-cpp/check-if-w...
    more..

  2. Workbook object increases in size when iteratin...

    I have a particular Excel Workbook with one worksheet that has a large used range due to a formula in cell XFD1. When iterating over the used range on this sheet with Aspose, the total size of the Workbook noticeably in…...Workbook object increases in size when iterating over worksheet...I have a particular Excel workbook with one worksheet that has...

    forum.aspose.com/t/workbook-object-increases-in...
    more..

  3. New formula STOCKHISTORY caused NullReferenceEx...

    New formula STOCKHISTORY caused NullReferenceException when saving Workbook to Xlsb format using Aspose.Cells .Net v26.2. The saved Xlsb file was corrupted. No issue with Xlsx and Xlsm formats. See attached sample files…...New formula STOCKHISTORY caused NullReferenceExcepti when saving...saving workbook to Xlsb format Aspose.Cells Product Family cells-net...

    forum.aspose.com/t/new-formula-stockhistory-cau...
    more..

  4. How to Copy Excel Sheet to Another Workbook in ...

    In this short tutorial you will learn how to copy Excel sheet to another Workbook in Java. It contains the steps and code snippet explaining Java Excel sheet copy feature in any operating system like Windows, Linux, or macOS....Copy Excel Sheet to Another Workbook in Java This concise tutorial...copy Excel sheet to another workbook in Java . You can load the...

    kb.aspose.com/cells/java/how-to-copy-excel-shee...
    more..

  5. Custom Number format using Arabic Locale is ign...

    When a custom number format uses the [$-XXXX] syntax in a worksheet, it is ignored when the Workbook is converted to HTML. Specifically, when the custom number format is “[$-,200]0”, the numbers appear as Eastern Arabic …...is ignored when converting Workbook to HTML Aspose.Cells Product...worksheet, it is ignored when the workbook is converted to HTML. Specifically...

    forum.aspose.com/t/custom-number-format-using-a...
    more..

  6. Cells.importdata is failing if there is invalid...

    Hi Team, We are trying to skip the next cells if the error in formula. Below is the code we are trying. Is there an option to skip to next cell if error occurs // Create a new Workbook Workbook Workbook1 = new Workboo…...failing if there is invalid formula Aspose.Cells Product Family...next cells if the error in formula. Below is the code we are trying...

    forum.aspose.com/t/cells-importdata-is-failing-...
    more..

  7. Advanced Formula Calculation|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 Advanced Formula Calculation Contents [ Hide ] Two types...types of formulas are supported Reporting Services formulas – evaluated...

    docs.aspose.com/cells/reportingservices/advance...
    more..

  8. Aspose cells for java 解析包含大量带状行样式的Excel文件时，构造Wo...

    在加载一个带有大量“带状行样式”（banded rows）的Excel文件时，调用 Workbook 构造方法时触发 java.lang.OutOfMemoryError ，导致程序崩溃。具体位置为 Workbook wbk = new Workbook(formatFile.getLocalFile()); 。 JDK：17 aspose-cells：21.11 已试过26.4版本 该问题仍存在 JVM堆内存设置：-Xms32g…...java 解析包含大量带状行样式的Excel文件时，构造Workbook对象抛出OOM异常 中文技术支持 aspose-cells-java...在加载一个带有大量“带状行样式”（banded rows）的Excel文件时，调用 Workbook 构造方法时触发 java.lang.OutOfMemoryError...

    forum.aspose.com/t/aspose-cells-for-java-excel-...
    more..

  9. Aspose.Cells.CellsException: 'IndexOutOfRangeEx...

    Hi- I’m getting the error shown in the subject above when trying to call Workbook.CalculateFormula. The full error says that the issue is “Based on cell Data!B2366” in the Workbook I will provide. The formula in this cel…...the array for simple =SUM() formula Aspose.Cells Product Family...above when trying to call Workbook.CalculateFormula. The full...

    forum.aspose.com/t/aspose-cells-cellsexception-...
    more..

  10. Excel sheet takes a long time (7 seconds) for w...

    Would love to know what’s taking the time. Attempting to reproduce this with Java 21 in Windows the calculation takes a little over a second. Maybe a little long but reasonable. On Linux this extends to 7 seconds, which …...long time (7 seconds) for workbook.calculateFormula() in Linux...performance difference when using workbook.calculateFormula() on Linux...

    forum.aspose.com/t/excel-sheet-takes-a-long-tim...
    more..