I am trying to copy a series of columns that contain a formula:
=IF(ISERROR(AVERAGE(L10:O10)), NA(), AVERAGE(L10:O10))
When I perform the copy, I get a runtime error:
Error in Cell: O18-Invalid formula:"=ISERROR(AVERAGE(L10:O10))IF(NA,(),AVERAGE(L10:O10))".
If you notice, the error message has interted a comma after the "NA" in the formula. Does this imply that Aspose.Cells does not support the NA() formula? If Aspose.Cells does not support the NA() formula, do you have another mechanism that I can use to indicate that a cell containing a formula calculates to a blank cell? (I am trying to plot a chart for which I must show gaps if there is no data. To do this successfully, I must be able to indicate to Excel that, although the cell contains a formula, it needs to be calculated as "blank" so that a gap will be seen in the chart data series.)
I am using Aspose.Cells version 184.108.40.206.