private void AddVisualStyleMenu(SpreadsheetRibbon ribbon) { ToolStripEx panel = new ToolStripEx(); panel.GripStyle = ToolStripGripStyle.Hidden; panel.Office12Mode = false; panel.Size = new Size(143, 0); panel.ShowLauncher = false; panel.Text = "Visual Style"; visualStyleComboBox = new ToolStripComboBoxEx(); visualStyleComboBox.Size = new Size(140, 0); visualStyleComboBox.Style = ToolStripExStyle.Metro; visualStyleComboBox.DropDownStyle = ComboBoxStyle.DropDownList; visualStyleComboBox.Font = new Font("Segoe UI", 9, FontStyle.Regular); visualStyleComboBox.Items.Add("Default"); visualStyleComboBox.Items.Add("Office 2016 Colorful"); visualStyleComboBox.Items.Add("Office 2016 DarkGray"); visualStyleComboBox.Items.Add("Office 2016 Black"); visualStyleComboBox.Items.Add("Office 2016 White"); visualStyleComboBox.SelectedIndex = 3; visualStyleComboBox.SelectedIndexChanged += visualStyleComboBox_SelectedIndexChanged; visualStyleComboBox.DropDownClosed += visualStyleComboBox_DropDownClosed; panel.Items.Add(visualStyleComboBox); var tab = ribbon.Header.MainItems[2] as ToolStripTabItem; tab.Panel.Controls.Add(panel); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.WindowState = FormWindowState.Maximized; System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); #region Spreadsheet spreadsheet = new Spreadsheet(); SpreadsheetRibbon ribbon = new SpreadsheetRibbon() { Spreadsheet = spreadsheet }; this.DataBindings.Add("Text", this.spreadsheet, "FileName"); spreadsheet.Dock = DockStyle.Fill; spreadsheet.Anchor = AnchorStyles.Left | AnchorStyles.Top; #if !NETCORE spreadsheet.Open(@"..\..\..\..\..\Common\Data\Spreadsheet\Formula.xlsx"); #else spreadsheet.Open(@"..\..\..\..\..\..\Common\Data\Spreadsheet\Formula.xlsx"); #endif this.Controls.Add(spreadsheet); this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon"))); this.Controls.Add(ribbon); #endregion }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.WindowState = FormWindowState.Maximized; #region Spreadsheet spreadsheet = new Spreadsheet(); SpreadsheetRibbon ribbon = new SpreadsheetRibbon() { Spreadsheet = spreadsheet }; this.DataBindings.Add("Text", this.spreadsheet, "FileName"); spreadsheet.Dock = DockStyle.Fill; spreadsheet.Anchor = AnchorStyles.Left | AnchorStyles.Top; #if !NETCORE spreadsheet.Open(@"..\..\..\..\..\..\Common\Data\Spreadsheet\Localization.xlsx"); #else spreadsheet.Open(@"..\..\..\..\..\..\..\Common\Data\Spreadsheet\Localization.xlsx"); #endif this.Controls.Add(spreadsheet); this.Controls.Add(ribbon); #endregion }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.WindowState = FormWindowState.Maximized; System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); #region Spreadsheet spreadsheet = new Spreadsheet(); ribbon = new SpreadsheetRibbon() { Spreadsheet = spreadsheet }; spreadsheet.ShowBusyIndicator = false; ribbon.SelectedTab = ribbon.Header.MainItems[2] as ToolStripTabItem; AddVisualStyleMenu(ribbon); this.DataBindings.Add("Text", this.spreadsheet, "FileName"); spreadsheet.Dock = DockStyle.Fill; spreadsheet.Anchor = AnchorStyles.Left | AnchorStyles.Top; spreadsheet.ThemeName = "Office2016Black"; ribbon.ThemeName = "Office2016Black"; #if !NETCORE spreadsheet.Open(@"..\..\..\..\..\Common\Data\Spreadsheet\GettingStarted.xlsx"); #else spreadsheet.Open(@"..\..\..\..\..\..\Common\Data\Spreadsheet\GettingStarted.xlsx"); #endif this.Controls.Add(spreadsheet); this.Controls.Add(ribbon); this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon"))); #endregion }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); #region Spreadsheet spreadsheet = new Spreadsheet(); GraphicCellHelper.AddSparklineCellRenderer(spreadsheet, new SparklineCellRenderer()); SpreadsheetRibbon ribbon = new SpreadsheetRibbon() { Spreadsheet = spreadsheet }; this.DataBindings.Add("Text", this.spreadsheet, "FileName"); spreadsheet.Dock = DockStyle.Fill; spreadsheet.Anchor = AnchorStyles.Left | AnchorStyles.Top; spreadsheet.Open(@"..\..\..\..\..\..\Common\Data\Spreadsheet\Sparkline.xlsx"); this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon"))); this.Controls.Add(spreadsheet); this.Controls.Add(ribbon); #endregion }
protected override void Invoke(object parameter) { if (this.AssociatedObject != null && this.AssociatedObject is SpreadsheetRibbon) { SpreadsheetRibbon Ribbon = this.AssociatedObject as SpreadsheetRibbon; if (Ribbon.OthersRibbonTab != null && VisualStyleRibbonBar == null) { ComboBox comb = new ComboBox(); comb.Items.Add("Office2010Blue"); comb.Items.Add("Office2010Black"); comb.Items.Add("Office2010Silver"); comb.SelectedIndex = 0; comb.SelectionChanged += new SelectionChangedEventHandler(ComboBox_SelectionChanged); VisualStyleRibbonBar = new RibbonBar(); VisualStyleRibbonBar.Header = "Visual Styles"; VisualStyleRibbonBar.Items.Add(comb); Ribbon.OthersRibbonTab.Items.Add(VisualStyleRibbonBar); } } }
private void NewWindow() { TabPage tb = new TabPage(); Spreadsheet spreadsheet = new Spreadsheet(); SpreadsheetRibbon sRibbon = new SpreadsheetRibbon() { Spreadsheet = spreadsheet }; InitSpreadsheet(spreadsheet); InitSpreadsheetRibbon(sRibbon); DataTable dt = new DataTable(); tb.Text = "New"; tb.Controls.Add(spreadsheet); tb.Controls.Add(sRibbon); tabControl1.TabPages.Add(tb); tabControl1.SelectedTab = tb; }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.WindowState = FormWindowState.Maximized; System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); #region Spreadsheet spreadsheet = new Spreadsheet(); SpreadsheetRibbon ribbon = new SpreadsheetRibbon() { Spreadsheet = spreadsheet }; this.DataBindings.Add("Text", this.spreadsheet, "FileName"); spreadsheet.Dock = DockStyle.Fill; spreadsheet.Anchor = AnchorStyles.Left | AnchorStyles.Top; spreadsheet.ShowBusyIndicator = false; spreadsheet.AllowFiltering = true; spreadsheet.Open(@"..\..\Assets\Filtering.xlsx"); this.Controls.Add(spreadsheet); this.Controls.Add(ribbon); this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon"))); #endregion }
public void InitSpreadsheetRibbon(SpreadsheetRibbon sRibbon) { sRibbon.MenuButtonVisible = false; }