private void loadAppearanceToolStripMenuItem_Click(object sender, EventArgs e) { OpenFileDialog dlg = new OpenFileDialog(); dlg.Title = "Open Pivot Table Appearance file"; string s = GetFile("default.appearance.XML"); s = s.Substring(0, s.LastIndexOf(@"\")); dlg.InitialDirectory = s; dlg.Filter = "Pivot Table Appearance files (*.appearance.xml)|*.appearance.xml|All files (*.*)|*.*"; if (dlg.ShowDialog() == DialogResult.OK) { Application.DoEvents();// let the dialog close before loading schema try { this.Cursor = Cursors.WaitCursor; PivotAppearance appearance = PivotAppearance.LoadXML(dlg.FileName); pivotGridControl1.SetAppearance(appearance); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { this.Cursor = Cursors.Default; } } }
private void showAllColorsToolStripMenuItem_Click(object sender, EventArgs e) { //show all colors - just for illustration to allow you to see what Appearance property affects what part of the pivotCOntrol1.MainDisplayGrid. PivotAppearance appearance = pivotGridControl1.GetAppearance(); appearance.RowTotalCell.BackColor = Color.Gold; appearance.RowExpandCell.BackColor = Color.Blue; appearance.ColumnExpandCell.BackColor = Color.Red; appearance.RowCell.BackColor = Color.Pink; appearance.ValueCell.BackColor = Color.LemonChiffon; appearance.ColumnTotalCell.BackColor = Color.IndianRed; appearance.ColumnCell.BackColor = Color.LawnGreen; appearance.CalculationNameCell.BackColor = Color.Yellow; appearance.TopLeftCell.BackColor = Color.Turquoise; pivotGridControl1.UpdateValues(); //forces a refresh to display new appearance }