This would seem easy but I've not been able to figure out how to change the GrandTotalHeaderColumn text.
I am able to change column text for regular columns like this:
if (IsModelDataCellPlannedHeader(modelDataCell))
{
e.ExportedCell.Value = "Plan";
}
private static bool IsModelDataCellPlannedHeader(PivotGridBaseModelCell modelDataCell)
{
return modelDataCell.TableCellType == PivotGridTableCellType.ColumnHeaderCell &&
modelDataCell.Field.UniqueName == "Plan";
}
This works fine but I cannot figure out how to tell if a column is a GrandTotalColumn.
This code does not work:
private static bool IsModelDataCellPlanGrandTotalHeaderColumn(PivotGridBaseModelCell modelDataCell)
{
if (modelDataCell.TableCellType == PivotGridTableCellType.ColumnHeaderCell &&
modelDataCell.CellType == PivotGridDataCellType.ColumnGrandTotalDataCell &&
modelDataCell.Field.UniqueName == "plannedValue")
{
return true;
}
if (modelDataCell.TableCellType == PivotGridTableCellType.ColumnHeaderCell &&
modelDataCell.CellType == PivotGridDataCellType.RowGrandTotalColumnTotal &&
modelDataCell.Field.UniqueName == "plannedValue")
{
return true;
}
return false;
}
Obviously I was just shooting in the dark. It would be nice if there was a TableCellType of GrandTotalColumnHeader. That would seem to make sense.
Let me know if there is a way to do what I'm trying to do.
Thanks!