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

Multiple sheets are selected: How to unselect

Thread ID:

Created:

Updated:

Platform:

Replies:

144906 May 28,2019 08:32 AM UTC Jun 15,2019 01:38 PM UTC WinForms 3
loading
Tags: XlsIO
Paul Meems
Asked On May 28, 2019 08:48 AM UTC

I open a template Excel-file, which has 2 sheets.
Next I fill each sheet with data and save the result as a new file.

In the result both sheets are selected. When a user paste something in a cell of sheet1 it is also paste in sheet2.

I'm not actively selecting both sheets. How to prevent this or how to deselect/ungroup the sheets?

I've already tried this:
            workbook.ActiveSheetIndex = 0;
            workbook.DisplayedTab = 0;
            foreach (var worksheet in workbook.Worksheets)
            {
                worksheet.Unselect();
            }
            workbook.Worksheets[0].Select();
            workbook.Worksheets[0].Activate();

But can't get it to work.

Abirami Varadharajan [Syncfusion]
Replied On May 29, 2019 03:46 PM UTC

Hi Paul, 

We are able to reproduce the issue with “Worksheet is not unselected when multiple sheets are selected in the Excel file”. We are validating it currently. We will update further details by 31st May 2019. 

Meanwhile, Please confirm that in your template multiple sheets are selected. 

Regards, 
Abirami 


Abirami Varadharajan [Syncfusion]
Replied On May 31, 2019 01:12 PM UTC

Hi Paul, 

Thank you for your patience. 

We confirmed issue with “Worksheet is not unselected when multiple sheets are selected in the Excel file” is a defect and logged a defect report for the same. The patch for this issue is estimated to be available on 14th June 2019. 

Regards, 
Abirami 


Abirami Varadharajan [Syncfusion]
Replied On June 15, 2019 01:38 PM UTC

Hi Paul, 
 
We have fixed an issue Worksheet is not unselected when multiple sheets are selected in the Excel file”. The patch can be downloaded from the following locations.      
  
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 assemblies alone from below location:                 
  
  
Assembly Version: 17.1.0.47
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\17.1.0.47\precompiledassemblies\17.1.0.47\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.                
https://www.syncfusion.com/support/directtrac/patches                  

Disclaimer : 
Please note that we have created this patch for version 17.1.0.47 specifically to resolve the issues reported in this Forum 144906.               
 

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 service pack 1 which will be rolled out at the end of July 2019. 
 

Regards, 
Abirami 



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