Search
Sort Score
Result 10 results
Languages All
Labels All
Results 11 - 20 of 62 for

aspose cells formula bug

(0.69 sec)

  1. Aspose.Cells - Failure to recognize complex for...

    Hi, We have an engine where we simply want to get the values for custom Formulas, but the Formula isn’t recognized as a custom function. Formula that works: =IF(AND(B$1=“STUFF”, TESTCUSTOM(FinalAmount)>0), TESTCUSTO…...Aspose.Cells - Failure to recognize complex formula containing...custom functions Aspose.Cells Product Family cells-net oded.b December...

    forum.aspose.com/t/aspose-cells-failure-to-reco...
    more..

  2. 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…...Array Formula Issues in XLSX to PDF Conversion (Aspose.Cells for...for Java 22.12) Aspose.Cells Product Family cells-java kiran.karki...

    forum.aspose.com/t/excel-dynamic-array-formula-...
    more..

  3. Aspose Cells - Pivot Table - Sum not updated - ...

    Good Morning, I have a template Excel file with a pivot table. When I refresh it in Excel, the data are correct. However, when I refresh it in Aspose Cells, the percent column does not refresh. It is a Value Field with S…...Aspose Cells - Pivot Table - Sum not updated Aspose.Cells Product...excel-pivot-table , pivot-table , cells-net , refresh-pivot-table damienrcds...

    forum.aspose.com/t/aspose-cells-pivot-table-sum...
    more..

  4. Behavior Change in Workbook.CalculateFormula(tr...

    After upgrading Aspose Cells from version 17.12 to 25.5, we encountered an issue: In version 17.12, calling workbook.CalculateFormula(true), correctly calculated the Formula and stored the resulting value in cell N23, b…...After Aspose.Cells Upgrade (v17.12 → v25.5) Aspose.Cells Product...Product Family cells-net Rit3sh December 15, 2025, 10:19am 1 After...

    forum.aspose.com/t/behavior-change-in-workbook-...
    more..

  5. 3-D refererence formulas are corrupted if sheet...

    Hi, We have a workbook with 3-D reference Formulas defined like ‘=SUM(‘Sheet2:Sheet 3’!A1:A4)’. If there is a space in sheet name the result will be #REF! and the Formula will be corrupted after saving using the library…...3-D refererence formulas are corrupted if sheet name contains...contains a space Aspose.Cells Product Family cells-net wwu January 16...

    forum.aspose.com/t/3-d-refererence-formulas-are...
    more..

  6. Workbook.CalculateFormula is very time consumin...

    Workbook wb = new Workbook(@“Test.xlsx”); Stopwatch sw = Stopwatch.StartNew(); wb.CalculateFormula(); Console.WriteLine($“{sw.ElapsedMilliseconds}ms”); It will take about 1 minite to calculate Formula. Test.7z (556.…...non-existing external links, maybe) Aspose.Cells Product Family cnbjw August...about 1 minite to calculate formula. Test.7z (556.0 KB) Professionalize...

    forum.aspose.com/t/workbook-calculateformula-is...
    more..

  7. InsertCutCells does not keep format condition f...

    When using InsertCutCells, I’m finding that the format condition Formulas are not staying relative to the Cells using them. Here is my example code: using Aspose.Cells; Workbook srcWorkbook = new(@"C:\Swift\Templates\…...condition formulas relative to new cell locations Aspose.Cells Product...condition formulas are not staying relative to the cells using them...

    forum.aspose.com/t/insertcutcells-does-not-keep...
    more..

  8. Calculation results differ from Excel 365 - Fre...

    Hi, Using Aspose Cells for Java, version 25.7. Sample code: Workbook workbook = new Workbook("iferror.xlsx"); WorksheetCollection worksheets = workbook.getWorksheets(); Worksheet worksheet = worksheets.get("S1-8.2 - T…...from Excel 365 Aspose.Cells Product Family cells-java TarasTielkes...2025, 2:54pm 1 Hi, Using Aspose Cells for Java, version 25.7....

    forum.aspose.com/t/calculation-results-differ-f...
    more..

  9. Spreadsheet Editor Getting Started|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....features, including cell editing, formatting, formula editing, row and...Editor uses many features of Aspose.Cells for Java and shows how to...

    docs.aspose.com/cells/java/spreadsheet-editor-g...
    more..

  10. PowerQueryFormulaItems missing in function with...

    In Aspose.Cells for .NET version 25.4.0 I found the following problem for the PowerQueryFormulaItems of a function. When a file contains a power query function with a nested let like so: let Source = {"banana", "ap…...a nested let Aspose.Cells Product Family cells-net perfectxl...March 9, 2026, 1:41pm 1 In Aspose.Cells for .NET version 25.4.0...

    forum.aspose.com/t/powerqueryformulaitems-missi...
    more..