Hey,
Thanks for the reply.
Hey,
Hi,
We will throw Exception if the formula is invalid when calling Cell.Formula.
Hey,
As you can see above we are using Cell.Formula to put the formula in a particular cell but it does not throw an exception, so how do we validate it then?
Thanks,
Richa
Hi,
Please download and try this fix: Aspose.Cells for .NET v7.1.0.2
If the formula is invalid, an exception will be thrown when setting the formula by Cell.Formula.
Hey,
Thanks, formula validation now works with the new dll, but there is an exception in another part as shown:
var workbook = new Workbook();
workbook.Worksheets.Add(“A sheet”);
var worksheet = workbook.Worksheets[0];
worksheet.Cells.CreateRange(“A1”);
worksheet.Cells.Ranges[0].Name = “special_Name”;
worksheet.Cells[“A1”].Value = “Should Be read”;
The above code throws the exception as shown below:
System.ArgumentOutOfRangeException : Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
Even after CreateRange(), the count of ranges is coming as zero, but before when I used version 7.0.0. it used to work fine. What is the problem then?
Thanks,
Richa
Hi Richa,
Hi,
We do not add the range to the worksheet.Cells.Ranges list when you call Cells.CreateRange for performance issue.
Hey,
The issues you have found earlier (filed as CELLSNET-40315) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.