Free Support Forum - aspose.com

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

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.

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>

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.

Hi,

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

Thank you

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.