Remove #N/A from results

Aspose.Cells Product Family
1

I know that #N/A can be removed in normal Excel workbook. How is this done using Aspose.cells? Suggestions please.

2

Hi,


Thanks for your posting and using Aspose.Cells.

How do you remove #NA from your workbook using Microsoft Excel? Please share your excel file and the steps you perform in MS-Excel to remove #NA.

Please also try calling the

Workbook.CalculateFormula()

method before saving your excel file and see if it makes any difference in resolving your issue. Let us know your feedback.