Multiple sheets are selected: How to unselect

[Paul Meems]

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]

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 31^st May 2019. 

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

Regards, 

Abirami 

[Abirami Varadharajan]

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 14^th June 2019. 

Regards, 

Abirami 

[Abirami Varadharajan]

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:                       

http://syncfusion.com/Installs/support/patch/17.1.0.47/341743/F144906/SyncfusionPatch_17.1.0.47_341743_6152019123626202_F144906.exe 

   

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:                 

http://syncfusion.com/Installs/support/patch/17.1.0.47/341743/F144906/SyncfusionPatch_17.1.0.47_341743_6152019123626202_F144906.zip 

  

Nuget Link: http://syncfusion.com/Installs/support/patch/17.1.0.47/341743/F144906/SyncfusionNuget_17.1.0.47_341743_6152019123626202_F144906.zip 

  

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