void pgcHousesSales_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)
{
if (e.ValueType == PivotGridValueType.Total && e.Field.Equals(seasonallyAdjustedField))
{
e.DisplayText = "Total";
}
}
void PivotGridControlOnFieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)
{
if (e.Field != null && e.Field.FieldName == Model.NetIncome.ColumnFieldName)
{
e.DisplayText = Equals(e.Value, CurrentPeriod) ? _currentPeriodText : _comparePeriodText;
}
}
/// <summary>
/// Customize the display text of individual column and row headers and filter dropdown items
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Grid_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)
{
string txt;
PivotGridValueType vt = e.ValueType; // Value, Total, GrantTotal, CustomTotal
PivotGridFieldContext fc = GetPivotGridFieldContext(e.Field);
if (fc == null)
{
return;
}
if (fc.Aggregation.IsGroupingType)
{
object vo = e.Value;
txt = GroupingMethods.FormatGroupedValue(fc.Qc, fc.Aggregation, vo);
e.DisplayText = txt;
}
else if (fc.Aggregation.Role == AggregationRole.DataSummary) // data area header when 2 or more data fields
{
txt = PivotGridControlMx.BuildFieldCaption(fc.F);
e.DisplayText = txt;
}
else
{
return;
}
return;
}
void pivotGridControl1_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)
{
if (object.ReferenceEquals(e.Field, pivotGridControl1.Fields[PivotHelper.Month]))
{
e.DisplayText = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName((int)e.Value);
}
}
private void pivotGridControl1_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)
{
if (e.Field != null && e.Field.Name == "fieldExportHeader" && e.ValueType == PivotGridValueType.Value)
{
e.DisplayText = "Export in progress, please wait...";
}
}
void pivotGrid_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)
{
if (e.Field == pivotGrid.Fields[PivotHelper.Month])
{
e.DisplayText = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName((int)e.Value);
}
}
protected void pivotGrid_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)
{
if (Object.Equals(e.Field, pivotGrid.Fields[PivotHelper.Month]))
{
e.DisplayText = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName((int)e.Value);
}
}
private void pvt_datos2_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)
{
/* if (e.Field == COL_GRUPO && e.ValueType == PivotGridValueType.Total)
* {
* e.DisplayText = "TOTAL";
* }
*/
}
private void onFieldValueDisplayText(PivotFieldDisplayTextEventArgs e)
{
if (e.Field != ParameterField)
{
return;
}
e.DisplayText = _parameterDisplayFunc(e.Value.ToString());
}
private void pivotGridControl1_FieldValueDisplayText(object sender,
PivotFieldDisplayTextEventArgs e)
{
if (e.Field == fieldMonth)
{
e.DisplayText =
CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName((int)e.Value);
}
}
private void pivotGridControl1_FieldValueDisplayText(object sender,
PivotFieldDisplayTextEventArgs e)
{
if (e.Field == fieldProduct)
{
IOLAPMember currentMember =
e.Field.GetOLAPMembers().First(m => Object.Equals(m.Value, e.Value));
e.DisplayText +=
string.Format(" ({0:C2})", currentMember.AutoPopulatedProperties["List Price"].Value);
}
}
void pivotGrid_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)
{
if (object.ReferenceEquals(e.Field, fieldOrderDate) && e.Field.GroupInterval == FieldGroupInterval.DateQuarter)
{
e.DisplayText = string.Format("Qtr {0}", e.Value);
if (e.ValueType == FieldValueType.Total)
{
e.DisplayText += " Total";
}
}
}
private void PivotGridControl1_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)
{
if (e.ValueType == PivotGridValueType.GrandTotal)
{
if (e.IsColumn)
{
e.DisplayText = "All Savings";
}
}
if (e.ValueType == PivotGridValueType.Total)
{
if (e.IsColumn)
{
e.DisplayText = e.DisplayText.Replace("Total", "Savings");
}
}
}
void PivotGridControlOnFieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)
{
if ((e.Field != null && (e.Field.Area == PivotArea.DataArea || e.Field.Area == PivotArea.FilterArea)) || (e.Field == null && e.IsColumn))
{
return;
}
var pivotArea = e.Field?.Area ?? PivotArea.RowArea;
var point = new Point(0, e.MinIndex);
var formatInfos = _ruleCollector.FormatInfos(point, pivotArea);
foreach (var formatInfo in formatInfos)
{
if (formatInfo.FormatString.IndexOf("{", StringComparison.Ordinal) > -1)
{
e.DisplayText = formatInfo.GetDisplayText(e.Value);
}
else if (!string.IsNullOrEmpty(formatInfo.FormatString))
{
e.DisplayText = formatInfo.FormatString;
}
}
}
void pivotGridMaster_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)
{
if (e.Field != null && e.Field.FieldEdit != null)
{
e.DisplayText = e.Field.FieldEdit.GetDisplayText(e.Value);
}
}
private void pivotGridControl1_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)
{
if (e.ValueType == DevExpress.XtraPivotGrid.PivotGridValueType.GrandTotal)
if (e.DisplayText == "Grand Total")
e.DisplayText = "Tổng";
else
e.DisplayText = e.DataField.SummaryType.ToString();
}
private void xrPivot_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)
{
}
void m_pvg_main_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)
{
try
{
if (e.ValueType == PivotGridValueType.GrandTotal)
{
e.DisplayText = "Tổng cộng";
}
if (e.ValueType == PivotGridValueType.Total)
{
//e.DisplayText = e.Field.Caption + " " + e.Value;
e.DisplayText = "Tổng";
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
/// <summary> /// Mehrzeilige Texte (bzw. mit Zeilenumbruch) verhindern /// </summary> private void OnFieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e) => e.DisplayText = Regex.Replace(e.DisplayText, @"\s+", " ");
private void pivotGridControl1_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e)
{
if (e.Value != null && e.Field != null && e.Field.FieldEdit != null
&& e.Field.FieldEdit is RepositoryItemLookUpEdit)
{
e.DisplayText =
((RepositoryItemLookUpEdit)e.Field.FieldEdit).GetDisplayValueByKeyValue(e.Value).ToString();
}
}
protected void PivotGrid_FieldValueDisplayText(object sender, PivotFieldDisplayTextEventArgs e) {
if (e.Field==null) return;
switch (e.Field.ID) {
case "tocId_Id":
var toc = Lib.tocIdsDir[(int)e.Value];
var path = toc.parents().Select(p => p.Title).Aggregate((r, i) => r + " / " + i) + " / " + toc.Title;
e.DisplayText = path.Length > 80 ? path.Substring(0, 38) + " ... " + path.Substring(path.Length - 38) : path;
break;
}
}
