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

aspose cells formula bug

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

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

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

  6. ListObject with calculated column creates inval...

    Hello, An invalid Excel file is generated using this example from the documentation located at: Propagate Formula in Table or List Object automatically while entering data in new rows|Documentation When you open the fi…...creates invalid Excel file Aspose.Cells Product Family weissa April...documentation located at: Propagate Formula in Table or List Object automatically...

    forum.aspose.com/t/listobject-with-calculated-c...
    more..

  7. Issue converting XLSX and XLSM files containing...

    We are converting XLSX and XLSM files to PDFs using the following code. static public string ConvertExcel(string inputFilePath = "", string outputFilePath = "") { string results = "SUCCESS"; try …...TextBox's into PDF Aspose.Cells Product Family cells-net david_j_meyer2_boeing_com...th); Aspose-Textbox-issue-example.pdf (88.5 KB) Aspose-Textbox-issue-example...

    forum.aspose.com/t/issue-converting-xlsx-and-xl...
    more..

  8. Pivot table refresh problems (filter, col width...

    See attached sample: I call “Worksheet.RefreshPivotTables()”, which brings three problems: AsposeCellsPivot.zip (26.3 KB) Problem 1 In the source file, the filter for cell B6 is set to single select. After applying “R…...col width, localization) Aspose.Cells Product Family wknauf May...source file, the filter for cell B6 is set to single select....

    forum.aspose.com/t/pivot-table-refresh-problems...
    more..

  9. Tags

    C# .NET Core, Java, Python, C++, Android, PHP, Node.js APIs to create, process and convert PDF, Word, Excel, PowerPoint, email, image, ZIP, and several other formats in Windows, Linux, MacOS & Android....discount 1 25 percent off on aspose-total 1 2D Aztec Barcode Java...rendering API 1 3D Rotation Cell values in Visio 1 3D Scene 2...

    blog.aspose.com/tags/
    more..

  10. DeleteBlankRows() is deleting rows even if it h...

    Ideally, according to the documentation, DeleteBlankRows() should delete only rows which are empty i.e. the rows which does not have any content, images, charts, comments etc… But in the attached file below, Even the r…...shapes on it Aspose.Cells Product Family cells-net shreyap April...MoveAndSize; } wb.Worksheets[0].Cells.DeleteBlankRows(); wb.Save(filePath...

    forum.aspose.com/t/deleteblankrows-is-deleting-...
    more..