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. Image for the cookie policy date

Multiple sheets are selected: How to unselect

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)

But can't get it to work.

3 Replies

AV Abirami Varadharajan Syncfusion Team 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. 


AV Abirami Varadharajan Syncfusion Team 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. 


AV Abirami Varadharajan Syncfusion Team 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:
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\\precompiledassemblies\\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. 

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 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. 


Live Chat Icon For mobile
Up arrow icon