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

aspose cells formula bug

(0.34 sec)

  1. Power query parameter description is always nul...

    Hi Team, I am trying to read the parameter type power query Formula’s description (wb.DataMashup.PowerQueryFormulas[0].Description) but the value is always returned as null even though the parameter is having descriptio…...is always null Aspose.Cells Product Family cells-net , powerqueryformula...parameter type power query formula’s description (wb.DataMashup...

    forum.aspose.com/t/power-query-parameter-descri...
    more..

  2. 3-D refererence formulas are corrupted if sheet...

    Hi, We have a workbook with 3-D reference Formulas defined like ‘=SUM(‘Sheet2:Sheet 3’!A1:A4)’. If there is a space in sheet name the result will be #REF! and the Formula will be corrupted after saving using the library…...3-D refererence formulas are corrupted if sheet name contains...contains a space Aspose.Cells Product Family cells-net wwu January 16...

    forum.aspose.com/t/3-d-refererence-formulas-are...
    more..

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

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

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

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

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

  9. Hundreds of internal exceptions thrown when cal...

    I am encountering hundreds of internal exceptions thrown when calling Workbook.CalculateFormula for a particular Excel workbook. The exceptions are of the variety “Exception thrown: ‘’ in Aspose.Cells.dll” and, while ul…...CalculateFormula Aspose.Cells Product Family cells-net johnson.shi...deep stack when calculating formulas with too many dependencies/recursive...

    forum.aspose.com/t/hundreds-of-internal-excepti...
    more..

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