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

calculateformula error fix

(0.21 sec)

  1. 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…...source XLSX file, are displaying errors ( #NAME? or #VALUE! ) in the...correctly. SORT : Shows #VALUE! errors in the PDF. SORTBY : Appears...

    forum.aspose.com/t/excel-dynamic-array-formula-...
    more..

  2. Pivot Data Mismatch Between Excel Workbook and ...

    We are facing a serious data mismatch issue when converting an Excel workbook (containing a PivotTable) to HTML using Aspose.Cells for Node.js. The Excel workbook is generated programmatically using Aspose. The PivotTab…...calculateFormula(); Save the workbook as... minimal sample, and exact error/output. KarthikMunjam December...

    forum.aspose.com/t/pivot-data-mismatch-between-...
    more..

  3. Not Able to Read cells and gettign null values ...

    Version :17.8 While reading the Excel document though there is evaluated data its reading as null. The Excel is getting generated in the app, for few customers it works fine for few customers and not working for other c…...following steps: Check for Formula Errors : Use the GetFormula method...correctly. You can use the CalculateFormula method to force the evaluation...

    forum.aspose.com/t/not-able-to-read-cells-and-g...
    more..

  4. Aspose Cells - Pivot Table - Sum not updated - ...

    Good Morning, I have a template Excel file with a pivot table. When I refresh it in Excel, the data are correct. However, when I refresh it in Aspose Cells, the percent column does not refresh. It is a Value Field with S…...CalculateFormula WorksheetCollection.RefreshAll...pivot table, call Workbook.CalculateFormula() to ensure all formulas...

    forum.aspose.com/t/aspose-cells-pivot-table-sum...
    more..

  5. The image Aspose.Cell captures does not look li...

    Hey Aspose Team, I’ve been noticing a weird behavior in my code when I capture the picture of range. The image aspose captures look nothing like the excel chart when I open the excel chart and view it. public virtual S…...CalculateFormula(); Worksheet sourceWS...MB) Word_Outputs.zip (2.4 MB) Error: Shape width cannot be greater...

    forum.aspose.com/t/the-image-aspose-cell-captur...
    more..

  6. Cells.DeleteRange break formulas when deleting ...

    Dear Aspose support, I am trying to delete the first datarow of a ListObject via Cells.DataRange(). If i am deleting the first data row (after the header), the table breaks. If i save it the workbook to the file system,…...CalculateFormula(); Save the workbook and...If you continue to see #REF! errors, provide the minimal workbook...

    forum.aspose.com/t/cells-deleterange-break-form...
    more..

  7. Updated Embedded Excel Data Not Updating, Requi...

    In a C# environment using these packages <PackageReference Include="Aspose.Cells" Version="24.10.0" /> <PackageReference Include="Aspose.Slides.NET" Version="24.10.0" /> I have this powerpoint file with 1 slide slide …...CalculateFormula(opts, true); worksheet1...chart1.Calculate(); } } wb.CalculateFormula(opts); } ap.Save(@"[directory...

    forum.aspose.com/t/updated-embedded-excel-data-...
    more..

  8. VLOOKUP function returns unexpected result - Fr...

    VLOOKUP function behaves differently in Aspose.Cells and results don’t match with Excel. In below example, Excel will return #REF! whereas Aspose will return #N/A: =VLOOKUP(1/1/2020,$C1:$D4,#N/A,FALSE) If value is not…...whereas Aspose returns #N /A error. Attached is the Excel file...which I have reproduced this error. In this workbook if you look...

    forum.aspose.com/t/vlookup-function-returns-une...
    more..

  9. Aspose.Cells returns different value compared t...

    Please find attached Excel file and screenshots: Proof of Tax - 2025 -Mod.zip (178.6 KB) For cell ‘Computation reconciliation’!A140, Excel returns a string value. For cell ‘Computation reconciliation’!A140, Excel corr…... error. Sample code: var workbook =...-Mod.xlsx"); workbook.CalculateFormula(true); var worksheet =...

    forum.aspose.com/t/aspose-cells-returns-differe...
    more..

  10. Aspose cells 在保存wps编辑过的文件之后 里面的正文内容会变成蓝色字体 - Fr...

    文件原本是xls格式的 保存为xlsx格式之后 使用wps编辑 再使用cell工具保存 会出现com.aspose.cells.b.a.d.k59 cannot be cast to com.aspose.cells.l86这个错误，如果保存为xls格式再使用wps编辑，再使用cell工具保存的时候不报错，但是里面的正文内容会部分变成蓝色字体... The error com.aspose.cells.b.a.d.k59 cannot...font issue and the casting error, consider the following steps:...

    forum.aspose.com/t/aspose-cells-wps/314668
    more..