Free Support Forum - aspose.com

BUG: Indirect() after CalculateFormula() returns #REF for data after 255 columns

Hi,

If I run CalculateFormula() on a workbook, the Indirect lookup function fails for data after 256 columns, returning #REF. I am using .xlsx format workbook, and it works fine when using a straight lookup to the same data cells.

File attached and code below to recreate the issue - this shows message boxes with the error. Grateful if you can let me know a workaround, or provide a fix.

Thanks, Tom.


Dim loadOptions As New Aspose.Cells.LoadOptions(Aspose.Cells.LoadFormat.Xlsx)
Dim wkbook As New Aspose.Cells.Workbook(“SampleData-IndirectLookupFail.xlsx”, loadOptions)

MsgBox(“Before CalculateFormula()” & vbCrLf & "Row J Direct lookup = " & wkbook.Worksheets(“Lookups”).Cells(“B2”).ToString & vbCrLf & "Row J Indirect lookup = " & wkbook.Worksheets(“Lookups”).Cells(“C2”).ToString & vbCrLf & _
"Row AMN Direct lookup = " & wkbook.Worksheets(“Lookups”).Cells(“B3”).ToString & vbCrLf & "Row AMN Indirect lookup = " & wkbook.Worksheets(“Lookups”).Cells(“C3”).ToString)

wkbook.CalculateFormula(False)

MsgBox(“After CalculateFormula()” & vbCrLf & "Row J Direct lookup = " & wkbook.Worksheets(“Lookups”).Cells(“B2”).ToString & vbCrLf & "Row J Indirect lookup = " & wkbook.Worksheets(“Lookups”).Cells(“C2”).ToString & vbCrLf & _
"Row AMN Direct lookup = " & wkbook.Worksheets(“Lookups”).Cells(“B3”).ToString & vbCrLf & "Row AMN Indirect lookup = " & wkbook.Worksheets(“Lookups”).Cells(“C3”).ToString)



Hi,


Thanks for providing us the template file and sample code.

I have tested your issue with latest fix/version v7.3.3.2:

I can find the issue as you have mentioned. I got #REF for C3 cell whose value is not calculated fine by Formula Calculation engine, other values look fine to me.

I have logged a ticket with an id: CELLSNET-41170 for your issue. We will look into your issue soon.

Thank you.

Hi Amjad, thanks for the fast response. I look forward to a fix.

Thanks, Tom.

Hi,

Any progress on this bug? I am evaluating whether to purchase Aspose - this is a critical issue for us in deciding.

Thanks, Tom.

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We have checked your issue status in a database. We are afraid, your issue is not resolved yet.

Please spare us some time around (2~3) working days more. Hopefully, your issue will be fixed soon.

Hi

Any progress on the fix for this? We’re
making decisions on whether or not to purchase Aspose this week - and
this is a critical issue.

Thanks, Tom.

Hi,

Thanks for your posting and using Aspose.Cells.

I am afraid, there is no update for you at this moment. However, I have logged your comments in our database against the issue id: CELLSNET-41170

Once, there is some update for you, we will let you know asap.

Hi, any progress on this issue, or estimate of when it will be fixed ?

Thanks, Tom.

Hi,

We have fixed this issue.

Please download and try this fix: Aspose.Cells for .NET (Latest Version) and let us know your feedback.