Offset Combinations supported?

Aspose.Cells Product Family
1
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
2

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.

3

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()

<span style=“font-size:11.0pt;font-family:“Calibri”,“sans-serif”;
color:#1F497D”><o:p></o:p>

4

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.

5

Hi,

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

Thank you

6

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.