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;
}
