Search
Sort Score
Result 10 results
Languages All
Labels All
Results 1 - 10 of 33 for

calculateformula error fix

(0.07 sec)

  1. CalculateFormula fails on chained dynamic array...

    Hi, we have a problem with complex dynamic array formulas: Environment Aspose.Cells for .NET: 26.3.0 .NET 9.0, Windows 11 Use case We use Aspose.Cells as a calculation engine for pre-existing Excel templates. The temp…...CalculateFormula fails on chained dynamic array formulas Aspose...designated Input sheet Call CalculateFormula() to recalculate Read...

    forum.aspose.com/t/calculateformula-fails-on-ch...
    more..

  2. CalculateFormula throws an exception - Free Sup...

    I am using Aspose.Cells 25.10.0 .NET 9.0 There is a file that passes Calculateformula in version 25.9 but in version 25.10 Calculateformula throws an exception: System.NullReferenceException: Object reference not set…...CalculateFormula throws an exception Aspose.Cells Product Family...is a file that passes CalculateFormula in version 25.9 but in...

    forum.aspose.com/t/calculateformula-throws-an-e...
    more..

  3. LET function #NAME error - Free Support Forum -...

    We are getting a couple of Errors due to the LET function after calling wb.Calculateformula(ignoreError: true). We are using version 25.9 of Aspose.Cells When using an xlsb workbook format with a LET function and call…...LET function #NAME error Aspose.Cells Product Family tombzenith...We are getting a couple of errors due to the LET function after...

    forum.aspose.com/t/let-function-name-error/319910
    more..

  4. #NAME error when inserting a chart as an image ...

    Hi Aspose Team, I’m having an issue with some charts where I’m inserting it into a word document and one of the footnotes for the chart comes in as #NAME? even though the name range from which it is pulled into the char…...#NAME error when inserting a chart as an image in word document...complete aside from the #NAME ? error. static void TestChartInsertion()...

    forum.aspose.com/t/name-error-when-inserting-a-...
    more..

  5. 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…...5:19pm 1 Hi- I’m getting the error shown in the subject above when...call Workbook.CalculateFormula. The full error says that the...

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

  6. TOCOL formula with same ranges in array calcula...

    Hi! I ran into this issue with the latest aspose.cells version 26.7 where a TOCOL formula in my worksheet calculates into #VALUE! when calling workbook.calculate. It seems to only happen when the first parameter passed …...identical ranges, the CalculateFormula() method incorrectly returns...returns a #VALUE! error instead of the expected flattened array...

    forum.aspose.com/t/tocol-formula-with-same-rang...
    more..

  7. Difference in formula calculations compared to ...

    Hello, I am using Aspose.Cells 25.6 for Java. To calculate formulas in my workbook, I call Workbook.Calculateformula(). I have the following formula: =MATCH(TRUE, ISNUMBER(SEARCH({“JPY”,“KRW”,“CNY”,“BRL”,“EUR”,“GBP”,“U…...calculateFormula(). I have the following...the formula started returning ERROR. The same behavior persists...

    forum.aspose.com/t/difference-in-formula-calcul...
    more..

  8. XLOOKUP returns #VALUE - Free Support Forum - a...

    I am using Aspose.Cells 25.11.0. .NET 9.0 using System.Collections; using Aspose.Cells; var input = @"C:\input-for-aspose.xlsx"; var output = @"C:\output.xlsx"; Workbook? wbc; using (var ms = new FileStream(input, F…...CalculateFormula(opts); engine.SetCellValues(wbc);...SetCellValues(wbc); wbc.CalculateFormula(opts); wbc.Save(output); }...

    forum.aspose.com/t/xlookup-returns-value/322497
    more..

  9. 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…...RefreshDynamicArrayF and CalculateFormula Spill function does not...RefreshDynamicArrayF(true, opts); wbc.CalculateFormula(opts); wbc.Save(output);...

    forum.aspose.com/t/spill-function-is-not-updati...
    more..

  10. FAQ|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....FAQ Contents [ Hide ] How to Fix the System.StackOverflowExcepti...StackOverflowExcepti on Workbook.CalculateFormula? Sometimes, users face System...

    docs.aspose.com/cells/net/faq/
    more..