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

calculateformula error fix

(0.42 sec)

  1. 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…...error( [saveWorkbookAsHtml] failed...too. Of course, we will try to fix this issue of null exception...

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

  2. Copy excel is not working properly when we try ...

    Hi Team, Good Morning!!! I am encountering an issue while copying multiple source workbooks containing PivotTables into a destination Excel workbook. The destination workbook is created, but it gets corrupted. When I t…...10) FYi… Attached error screenshot, sample java file...save("destination.xlsx"); } } Error Handling : Implement error handling to catch...

    forum.aspose.com/t/copy-excel-is-not-working-pr...
    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…...as updates often include bug fixes and enhancements related to...parts to identify where the error occurs. Code Example Here’s...

    forum.aspose.com/t/incorrect-formula-processing...
    more..

  4. Support for TOCOL function in version 24.2.0.0 ...

    Hi, In my application, I am writing some value in my workbook and then using Calculateformula() to recalculate the workbook because the written value can impact the values in other cells. But I am noticing the cells tha…...workbook and then using CalculateFormula() to recalculate the workbook...$A:$A)-2),1,FALSE))” start giving error “ #NA ”. image (2).png (28.2...

    forum.aspose.com/t/support-for-tocol-function-i...
    more..

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

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

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

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

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

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