Hello,
We’re having an issue regarding a recursive reference.
This does not appear when using Excel, nor does it appear when we initially open the file and read the cell’s value. However, after recalculating the workbook (this is a necessary step as we will be dumping data into the first sheet) we are getting a #Recursive Reference!
code:
var fileStream = new FileStream(@“C:\Temp\RecursiveReferenceError.xls”, FileMode.Open);
var workbook = new XlsFactory().NewWorkbook(fileStream);
var xlsWorksheet = workbook.Worksheet(“Sheet3”);
var realValue = (double) xlsWorksheet.Cell(“B2”).Value;
workbook.CalculateFormulas();
Assert.That(xlsWorksheet.Cell(“B2”).Value.ToString(), Is.Not.EqualTo(“#Recursive Reference!”));
Assert.That((double)xlsWorksheet.Cell(“B2”).Value, Is.EqualTo(realValue));
I have attached our workbook.
Any help on this would be great as we are hoping to go live with this very soon.
Cheers,
Tom
This message was posted using Page2Forum (attachment) from Workbook Members - Aspose.Cells for .NET