VLOOK UP formula problem

Aspose.Cells Product Family
1

Hi,

When we generate an output file using an input file(which contains VLOOK UP which has got reference to an external file saved in c: drive),it displays #N/A instead of the calculated values.

Could you please help us in this regard.

Regards,

Richa

2

Hi Richa,

I am afraid, Aspose.Cells for Java does not support external referenced formulas at the moment. We have already logged an issue for it with an id: CELLSJAVA-5027 into our issue tracking system. We will work on it later.

By the way, could you give us some sample code or formula string / template file to confirm whether the #N/A is caused by the
external reference being not supported.

Thank you.

3

Hi,

This feature has been supported. Please download the latest version: Aspose.Cells for Java 7.0.1