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

aspose cells formula bug

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

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

  6. Workbook hangs on calculateformula and RefreshD...

    PFA workbook (9.6 MB) Sample code: var workbook = new Aspose.Cells.Workbook(@"Slow Calc.xlsx"); var options = new CalculationOptions { CustomEngine = null, IgnoreError =…...and RefreshDynamicArrayF Aspose.Cells Product Family Moonglum...code: var workbook = new Aspose.Cells.Workbook(@"Slow Calc.xlsx");...

    forum.aspose.com/t/workbook-hangs-on-calculatef...
    more..

  7. Error Occuring when execution of Aspose convers...

    Dear Aspose Support, We are encountering an issue while trying to convert an XLSX file to HTML using the Aspose.XLSXToHTML operation integrated into our Nuxeo platform. Below i have attached error :point_down: ****** …...execution of Aspose conversion XLSX to HTML Aspose.Cells Product Family...Family words-java , cells-net , cells-java , xlsx-to-html Manish7320...

    forum.aspose.com/t/error-occuring-when-executio...
    more..

  8. Workbook object increases in size when iteratin...

    I have a particular Excel workbook with one worksheet that has a large used range due to a Formula in cell XFD1. When iterating over the used range on this sheet with Aspose, the total size of the workbook noticeably in…...worksheet used range Aspose.Cells Product Family cells-net bytefyre May...large used range due to a formula in cell XFD1. When iterating over...

    forum.aspose.com/t/workbook-object-increases-in...
    more..

  9. Copying a range across workbook which is being ...

    I have two workbooks both with 1 table having 4 columns and 60 rows, I take one table and copy the style and then copy the value to another workbook. then I reference this copied over table entirely in another sheet of t…...causing #ref error Aspose.Cells Product Family cells-net Adhirath July...what ends up happening is the cells which refer this copied over...

    forum.aspose.com/t/copying-a-range-across-workb...
    more..

  10. Totals is not recovering correctly - Free Suppo...

    Hi, We are using table with multiple Totals One of them as Total Row. The others are user created and they are part of the table. We use the mechanism table.ShowTotals = false; and after manipulating the data (includi…...recovering correctly Aspose.Cells Product Family cells-net aleksandr...do table.ShowTotals = true; Formula in input file: =IF(Table2[[#Totals]...

    forum.aspose.com/t/totals-is-not-recovering-cor...
    more..