Hi,
I have shared fomulas in my excel template (sheet 1) which is getting data from sheet 2.
Butt after populating my sheet 2 sheet 1 is not getting populated.
but all the required cells are filled with data for populating sheet 1
@Amrinder_Singh
Would you like to provide your sample file and executable Console project? We will check it soon.
@Amrinder_Singh
Another possible scenario we think is maybe actually you want to use dynamic array formula(introduced by newer version of ms excel). Such kind of formula may spill into different range of cells according to the calculated result. If so, please use SetDynamicArrayFormula instead of SetSharedFormula. And after you set all such kind of formulas, you may use RefreshDynamicArrayFormulas to make them spill into corresponding ranges. And here is one document about using dynamic array formula with Aspose.Cells for your reference:
If it is not the case, we are afraid we need your runnable code with sample file(if needed) to reproduce and figure the issue out.
It is handled , turns out i was not calling Calculate method of workbook, once i did it worked as needed
Thank you so much for quick reply