We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Cell formula is not visible

Hello.

I have a problem with cell formula, see code:

Workbook wb = new Workbook(“bugstatistics_v6.xlsx”);
var customWs = wb.Worksheets[“CUSTOM”];
var formula = customWs.Cells[“I2”].Formula;

when I open bugstatistics_v6.xlsx in excel, formula is visible.
What could be the reason?

See attached file

Hi Dmitry,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue after running your code using the latest version: Aspose.Cells
for .NET v8.1.1.3
with your source file.

The cell I2 inside the sheet (CUSTOM) has a formula (=IF(LEN(DATA!I2)=0,VLOOKUP(J2,REF_DATA!$A$1:$C$500,3,FALSE)+14,DATA!I2)) but Cell.Formula is returning null.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-42853.

After some comparing I’ve found that the problem is related to data xml stored inside bugstatistics_v6.xlsx (bugstatistics_v6.xlsx\xl\worksheets\sheet3.xml):
I2 cell is stored as following:
IF(LEN(DATA!I2)=0,VLOOKUP(J2,REF_DATA!$A$1:$C$500,3,FALSE)+14,DATA!I2)507
If I change t=“s” to t=“e”:
IF(LEN(DATA!I2)=0,VLOOKUP(J2,REF_DATA!$A$1:$C$500,3,FALSE)+14,DATA!I2)507
formula become visible from the code.
Maybe this could help.

Hi Dmitry,

Thanks for your solution and using Aspose.Cells.

We have logged it in our database against this issue. Hopefully, it will be helpful in fixing this issue. Once, there is some fix or other news for you, we will let you know asap.

Hi Shakeel.

Can you suggest how long could take fixing of this problem? Some of our customers are blocked by this issue.
We are using Aspose.Total for .NET Developer OEM license.

Hi Dmitry,

Thanks for your using Aspose.Cells.

We are glad to let you know that we have fixed this issue.

Please download and try the latest fix: Aspose.Cells for .NET v8.1.2.1 and let us know your feedback.

Hi Shakeel.

This issue is solved. Thanks for helping!

Hi,


Thanks for your feedback.

Good to know that your issue is resolved by the new fix/version, we have closed your ticket now. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan