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

aspose cells formula bug

(0.17 sec)

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

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

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

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

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

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

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

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

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