Hi Goran,
Thank you for using Syncfusion products.
In order to achieve
your requirement you should make use of calculated value instead of refresh
range property. Calculated value property returns the updated value. We have
shared the code snippets for your reference.
Code Snippets:
workbook.CalculationOptions.CalculationMode
= ExcelCalculationMode.Automatic workbook.CalculationOptions.IsIterationEnabled
= True For Each worksheet As IWorksheet In workbook.Worksheets worksheet.EnableSheetCalculations() For Each item In Data worksheet.Range(item.ExcelRow,
item.ExcelColumn).Value = item.ExcelValue Dim cell As String = CommonFunctions.GetExcelColumnName(item.ExcelColumn).ToString()
+ item.ExcelRow.ToString() Dim calculatedvalue As String = worksheet.Range(cell).CalculatedValue() Next Next |
Please let us know if
you need any clarification.
Regards,
Prakash Kumar
Hi Goran,
We are able
to reproduce this issue and we have logged an issue report on this. As per our
forum regulation, we will not be able to share the fix for the issue through forum.
However, if you are interested in receiving this fix then, we would request you
to use our Direct-Trac Support system to get the fix for this issue and resolve
all your technical queries. For more details, please login into http://www.syncfusion.com/Account/
and we will be happy to help you. Please let us know in case of any queries.
Regards,
Prakash Kumar
Hi Goran,
We would
request you to use our Direct-Trac Support system to resolve all your technical
queries and also please provide as the sample file for this scenario. For more
details, please login into http://www.syncfusion.com/Account/
and we will be happy to help you. Please let us know in case of any queries.
Thanks,
Vikas