Multiple sheets are selected: How to unselect

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.

Reply | Reply with quote

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

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

Regards,

Abirami

Reply | Reply with quote

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

Regards,

Abirami

Reply | Reply with quote

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:

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

Reply | Reply with quote

Thread ID:	Created:	Updated:	Platform:	Replies:
144906	May 28,2019 08:32 AM UTC	Jun 15,2019 01:38 PM UTC	WinForms	3

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US