Free Support Forum - aspose.com

Recursive reference


Hello, I’m just new to using Aspose.cells and i’m getting to some trouble, can anyone tell if this is the correct way to put data into an excel sheet and then get the result.

The code:

Workbook book = new Workbook();
FileStream stream = new FileStream(“Master-calcMod.xls”, FileMode.Open);

book.Open(stream);

book.Worksheets[“WSI”].Cells[2, 0].PutValue(0);
book.Worksheets[“WSI”].Cells[3, 0].PutValue(2);
book.Worksheets[“WSI”].Cells[4, 0].PutValue(0);

book.CalculateFormula();
book.Save(stream, FileFormatType.Default);
stream.Close();

Workbook book4 = new Workbook();
FileStream stream2 = new FileStream(“Master-calcMod.xls”, FileMode.Open);
book4.LoadData(stream2);
HttpContext.Current.Response.Write(book4.Worksheets[“WSI”].Cells[“A64”].Value.ToString());

stream2.Close();

When I look into my browser

Hi,

Thanks for considering Aspose.

Which version of Aspose.Cells you are using. Kindly try the latest version 4.5. If you still find the problem, kindly post your template file i.e. "Master-calcMod.xls" with all the details, we will check it soon.

Thank you.



Thanks for the quick reply.

I’m using the latest version of Aspose.Cells which I downloaded last week.
The template is big file and a bit complex.

The function of the excel file:
on the first page (worksheet: WSI) you fill in some numbers in the range A3:A18. After this the
price in cell E62 is changed and i’ll need to get that price for the rest of the process.

Patrick

Hi Patrick,

Thanks for providing us the template file.

We will figure out the issue soon.

Thank you.


Hi Amjad,

Do you know something already, because we’re very interested
in Aspose.Cells. Only we’ve got a deadline for this.

Patrick

Hi Patrick,

Please try this fix.

We have fixed the bug of calculating Address function.