internal void FromConditionalFormat(ConditionalFormat cf)
{
SetAllNull();
if (cf.Scope != null)
{
Scope = cf.Scope.Value;
}
if (cf.Type != null)
{
Type = cf.Type.Value;
}
if (cf.Priority != null)
{
Priority = cf.Priority.Value;
}
SLPivotArea pa;
using (var oxr = OpenXmlReader.Create(cf))
{
while (oxr.Read())
{
if (oxr.ElementType == typeof(PivotArea))
{
pa = new SLPivotArea();
pa.FromPivotArea((PivotArea)oxr.LoadCurrentElement());
PivotAreas.Add(pa);
}
}
}
}
private void ButtonOk_Click(object sender, EventArgs e)
{
ActiveSheet.ClearConditionalFormats(ActiveSheet.ActiveRowIndex, ActiveSheet.ActiveColumnIndex);
ConditionalFormat format = Formats[0];
format.ComparisonOperator = expressionControl1.ComparisonOperator;
if (format.ComparisonOperator != ComparisonOperator.IsTrue &&
format.ComparisonOperator != ComparisonOperator.IsFalse &&
format.ComparisonOperator != ComparisonOperator.IsEmpty)
{
if (format.ComparisonOperator == ComparisonOperator.Between ||
format.ComparisonOperator == ComparisonOperator.NotBetween)
{
format.FirstCondition = expressionControl1.StartValue;
format.LastCondition = expressionControl1.EndValue;
if (!string.IsNullOrEmpty(format.FirstCondition) && !string.IsNullOrEmpty(format.LastCondition))
{
ActiveSheet.SetConditionalFormat(ActiveSheet.ActiveRowIndex, ActiveSheet.ActiveColumnIndex, 1, 1, format.Style, format.ComparisonOperator, format.FirstCondition, format.LastCondition);
}
}
else
{
format.FirstCondition = expressionControl1.StartValue;
if (!string.IsNullOrEmpty(format.FirstCondition))
{
ActiveSheet.SetConditionalFormat(ActiveSheet.ActiveRowIndex, ActiveSheet.ActiveColumnIndex, 1, 1, format.Style, format.ComparisonOperator, format.FirstCondition);
}
}
}
Close();
}
internal ConditionalFormat ToConditionalFormat()
{
ConditionalFormat cf = new ConditionalFormat();
cf.PivotAreas = new PivotAreas()
{
Count = (uint)this.PivotAreas.Count
};
foreach (SLPivotArea pa in this.PivotAreas)
{
cf.PivotAreas.Append(pa.ToPivotArea());
}
if (this.Scope != ScopeValues.Selection)
{
cf.Scope = this.Scope;
}
if (this.Type != RuleValues.None)
{
cf.Type = this.Type;
}
cf.Priority = this.Priority;
return(cf);
}
/**
* Gets the conditional formats
*
* @return the conditional formats
*/
public ConditionalFormat[] getConditionalFormats()
{
ConditionalFormat[] formats = new ConditionalFormat[conditionalFormats.Count];
int pos = 0;
foreach (ConditionalFormat record in conditionalFormats)
{
formats[pos++] = record;
}
return(formats);
}
private void ConditionFormatDialog_Load(object sender, EventArgs e)
{
cBox_Value.Items.Add("单元格数值");
cBox_Value.SelectedIndex = 0;
//初始化活动单元格的条件格式化信息
Formats = ActiveSheet.GetConditionalFormats(ActiveSheet.ActiveRowIndex, ActiveSheet.ActiveColumnIndex);
if (Formats == null || Formats.Length == 0)
{
ConditionalFormat cf = new ConditionalFormat();
cf.ComparisonOperator = ComparisonOperator.Between;
cf.Style = new NamedStyle();
cf.Style.Font = ActiveSheet.ActiveCell.Font;
cf.Style.BackColor = Color.White;
cf.Style.ForeColor = Color.Black;
Formats = new ConditionalFormat[1] {
cf
};
}
ConditionalFormat format = Formats[0];
if (format.ComparisonOperator != ComparisonOperator.IsTrue &&
format.ComparisonOperator != ComparisonOperator.IsFalse &&
format.ComparisonOperator != ComparisonOperator.IsEmpty)
{
cBox_Value.SelectedIndex = 0;
}
if (cBox_Value.SelectedIndex == 0)
{
expressionControl1.BringToFront();
expressionControl1.ComparisonOperator = format.ComparisonOperator;
if (format.ComparisonOperator == ComparisonOperator.Between ||
format.ComparisonOperator == ComparisonOperator.NotBetween)
{
expressionControl1.StartValue = format.FirstCondition;
expressionControl1.EndValue = format.LastCondition;
}
else
{
expressionControl1.StartValue = format.FirstCondition;
}
}
UpdateExample(format.Style);
}
private void StyleDialog_Load(object sender, EventArgs e)
{
ConditionalFormat format = Formats[0];
Font_Regular.Checked = (format.Style.Font.Style == FontStyle.Regular);
Font_Bold.Checked = (format.Style.Font.Style == FontStyle.Bold);
Font_Italic.Checked = (format.Style.Font.Style == FontStyle.Italic);
Font_Strikeout.Checked = (format.Style.Font.Style == FontStyle.Strikeout);
Font_Underline.Checked = (format.Style.Font.Style == FontStyle.Underline);
label1.Font = format.Style.Font;
ForeColorPicker.Value = format.Style.ForeColor;
BackColorPicker.Value = format.Style.BackColor;
}
internal void FromConditionalFormat(ConditionalFormat cf)
{
this.SetAllNull();
if (cf.Scope != null) this.Scope = cf.Scope.Value;
if (cf.Type != null) this.Type = cf.Type.Value;
if (cf.Priority != null) this.Priority = cf.Priority.Value;
SLPivotArea pa;
using (OpenXmlReader oxr = OpenXmlReader.Create(cf))
{
while (oxr.Read())
{
if (oxr.ElementType == typeof(PivotArea))
{
pa = new SLPivotArea();
pa.FromPivotArea((PivotArea)oxr.LoadCurrentElement());
this.PivotAreas.Add(pa);
}
}
}
}
protected override object DoVisit(ConditionalFormat conditionalFormat)
{
// to catch errors, ignore result
Visit(conditionalFormat.Argument);
foreach (Case @case in conditionalFormat.Cases)
{
object conditionResult = Visit(@case.Condition);
if (conditionResult == Error)
{
// visit to catch errors, but ignore result
Visit(@case.FormatString);
continue;
}
if ((bool)conditionResult)
{
return(Visit(@case.FormatString));
}
}
return(string.Empty);
}
private void ButtonFormatDialog_Click(object sender, EventArgs e)
{
StyleDialog Dialog = new StyleDialog(Formats);
if (DialogResult.OK == Dialog.ShowDialog())
{
ConditionalFormat format = Formats[0];
FontStyle Style = FontStyle.Regular;
if (Dialog.Font_Regular.Checked)
{
Style = Style | FontStyle.Regular;
}
if (Dialog.Font_Bold.Checked)
{
Style = Style | FontStyle.Bold;
}
if (Dialog.Font_Italic.Checked)
{
Style = Style | FontStyle.Italic;
}
if (Dialog.Font_Strikeout.Checked)
{
Style = Style | FontStyle.Strikeout;
}
if (Dialog.Font_Underline.Checked)
{
Style = Style | FontStyle.Underline;
}
format.Style.Font = new Font(format.Style.Font.FontFamily, format.Style.Font.Size, Style, format.Style.Font.Unit, format.Style.Font.GdiCharSet);
format.Style.ForeColor = Dialog.ForeColorPicker.Value;
format.Style.BackColor = Dialog.BackColorPicker.Value;
UpdateExample(format.Style);
}
}
internal ConditionalFormat ToConditionalFormat()
{
var cf = new ConditionalFormat();
cf.PivotAreas = new PivotAreas {
Count = (uint)PivotAreas.Count
};
foreach (var pa in PivotAreas)
{
cf.PivotAreas.Append(pa.ToPivotArea());
}
if (Scope != ScopeValues.Selection)
{
cf.Scope = Scope;
}
if (Type != RuleValues.None)
{
cf.Type = Type;
}
cf.Priority = Priority;
return(cf);
}
internal ConditionalFormat ToConditionalFormat()
{
ConditionalFormat cf = new ConditionalFormat();
cf.PivotAreas = new PivotAreas() { Count = (uint)this.PivotAreas.Count };
foreach (SLPivotArea pa in this.PivotAreas)
{
cf.PivotAreas.Append(pa.ToPivotArea());
}
if (this.Scope != ScopeValues.Selection) cf.Scope = this.Scope;
if (this.Type != RuleValues.None) cf.Type = this.Type;
cf.Priority = this.Priority;
return cf;
}
protected virtual object DoVisit(ConditionalFormat conditionalFormat)
{
return(Default(conditionalFormat));
}
private void genarateData()
{
if (cmbJenisPel.Text.Equals("Rawat Jalan"))
{
this.pivotGridControl1.ItemSource = getDataRawatJalan();
}
else
{
this.pivotGridControl1.ItemSource = getDataRawatInap();
}
if (chkBoxSort.Checked)
{
this.pivotGridControl1.RowPivotsOnly = true;
}
else
{
this.pivotGridControl1.RowPivotsOnly = false;
this.pivotGridControl1.PivotRows.Add(new PivotItem {
FieldMappingName = "diagnosa_grouper", FieldHeader = "Diagnosa", AllowSort = true
});
}
this.pivotGridControl1.GridVisualStyles = GridVisualStyles.Metro;
this.pivotGridControl1.PivotRows.Add(new PivotItem {
FieldMappingName = "deskripsi", FieldHeader = "Deskripsi", AllowSort = true
});
this.pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo {
FieldName = "no_sep", FieldHeader = "Total Kasus(SEP)", AllowSort = true
});
this.pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo {
FieldName = "biaya_rs", FieldHeader = "Biaya RS", SummaryType = SummaryType.Sum, Format = "#,##0", AllowSort = true
});
this.pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo {
FieldName = "iurPasien", FieldHeader = "Iuran Pasien", SummaryType = SummaryType.Sum, Format = "#,##0", AllowSort = true
});
this.pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo {
FieldName = "potongan", FieldHeader = "Potongan", SummaryType = SummaryType.Sum, Format = "#,##0", AllowSort = true
});
this.pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo {
FieldName = "COB", FieldHeader = "COB", SummaryType = SummaryType.Sum, Format = "#,##0", AllowSort = true
});
this.pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo {
FieldName = "piutangRS", FieldHeader = "Piutang RS", SummaryType = SummaryType.Sum, Format = "#,##0", AllowSort = true, FieldCaption = "Piutang RS"
});
this.pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo {
FieldName = "umbal", FieldHeader = "Umbal BPJS", SummaryType = SummaryType.Sum, Format = "#,##0", AllowSort = true
});
this.pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo {
FieldName = "selisihUmbal", FieldHeader = "Selisih Dgn Umbal", SummaryType = SummaryType.Sum, Format = "#,##0", AllowSort = true, FieldCaption = "Selisih Umbal"
});
this.pivotGridControl1.ShowSubTotals = false;
this.pivotGridControl1.ShowPivotValueChooser = true;
this.pivotGridControl1.TableControl.AllowRowPivotFiltering = true;
this.pivotGridControl1.TableControl.AllowRowResizeUsingCellBoundaries = true;
this.pivotGridControl1.TableControl.AllowColumnResizeUsingCellBoundaries = true;
// this.pivotGridControl1.RowPivotsOnly = true;
this.pivotGridControl1.AllowSorting = true;
pivotGridControl1.TableControl.FreezeHeaders = true;
NewRuleConditionalFormat newRule1 = new NewRuleConditionalFormat();
newRule1.RuleType = RuleType.FormatOnlyCellsThatContain;
newRule1.SummaryElement = "Selisih";
ConditionalFormat condition1 = new ConditionalFormat();
condition1.ConditionType = PivotGridDataConditionType.LessThan;
condition1.StartValue = 0;
newRule1.Conditions.Add(condition1);
PivotGridNewRuleConditionalFormat newRuleFormat1 = new PivotGridNewRuleConditionalFormat();
newRuleFormat1.NewRuleCollections.Add(newRule1);
newRuleFormat1.PivotCellStyle.BackColor = Color.Pink;
newRuleFormat1.PivotCellStyle.TextColor = Color.White;
this.pivotGridControl1.TableControl.NewRuleConditionalFormat.Add(newRuleFormat1);
this.pivotGridControl1.Refresh();
this.pivotGridControl1.ShowPivotTableFieldList = true;
this.pivotGridControl1.ShowGroupBar = true;
this.pivotGridControl1.PivotSchemaDesigner.RefreshGridSchemaLayout();
pivotGridControl1.TableModel.Model.ColWidths[1] = 100;
pivotGridControl1.TableModel.Model.ColWidths[2] = 400;
}
/// <summary>
/// Set the values for all the cell
/// </summary>
private void button1_Click(object sender, EventArgs e)
{
bool isNeedColor = false;
NewRuleConditionalFormat newRule1 = new NewRuleConditionalFormat();
string RuleType = this.grdRuleType.Text;
newRule1.RuleType = SetRuleType(RuleType);
double number = 0;
switch (RuleType)
{
case "Format Only Cells That Contain":
ConditionalFormat form = new ConditionalFormat();
form.ConditionType = SetConditionalType(cboRule2ConditionType.SelectedItem.ToString());
form.PredicateType = SetPredicateType(cboRule2ConditionType.SelectedItem.ToString());
if (!string.IsNullOrEmpty(txtRule2StartValue.Text) &&
double.TryParse(txtRule2StartValue.Text, out number))
{
form.StartValue = Convert.ToDouble(txtRule2StartValue.Text);
}
if (!string.IsNullOrEmpty(txtRule2EndValue.Text) &&
double.TryParse(txtRule2EndValue.Text, out number))
{
form.EndValue = Convert.ToDouble(txtRule2EndValue.Text);
}
newRule1.Conditions.Add(form);
newRule1.SummaryElement = cboRule2SummaryElement.SelectedItem.ToString();
isNeedColor = true;
break;
case "Format Top Or Bottom Ranked Values":
newRule1.FormateValuesRankType = SetFormateValuesRankType(cboRule3FormatRankType.SelectedItem.ToString());
if (!string.IsNullOrEmpty(txtRule3RankValue.Text) &&
double.TryParse(txtRule3RankValue.Text, out number))
{
newRule1.RankValue = Convert.ToInt32(Convert.ToDouble(txtRule3RankValue.Text.ToString()));
}
if (cboRule3SummaryElement.SelectedItem != null)
{
newRule1.SummaryElement = cboRule3SummaryElement.SelectedItem.ToString();
}
isNeedColor = true;
break;
case "Format Only Values That Are Above Or Below Average":
newRule1.FormateSelectedAverageValueType = SetFormateSelectedAverageValueType(cboRule4FormatValueType.SelectedItem.ToString());
if (cboRule4SummaryElement.SelectedItem != null)
{
newRule1.SummaryElement = cboRule4SummaryElement.SelectedItem.ToString();
}
isNeedColor = true;
break;
case "Format Only Unique Or Duplicate Values":
newRule1.FormatAllType = SetFormatAllType(cboRule5FormatAllType.SelectedItem.ToString());
if (cboRule5SummaryElement.SelectedItem != null)
{
newRule1.SummaryElement = cboRule5SummaryElement.SelectedItem.ToString().Trim();
}
isNeedColor = true;
break;
default:
if (cboRule1FormatStyle.SelectedIndex == 0)
{
newRule1.FormatStyle = FormatStyle.IconSets;
}
if (cboRule1SummaryElement.SelectedItem != null)
{
newRule1.SummaryElement = cboRule1SummaryElement.SelectedItem.ToString();
}
newRule1.Image = SetImageName(cboRule1ImageName.Text);
isNeedColor = false;
if (cboValueType1.SelectedIndex == 0)
{
newRule1.ValueType1 = Syncfusion.Windows.Forms.PivotAnalysis.ValueType.Percent;
}
else
{
newRule1.ValueType1 = Syncfusion.Windows.Forms.PivotAnalysis.ValueType.Number;
}
if (cboValueType2.SelectedIndex == 0)
{
newRule1.ValueType2 = Syncfusion.Windows.Forms.PivotAnalysis.ValueType.Percent;
}
else
{
newRule1.ValueType2 = Syncfusion.Windows.Forms.PivotAnalysis.ValueType.Number;
}
if (cboValueType3.SelectedIndex == 0)
{
newRule1.ValueType3 = Syncfusion.Windows.Forms.PivotAnalysis.ValueType.Percent;
}
else
{
newRule1.ValueType3 = Syncfusion.Windows.Forms.PivotAnalysis.ValueType.Number;
}
if (cboValueType4.SelectedIndex == 0)
{
newRule1.ValueType4 = Syncfusion.Windows.Forms.PivotAnalysis.ValueType.Percent;
}
else
{
newRule1.ValueType4 = Syncfusion.Windows.Forms.PivotAnalysis.ValueType.Number;
}
break;
}
PivotGridNewRuleConditionalFormat newRuleFormat1 = new PivotGridNewRuleConditionalFormat();
newRuleFormat1.NewRuleCollections.Add(newRule1);
if (isNeedColor)
{
newRuleFormat1.PivotCellStyle.BackColor = Color.Red;
newRuleFormat1.PivotCellStyle.TextColor = Color.White;
}
this.pivotGridControl1.TableControl.NewRuleConditionalFormat.Add(newRuleFormat1);
this.pivotGridControl1.TableControl.Refresh(true);
}
/// <summary>
/// Load the form for Setting the Grid
/// </summary>
void Form1_Load(object sender, EventArgs e)
{
this.grdDropDown.BeginUpdate();
this.grdDropDown.DataSource = CreateTable();
this.grdDropDown.DisplayMember = "Name";
this.grdDropDown.ValueMember = "Id";
this.grdDropDown.SelectionMode = SelectionMode.One;
this.grdDropDown.ShowColumnHeader = false;
this.grdDropDown.ThemesEnabled = true;
this.grdDropDown.Grid.VerticalThumbTrack = true;
this.grdDropDown.Grid.DrawCellDisplayText += new Syncfusion.Windows.Forms.Grid.GridDrawCellDisplayTextEventHandler(Grid_DrawCellDisplayText);
this.grdDropDown.FillLastColumn = true;
this.grdDropDown.EndUpdate();
this.grdDropDown.Grid.QueryCellInfo += new Syncfusion.Windows.Forms.Grid.GridQueryCellInfoEventHandler(Grid_QueryCellInfo);
DataTable dtRuleType = new DataTable();
dtRuleType.Columns.Add("RuleType");
dtRuleType.Rows.Add("Format All Cells Based On Their Values");
dtRuleType.Rows.Add("Format Only Cells That Contain");
dtRuleType.Rows.Add("Format Top Or Bottom Ranked Values");
dtRuleType.Rows.Add("Format Only Values That Are Above Or Below Average");
dtRuleType.Rows.Add("Format Only Unique Or Duplicate Values");
this.grdRuleType.DisplayMember = "RuleType";
this.grdRuleType.SelectionMode = SelectionMode.One;
this.grdRuleType.ShowColumnHeader = false;
this.grdRuleType.ThemesEnabled = true;
this.grdRuleType.Grid.VerticalThumbTrack = true;
this.grdRuleType.DataSource = dtRuleType;
this.grdRuleType.FillLastColumn = true;
this.grdRuleType.BorderStyle = BorderStyle.FixedSingle;
this.grdDropDown.BorderStyle = BorderStyle.FixedSingle;
this.grdDropDown.ThemesEnabled = false;
this.grdRuleType.ThemesEnabled = false;
// default selection
this.grdRuleType.Grid.Model.Selections.Add(GridRangeInfo.Cell(1, 1));
loadRule1Combobox();
imageSelection(5);
bool isNeedColor = false;
NewRuleConditionalFormat newRule1 = new NewRuleConditionalFormat();
string RuleType = this.grdRuleType.Text;
newRule1.RuleType = SetRuleType(RuleType);
ConditionalFormat form = new ConditionalFormat();
cboRule2ConditionType.SelectedIndex = 0;
form.ConditionType = SetConditionalType(cboRule2ConditionType.SelectedItem.ToString());
form.PredicateType = SetPredicateType(cboRule2ConditionType.SelectedItem.ToString());
if (!string.IsNullOrEmpty(txtRule2StartValue.Text))
{
form.StartValue = Convert.ToDouble(txtRule2StartValue.Text);
}
if (!string.IsNullOrEmpty(txtRule2EndValue.Text))
{
form.EndValue = Convert.ToDouble(txtRule2EndValue.Text);
}
newRule1.Conditions.Add(form);
cboRule2SummaryElement.SelectedIndex = 0;
this.cboRule1ImageName.TextBox.Text = "3-Flag";
newRule1.Image = SetImageName(this.cboRule1ImageName.TextBox.Text);
newRule1.SummaryElement = cboRule2SummaryElement.SelectedItem.ToString();
isNeedColor = true;
PivotGridNewRuleConditionalFormat newRuleFormat1 = new PivotGridNewRuleConditionalFormat();
newRuleFormat1.NewRuleCollections.Add(newRule1);
if (isNeedColor)
{
newRuleFormat1.PivotCellStyle.BackColor = Color.Red;
newRuleFormat1.PivotCellStyle.TextColor = Color.White;
}
this.pivotGridControl1.TableControl.NewRuleConditionalFormat.Add(newRuleFormat1);
this.pivotGridControl1.TableControl.Refresh(true);
}
private void ApplyConditionalFormat()
{
bool isNeedColor = false;
NewRuleConditionalFormat newRule1 = new NewRuleConditionalFormat();
string RuleType = grdRuleType.Text;
newRule1.RuleType = SetRuleType(RuleType);
double number;
switch (RuleType)
{
case "Format all value cells based on certain criteria":
ConditionalFormat form = new ConditionalFormat();
form.ConditionType = SetConditionalType(cboRule2ConditionType.SelectedItem.ToString());
form.PredicateType = SetPredicateType(cboRule2ConditionType.SelectedItem.ToString());
if (!string.IsNullOrEmpty(txtRule2StartValue.Text) &&
double.TryParse(txtRule2StartValue.Text, out number))
{
form.StartValue = Convert.ToDouble(txtRule2StartValue.Text);
}
if (!string.IsNullOrEmpty(txtRule2EndValue.Text) &&
double.TryParse(txtRule2EndValue.Text, out number))
{
form.EndValue = Convert.ToDouble(txtRule2EndValue.Text);
}
newRule1.Conditions.Add(form);
newRule1.SummaryElement = cboRule2SummaryElement.SelectedItem.ToString();
isNeedColor = true;
break;
case "Format top or bottom ranked value cells":
newRule1.FormateValuesRankType = SetFormateValuesRankType(cboRule3FormatRankType.SelectedItem.ToString());
if (!string.IsNullOrEmpty(txtRule3RankValue.Text) &&
double.TryParse(txtRule3RankValue.Text, out number))
{
newRule1.RankValue = Convert.ToInt32(Convert.ToDouble(txtRule3RankValue.Text));
}
if (cboRule3SummaryElement.SelectedItem != null)
{
newRule1.SummaryElement = cboRule3SummaryElement.SelectedItem.ToString();
}
isNeedColor = true;
break;
case "Format only value cells containing above or below average":
newRule1.FormateSelectedAverageValueType = SetFormateSelectedAverageValueType(cboRule4FormatValueType.SelectedItem.ToString());
if (cboRule4SummaryElement.SelectedItem != null)
{
newRule1.SummaryElement = cboRule4SummaryElement.SelectedItem.ToString();
}
isNeedColor = true;
break;
case "Format only unique or duplicate value cells":
newRule1.FormatAllType = SetFormatAllType(cboRule5FormatAllType.SelectedItem.ToString());
if (cboRule5SummaryElement.SelectedItem != null)
{
newRule1.SummaryElement = cboRule5SummaryElement.SelectedItem.ToString().Trim();
}
isNeedColor = true;
break;
default:
if (cboRule1FormatStyle.SelectedIndex == 0)
{
newRule1.FormatStyle = FormatStyle.IconSets;
}
if (cboRule1SummaryElement.SelectedItem != null)
{
newRule1.SummaryElement = cboRule1SummaryElement.SelectedItem.ToString();
}
newRule1.Image = SetImageName(cboRule1ImageName.Text);
if (cboValueType1.Enabled)
{
newRule1.ValueType1 = cboValueType1.SelectedIndex == 0 ? ValueType.Percent : ValueType.Number;
newRule1.Value1 = double.Parse(txtValue1.Text);
}
if (cboValueType2.Enabled)
{
newRule1.ValueType2 = cboValueType2.SelectedIndex == 0 ? ValueType.Percent : ValueType.Number;
newRule1.Value2 = double.Parse(txtValue2.Text);
}
if (cboValueType3.Enabled)
{
newRule1.ValueType3 = cboValueType3.SelectedIndex == 0 ? ValueType.Percent : ValueType.Number;
newRule1.Value3 = double.Parse(txtValue3.Text);
}
if (cboValueType4.Enabled)
{
newRule1.ValueType4 = cboValueType4.SelectedIndex == 0 ? ValueType.Percent : ValueType.Number;
newRule1.Value4 = double.Parse(txtValue4.Text);
}
break;
}
PivotGridNewRuleConditionalFormat newRuleFormat1 = new PivotGridNewRuleConditionalFormat();
newRuleFormat1.NewRuleCollections.Add(newRule1);
if (isNeedColor)
{
newRuleFormat1.PivotCellStyle.BackColor = Color.Red;
newRuleFormat1.PivotCellStyle.TextColor = Color.White;
}
pivotGridControl1.TableControl.NewRuleConditionalFormat.Add(newRuleFormat1);
pivotGridControl1.TableControl.Refresh(true);
}
public object Visit(ConditionalFormat conditionalFormat)
{
return(DoVisit(Utilities.ThrowIfNull(conditionalFormat, "conditionalFormat")));
}
