Data Rendering"

From Documentation
Line 22: Line 22:
 
 
 
@Override
 
@Override
public String renderCell(Object data, Pivottable table, PivotHeaderContext rowContext,  
+
public String renderCell(Number data, Pivottable table,  
PivotHeaderContext columnContext, PivotField dataField) {
+
PivotHeaderContext rowContext, PivotHeaderContext columnContext,
return data == null ? "" : data instanceof Integer ? _nnf.format(data) : _fnf.format(data);
+
PivotField dataField) {
 +
return data == null ? "" :
 +
data instanceof Integer ? _nnf.format(data) : _fnf.format(data);
 
}
 
}
 +
 +
@Override
 +
public int getColumnSize(Pivottable table, PivotHeaderContext colc,
 +
PivotField field) {
 +
return colc.isGrandTotal() && field != null ? 150 : 100;
 +
}
 +
 +
@Override
 +
public int getRowSize(Pivottable table, PivotHeaderContext rowc,
 +
PivotField field) {
 +
return 20;
 +
}
 +
 
@Override
 
@Override
 
public String renderField(Object data, Pivottable table, PivotField field) {
 
public String renderField(Object data, Pivottable table, PivotField field) {
return field.getType() == PivotField.Type.DATA ?  
+
return field.getType() == PivotField.Type.DATA ?
field.getTitle() : data == null ? "(null)" : String.valueOf(data);
+
field.getTitle() : data == null ? "(null)" : String.valueOf(data);
 
}
 
}
 +
 
@Override
 
@Override
 
public String renderGrandTotalField(Pivottable table, PivotField field) {
 
public String renderGrandTotalField(Pivottable table, PivotField field) {
Line 36: Line 52:
 
return "Grand Total of " + field.getTitle();
 
return "Grand Total of " + field.getTitle();
 
}
 
}
 +
 
@Override
 
@Override
public String renderSubtotalField(Object data, Pivottable table, PivotField field, Calculator calculator) {
+
public String renderSubtotalField(Object data, Pivottable table,  
String calLabel = Texts.capitalize(calculator.getType());
+
PivotField field, Calculator calculator) {
 +
String calLabel = calculator.getLabel();
 
String dataLabel = data == null ? "Null" : data.toString();
 
String dataLabel = data == null ? "Null" : data.toString();
 
return dataLabel + " " + calLabel;
 
return dataLabel + " " + calLabel;
 
}
 
}
 +
 
@Override
 
@Override
public int getColumnSize(Pivottable table, PivotHeaderContext colc, PivotField field) {
+
public String renderDataField(PivotField field) {
return colc.isGrandTotal() && field != null ? 150 : 100;
+
return field.getFieldName();
}
 
@Override
 
public int getRowSize(Pivottable table, PivotHeaderContext rowc, PivotField field) {
 
return 20;
 
 
}
 
}
 +
 
@Override
 
@Override
public String renderCellSClass(Object data, Pivottable table, PivotHeaderContext rowContext,  
+
public String renderCellSClass(Number data, Pivottable table,
PivotHeaderContext columnContext, PivotField dataField) {
+
PivotHeaderContext rowContext, PivotHeaderContext columnContext,
 +
PivotField dataField) {
 
return null;
 
return null;
 
}
 
}
 +
 
@Override
 
@Override
public String renderCellStyle(Object data, Pivottable table, PivotHeaderContext rowContext,  
+
public String renderCellStyle(Number data, Pivottable table,
PivotHeaderContext columnContext, PivotField dataField) {
+
PivotHeaderContext rowContext, PivotHeaderContext columnContext,
 +
PivotField dataField) {
 
return null;
 
return null;
 
}
 
}
 
+
 
}
 
}
 
</source>
 
</source>

Revision as of 04:09, 11 July 2012


The rendering of Pivottable is defined by a PivotRenderer. You set your custom renderer by calling setPivotRenderer() method on Pivottable, or leave it null to use the default PivotRenderer.

PivotRenderer determines:

  • How data Object in each cell (either in column, row, or data field) is converted to String for display
  • Column and Row sizes

In addition, you can implement PivotRendererExt (which extends from PivotRenderer), which determines:

  • Custom sclass (CSS class) and/or style on data cells.


SimplePivotRenderer

We have provided SimplePivotRenderer, a basic implementation of PivotRendererExt, to be the default renderer and a skeleton class to extend from.

public class SimplePivotRenderer implements PivotRendererExt {
	
	private DecimalFormat _fnf = new DecimalFormat("##,###.00");
	private DecimalFormat _nnf = new DecimalFormat("##,###");
	
	@Override
	public String renderCell(Number data, Pivottable table, 
			PivotHeaderContext rowContext, PivotHeaderContext columnContext,
			PivotField dataField) {
		return data == null ? "" :
				data instanceof Integer ? _nnf.format(data) : _fnf.format(data);
	}
	
	@Override
	public int getColumnSize(Pivottable table, PivotHeaderContext colc, 
			PivotField field) {
		return colc.isGrandTotal() && field != null ? 150 : 100;
	}
	
	@Override
	public int getRowSize(Pivottable table, PivotHeaderContext rowc, 
			PivotField field) {
		return 20;
	}
	
	@Override
	public String renderField(Object data, Pivottable table, PivotField field) {
		return field.getType() == PivotField.Type.DATA ?
				field.getTitle() : data == null ? "(null)" : String.valueOf(data);
	}
	
	@Override
	public String renderGrandTotalField(Pivottable table, PivotField field) {
		if (field == null) return "Grand Total";
		return "Grand Total of " + field.getTitle();
	}
	
	@Override
	public String renderSubtotalField(Object data, Pivottable table, 
			PivotField field, Calculator calculator) {
		String calLabel = calculator.getLabel();
		String dataLabel = data == null ? "Null" : data.toString();
		return dataLabel + " " + calLabel;
	}
	
	@Override
	public String renderDataField(PivotField field) {
		return field.getFieldName();
	}
	
	@Override
	public String renderCellSClass(Number data, Pivottable table,
			PivotHeaderContext rowContext, PivotHeaderContext columnContext,
			PivotField dataField) {
		return null;
	}
	
	@Override
	public String renderCellStyle(Number data, Pivottable table,
			PivotHeaderContext rowContext, PivotHeaderContext columnContext,
			PivotField dataField) {
		return null;
	}
	
}

Data display

To customize data display, override renderCell, renderField, renderGrandTotalField, and renderSubtotalField respectively.

Column and row sizes

To customize the initial size of columns and rows, override getColumnSize and getRowSize.

Custom CSS

To provide custom CSS class or custom style on data cell, override renderCellSClass or renderCellStyle.

Samples of such customization can be found in the source code of Pivottable demo.


 

PivotHeaderContext

This class is commonly used in the arguments of PivotRenderer (or PivotRendererExt, PivotUIEvent, etc) methods. It represents a position (a slot) on either row or column axis. For example, the following method in PivotRenderer has two PivotHeaderContext object, for row and column respectively:

	public String renderCellSClass(Object data, Pivottable table,
			PivotHeaderContext rowContext, PivotHeaderContext columnContext,
			PivotField dataField) {
		...
	}

The header contexts and data fields corresponding to a cell are illustrated as the following:

ZKPvtEsn HeaderContext 02.png

ZKPvtEsn HeaderContext 03.png


 

Version History

Last Update : 2012/07/11


Version Date Content
     



Last Update : 2012/07/11

Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License.