Offset Combinations supported?

Aspose.com » Public Forums for Customers an... » Aspose.Cells Product Family » Offset Combinations supported?

Last post 07-28-2010, 5:30 AM by aspose.notifier. 5 replies.


	Sort Posts: Previous Next

07-15-2010, 5:42 PM 248932

AndrewE
Joined on 07-16-2010
Posts 2
Issues: CELLSNET-18534 (Unknown)

Offset Combinations supported?

I'd like to know if you have a list of supported or possible combinations of Excel's OFFSET function. We have the latest version of Aspose.cells installed and are having trouble handling a worksheet containing functions nested inside the OFFSET function. For instance OFFSET(Index(Match()),1,1).

This message was posted using Aspose.Live 2 Forum

07-16-2010, 2:21 AM 248950 in reply to 248932

Amjad Sahi
Joined on 08-30-2006
Posts 17,640

Re: Offset Combinations supported?

Hi,

Could you post your template Excel file containing your desired combination of Offset formulas and paste sample code to show the issue, we will check it soon.

Thank you.

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

07-16-2010, 11:45 AM 249077 in reply to 248950

AndrewE
Joined on 07-16-2010
Posts 2

Re: Offset Combinations supported?

Attachment: Present (inaccessible)

Thanks you for the swift reply! We are currently using Aspose.Cells for .NET version 4.8.2.6. Please see the attached .xls for the function example.

Code sample: We are not not programmatically generating the formula, rather executing the formula on the excel file by calling the method: workbook.CalculateFormula()

Filed under: Offset Index Match Nesting

07-16-2010, 1:04 PM 249097 in reply to 249077

Amjad Sahi
Joined on 08-30-2006
Posts 17,640

Re: Offset Combinations supported?

Hi,

I found an issue regarding CalculateFormula() method of Workbook.

We will figure it out soon.

I have logged your issue into our issue tracking system with an id: CELLSNET-18534.

Thank you.

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

07-23-2010, 5:49 AM 250113 in reply to 249097

Amjad Sahi
Joined on 08-30-2006
Posts 17,640

Re: Offset Combinations supported?

Attachment: Present (inaccessible)

Hi,

Please try the attached version, we have fixed your issue.

Thank you

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

07-28-2010, 5:30 AM 250819 in reply to 248932

aspose.notifier
Joined on 04-14-2009
Posts 7,857

Re: Offset Combinations supported?

The issues you have found earlier (filed as 18534) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.