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
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Irresponsive Workbook.DisplayWorkbookTabs

Thread ID:





141210 Nov 29,2018 05:26 PM UTC Dec 4,2018 11:11 AM UTC WinForms 1
Tags: Spreadsheet
Asked On November 29, 2018 05:27 PM UTC

I'm trying to hide the Sheets tab (bottom-left) of the Spreadsheet control, using Spreadsheet1.Workbook.DisplayWorkbookTabs = False
This is a WinForm project

Visual Studio 2017 V.15.9.3
SpreadSheet V.


Deivaselvan Y [Syncfusion]
Replied On December 4, 2018 11:11 AM UTC

Hi Jack, 

Thanks for using Syncfusion products. 

To hide the TabBarPage in SpreadSheet control, you could use the TabBarPage.Visible and TabBarSplitterControl.RelativeWidth property in WorkbookLoaded event. Please refer the following code example and the sample, 

Code example 
AddHandler Me.spreadsheet.WorkbookLoaded, AddressOf Spreadsheet_WorkbookLoaded 
Private Sub Spreadsheet_WorkbookLoaded(ByVal sender As Object, ByVal args As Syncfusion.Windows.Forms.Spreadsheet.Helpers.WorkbookLoadedEventArgs) 
                Dim tabcontrol = TryCast(spreadsheet.Controls(0), TabBarSplitterControl) 
                tabcontrol.ShowAddNewTabBarPageOption = False 
                For Each tabitem In tabcontrol.TabBarPages 
                                TryCast(tabitem, TabBarPage).Visible = False 
                Next tabitem 
              tabcontrol.RelativeWidth = 0 
End Sub 
Sheet has displayed while loading the spreadsheet then sheet will be getting hided. To avoid this behavior, you could disable the spreadsheet visibility in constructor and then enable the visibility in Form.Shown event. Please refer the following code example, 
Code example 
Me.spreadsheet.Visible = False 
AddHandler Me.Shown, AddressOf Form1_Shown 
Private Sub Form1_Shown(ByVal sender As Object, ByVal e As EventArgs) 
                Me.spreadsheet.Visible = True 
End Sub 

Please let us know if you need any further assistance on this. 



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