Search
Sort Score
Result 10 results
Languages All
Labels All
Results 21 - 30 of 70 for

aspose cells formula bug

(0.14 sec)

  1. InsertCutCells does not keep format condition f...

    When using InsertCutCells, I’m finding that the format condition Formulas are not staying relative to the Cells using them. Here is my example code: using Aspose.Cells; Workbook srcWorkbook = new(@"C:\Swift\Templates\…...condition formulas relative to new cell locations Aspose.Cells Product...condition formulas are not staying relative to the cells using them...

    forum.aspose.com/t/insertcutcells-does-not-keep...
    more..

  2. Workbook.CalculateFormula is very time consumin...

    Workbook wb = new Workbook(@“Test.xlsx”); Stopwatch sw = Stopwatch.StartNew(); wb.CalculateFormula(); Console.WriteLine($“{sw.ElapsedMilliseconds}ms”); It will take about 1 minite to calculate Formula. Test.7z (556.…...non-existing external links, maybe) Aspose.Cells Product Family cnbjw August...about 1 minite to calculate formula. Test.7z (556.0 KB) Professionalize...

    forum.aspose.com/t/workbook-calculateformula-is...
    more..

  3. InsertCutCells corrupts structured table refere...

    When a table column is moved using Cells.InsertCutCells, structured table references (e.g. myTable[Email]) in Formulas on other sheets are corrupted after the operation. The reference resolves to the wrong column name. …...references in formulas on other sheets Aspose.Cells Product Family...Family cells-net ronald.g March 16, 2026, 9:46pm 1 When a table...

    forum.aspose.com/t/insertcutcells-corrupts-stru...
    more..

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

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

  6. CalculateFormula throws an exception - Free Sup...

    I am using Aspose.Cells 25.10.0 .NET 9.0 There is a file that passes CalculateFormula in version 25.9 but in version 25.10 CalculateFormula throws an exception: System.NullReferenceException: Object reference not set…...an exception Aspose.Cells Product Family cells-net aleksandr...2025, 3:40pm 1 I am using Aspose.Cells 25.10.0 .NET 9.0 There is...

    forum.aspose.com/t/calculateformula-throws-an-e...
    more..

  7. A cell with Pythong only shows =_xlws.PY(0,1) w...

    Hi there, I added a python script with =py(…) in Excel. I loaded the file with Aspose.Cells, but when accessing the cell A1 and reading the Formula (with c.Formula) I only get “=_xlws.PY(0,1)”. I would like to have the s…...A cell with Pythong only shows =_xlws.PY(0,1) when accessed via...via c.formula. Where is the script? Aspose.Cells Product Family...

    forum.aspose.com/t/a-cell-with-pythong-only-sho...
    more..

  8. PowerQueryFormulaItems missing in function with...

    In Aspose.Cells for .NET version 25.4.0 I found the following problem for the PowerQueryFormulaItems of a function. When a file contains a power query function with a nested let like so: let Source = {"banana", "ap…...a nested let Aspose.Cells Product Family cells-net perfectxl...March 9, 2026, 1:41pm 1 In Aspose.Cells for .NET version 25.4.0...

    forum.aspose.com/t/powerqueryformulaitems-missi...
    more..

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

  10. CalculateFormula fails on chained dynamic array...

    Hi, we have a problem with complex dynamic array Formulas: Environment Aspose.Cells for .NET: 26.3.0 .NET 9.0, Windows 11 Use case We use Aspose.Cells as a calculation engine for pre-existing Excel templates. The temp…...dynamic array formulas Aspose.Cells Product Family cells-net rof March...dynamic array formulas: Environment Aspose.Cells for .NET: 26...

    forum.aspose.com/t/calculateformula-fails-on-ch...
    more..