Hi Christian,
We have fixed an issue “Direct dependency is not working in IRange” and the patch can be downloaded from the following locations. We have exposed the new API’s to get direct dependent and precedent cells. Please refer the below code example for the same.
|
API Name |
Code |
|
Range.GetDirectDependents()
Gets the dependent cells which refer to other cells. |
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
application.RangeIndexerMode = ExcelRangeIndexerMode.Relative;
IWorkbook workbook = application.Workbooks.Open("Dependence.xlsx");
IWorksheet worksheet = workbook.Worksheets[0];
IRange rngS1A9 = worksheet.Range["A9"];
IRange[] diectDependents = rngS1A9.GetDirectDependents();
|
|
Range.GetDirectPrecedents()
Gets the Precedents cells which refer to other cells. |
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
application.RangeIndexerMode = ExcelRangeIndexerMode.Relative;
IWorkbook workbook = application.Workbooks.Open("Dependence.xlsx");
IWorksheet worksheet = workbook.Worksheets[0];
IRange rngS1A9 = worksheet.Range["A9"];
IRange[] diectDependents = rngS1A9.GetDirectPrecedents ();
|
Recommended approach - exe will perform automatic configuration
Please find the patch setup from below location:
Advanced approach – use only if you have specific needs and can directly replace existing assemblies for your build environment
Please find the patch assem blies alone from below location:
Assembly Version: 16.4.0.42
Installation Directions :
This patch should replace Syncfusion.XlsIO.Base.dll under the following folder.
$system drive:\ Files\Syncfusion\Essential Studio\$Version # \precompiledassemblies\$Version#\4.6
Eg : $system drive:\Program Files\Syncfusion\Essential Studio\ 16.4.0.42\precompiledassemblies\ 16.4.0.42\4.6
To automatically run the Assembly Manager, please check the Run assembly manager checkbox option while installing the patch. If this option is unchecked, the patch will replace the assemblies in precompiled assemblies’ folder only. Then, you will have to manually copy and paste them to the preferred location or you will have to run the Syncfusion Assembly Manager application (available from the Syncfusion Dashboard, installed as a shortcut in the Application menu) to re-install assemblies.
Note:
You can change how you receive bug fixes by navigating to the following link and updating your preferences.
Disclaimer :
Please note that we have created this patch for version 16.4.0.42 specifically to resolve the issues reported in this Forum 143384 .
If you have received other patches for the same version for other products, please apply all patches in the order received.
This fix will be included in our future release 2019 Volume 2 which will be rolled out at the end of June 2019.
Regards,
Dilli babu.
