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

aspose cells formula bug

(0.79 sec)

  1. 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..

  2. 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..

  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. 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..

  5. 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..

  6. 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..

  7. 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..

  8. 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…...Cells.importdata is failing if there is invalid formula Aspose...Aspose.Cells Product Family Balaji04 June 13, 2025, 3:01pm 1 Hi Team...

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

  9. ImportData method overwriting the formula in la...

    AsposeBug.zip (14.2 KB) Hi, I am using Aspose.Cells for .Net and facing 1 weird issue wherein when I import data to an existing workbook using the ImportData method its overwriting Formula in the last column of first r…...overwriting the formula in last column Aspose.Cells Product Family...(14.2 KB) Hi, I am using Aspose.Cells for .Net and facing 1 weird...

    forum.aspose.com/t/importdata-method-overwritin...
    more..

  10. Aspose.Cells fail to fetch GetRangeByName when ...

    Hi team, In newer versions of Aspose if a Name.RefersTo has something like =INDIRECT(ADDRESS(1,1,INDIRECT(“B1”))) then, Worksheets.GetRangeByName throws Exception. I’m using Aspose 25.3.0, This wasn’t happening in pre…...Aspose.Cells fail to fetch GetRangeByName when range is a formula...formula Aspose.Cells Product Family cells-net yashar.heydari October...

    forum.aspose.com/t/aspose-cells-fail-to-fetch-g...
    more..