Hi,
We experiencing some issues with Cognos TM1 Excel Add-in formulas with Aspose.Cell 7.1.2 which used to work fine with previous Aspose.Cell version 6.0.0, and when we compared files (using Open XML SDK 2.0 Productivity tool) generated by both Aspose.Cell versions (6.0.0 and 7.1.2) we found one difference like
With Aspose.Cell 6.0.0 formula is _XLL.DBR(“claritydemo:ClarityDemo”,“Year”,“Scenario”,“Office Products Inc”,“All Products”,“Accounts”,“Time”)
And with Aspose.Cell 7.1.2 formula is DBR(“claritydemo:ClarityDemo”,“Year”,“Scenario”,“Office Products Inc”,“All Products”,“Accounts”,“Time”)
If we correct this formula by adding “_XLL.” as a prefix it’s working fine.
I am not can’t isolate this problem in sample application since it needs Cognos TM1 setup on machine.
I attached some images and both excel files here.
Can you please provide advice on this issue ASAP we are very close to our release date.
Hi,
Thanks for your posting and using Aspose.Cells for .NET.
Please download and use the latest version:
Aspose.Cells
for .NET v7.1.2.6
It should have resolved such problems.
Let us know if the problem still occurs.
Hi,
After some investigation, we did find the issue as you mentioned. I have logged a ticket with an id: CELLSNET-40571. We will look into it soon.
Thank you.