We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Support for Range DirectDependents

Thread ID:

Created:

Updated:

Platform:

Replies:

143384 Mar 18,2019 10:02 AM UTC Mar 26,2019 06:44 PM UTC WPF 2
loading
Tags: XlsIO
Christian
Asked On March 18, 2019 10:02 AM UTC

I can get all dependents for a range with range.GetDependents().


Can I get this in Syncfusion?

Best
Christian


Dilli Babu Nandha Gopal [Syncfusion]
Replied On March 19, 2019 05:00 PM UTC

Hi Christian, 

We have confirmed that this as an issue with “Direct dependency is not working in IRange” and we have logged a defect report for this. The patch will be available on 26th March 2019. 

Regards, 
Dilli babu. 


Dilli Babu Nandha Gopal [Syncfusion]
Replied On March 26, 2019 06:44 PM UTC

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. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon