Existing formula not work when write a .xlsm file

Aspose.Cells Product Family
1

When write data to a .xlsm file,
existing formula like “LINEARINTERPOLATION” not work

like “=LINEARINTERPOLATION($R17,$B$28:$B$35,F$28:F$35)” will return as “#NAME?”

There should be no error in this formula, as I copy the formula to the cell beside it,get result:
image.png (691 Bytes)

Any possible way to solve it?
Thanks very much.

Also,when use formula like “=Sheet1!K8*(B85<>B84)”

If Sheet1!K8 is empty then will take as “” empty.
But in our template it returns 0 which cause the result as “#VALUE” not 0 as wished

2

@kriswyb,

Thanks for your query.

I have copied this formula in Excel and filled dummy values in the cells mentioned in the formula. I am afraid no result is calculated and #NAME? is displayed in Excel. Please send us a workbook which is created using Excel having this formula and proper result is calculated in the sheet. Also share a simple console application(runnable) for our analysis which is used for testing at your end. We will generate the output file using this code with Aspose.Cells library and then compare it with the expected output provided by you. It will help us to observe the issue and provide assistance at the earliest.