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

aspose cells formula bug

(0.98 sec)

  1. Cells .NET change/bug 4.0.1.0- 4.0.2.0 - Free S...

    I was going trough some of the projects where I use Aspose Cells today and upgraded the .dll files, but suddenly there was a problem reading a workbook, it “worked” on 4.0.1.0 but not on 4.0.2.0 returning this exception. …...Cells .NET change/bug 4.0.1.0- 4.0.2.0 Aspose.Cells Product Family...the projects where I use Aspose cells today and upgraded the ...

    forum.aspose.com/t/cells-net-change-bug-4-0-1-0...
    more..

  2. 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…...Difference in formula calculations compared to Excel 365 Aspose.Cells...Cells Product Family aspose-cells-java , cells-java m.d.fc February...

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

  3. 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…...Aspose.Cells.CellsException: 'IndexOutOfRangeExcep: Index was...array for simple =SUM() formula Aspose.Cells Product Family mattgabriel...

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

  4. Worksheet.Copy changes the formula refs for ext...

    Hi team, I’m using Aspose.Cells 25.11 and there is an issue when copying worksheet with Formulas like this =‘https://maverickcap.sharepoint.com/sites/Team/Consumer/CELH (Celsius)/7. Other/[Test_09.17.24.xlsx]Test Data’…...changes the formula refs for external addresses Aspose.Cells Product...Product Family cells-net yashar.heydari December 9, 2025, 6:38pm 1...

    forum.aspose.com/t/worksheet-copy-changes-the-f...
    more..

  5. Large LET formula with MAP and FILTER gets stuc...

    Hello, We are using Aspose to calculate Formulas in a workbook and found one Formula that gets stuck trying to calculate. The Formula in question is in Sheet1!A19 and is a large LET Formula that contains multiple FILTE…...Large LET formula with MAP and FILTER gets stuck trying to calculate...calculate Aspose.Cells Product Family cells-net ecarrillo September...

    forum.aspose.com/t/large-let-formula-with-map-a...
    more..

  6. Incorrect formula processing - TOCOL and nested...

    Hi We are evaluating upgrading to the latest version of Aspose Cells to take advantage of the support for newer Excel functions. We have found an issue where the Formula =TOCOL(SIMPLE_TABLE *(100-MULTIPLIERS),TRUE) retur…...Incorrect formula processing - TOCOL and nested array multiplier...multiplier with COLSCAN true Aspose.Cells Product Family LPyrah July...

    forum.aspose.com/t/incorrect-formula-processing...
    more..

  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) { …...BUG: Datavalidation with REGEXTEST does not work Aspose.Cells...Cells Product Family cells-net , net johand13024 January 22, 2025...

    forum.aspose.com/t/bug-datavalidation-with-rege...
    more..

  8. Formulas are not evaluated correctly in 25.8 As...

    Hello Aspose support team, I have an issue with using Aspose Cells for Java, version 25.8 We did not observe that issue in 25.7 You can find 2 files in the attachment, producedByExcel.xlsx: Excel version. Formulas ar…...Formulas are not evaluated correctly in 25.8 Aspose cells version...version Aspose.Cells Product Family AlexBBB October 3, 2025, 2:45pm...

    forum.aspose.com/t/formulas-are-not-evaluated-c...
    more..

  9. IF formula with multiple ISFORMULA within calcu...

    Hello, We are using Aspose to calculate Formulas in a workbook and found one Formula that calculates incorrectly The Formula in question is in Sheet1!M1 and is a large IF Formula that contains multiple ISFormula calls.…...IF formula with multiple ISFORMULA within calculates incorrectly...incorrectly Aspose.Cells Product Family cells-net ecarrillo September...

    forum.aspose.com/t/if-formula-with-multiple-isf...
    more..

  10. Formula text containing local absolute cell ref...

    In copying a particular range of Cells from one workbook to another, I found that Cells with Formula text containing a local absolute cell reference, e.g. =$F$3, do not get adjusted according to the location of the desti…...Formula text containing local absolute cell references is not...between workbooks Aspose.Cells Product Family cells-net bytefyre September...

    forum.aspose.com/t/formula-text-containing-loca...
    more..