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,
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.