Hi - using SetArrayFormula with a more complex array formula causes Excel to not treat the formula as an array formula. Upon opening the output file Excel reports an error. However, if we open the output file and click in the formula bar Excel automatically fixes the issue (or hit Ctrl+Enter). Code sample below ( using Aspose.Cells 17.9.0.0). Are we doing something wrong? Library issue? Suggestions? Thanks for your time.
We have tested this issue with the following sample code. Please check the output Excel file generated by it. When we open it in Microsoft Excel, we found error in cell B11 and when we click the formula bar, Microsoft Excel fixes it.
However, the array formula gets converted to regular or normal formula. It means, Microsoft Excel does not fix the issue but converts the formula to regular formula.
If you still find the issue, then please provide us your Excel file which you create manually using Microsoft Excel and submit it to us, we will then look into this issue further and help you.
Hello - sorry for not giving the complete example. Below is the updated sample method. I will also upload a sample output workbook. Thank you for your help.
Thanks for your clarification and using Aspose APIs.
We were able to observe this issue and logged it in our database for investigation and for a fix. Once, the issue is resolved or we have some other news for you, we will let you know asap.
This issue has been logged as
CELLSNET-45797 - SetArrayFormula - Not being treated as array formula
This is to inform you that we have fixed your issue CELLSNET-45797 now. We will soon provide the fix after performing QA and including other enhancements and fixes.
It is good to know that your issue seems resolved with the latest fix. Let us know if you encounter any other issue, we will be glad to look into it and help you further.