Regarding using Index and Lookup formulas in Aspose.Grid

Aspose.Cells Product Family
1

Hi,

we are using Aspose.Grid 4.0, in this we need to use the Index and Lookup formulas for the calculation purpose, if we use that formula it will display as #Error. how can we use the above mentioned formulas in the Aspose Grid. kindly help us ASAP. Very Urgent.

Regards,

Unichem

2

Hi

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thanks for your request. I will move your request to Aspose.Cells forum. My colleagues will answer you shortly.

Best regards,

3

Hi,

Well, Aspose.Cells.GridDesktop supports Index and VLookup functions, see the supported formulas list document for reference:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/list-of-supported-functions.html

Please install latest Aspose.Cells for .NET v4.8.2 installer: http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/entry215207.aspx
and get the latest version of Aspose.Cells.GridDesktop control for your need.

Do you need Index and Lookup functions for Aspose.Cells.GridWeb control, kindly let us know.

Thank you.


4

Hi,

Please try the attached version Aspose.Cells.GridWeb v2.0.3.2012, we have supported Index and Lookup functions now.

Thank you.