All functions

bhmtraindisruption

Birmingham Train Disruptions, Dec 2016-Feb 2017.

bhmtrains

Birmingham Trains, Dec 2016-Feb 2017.

checkArgument()

Perform basic checks on a function argument.

cleanCssValue()

Cleans up a CSS attribute value.

cleanOutlineArg()

Clean the arguments specified for an outline group

containsText()

Check whether a text value is present in another text value.

convertPvtStyleToBasicStyle()

Convert a pivot table style to a basictabler style.

convertPvtTblToBasicTbl()

Convert a pivot table to a basic table.

exportValueAs()

Replace the current value with a placeholder during export.

getBlankTheme()

Get an empty theme for applying no styling to a table.

getCompactTheme()

Get the compact theme for styling a pivot table.

getDefaultTheme()

Get the default theme for styling a pivot table.

getLargePlainTheme()

Get the large plain theme for styling a pivot table.

getNextPosition()

Find the first value in an array that is larger than the specified value.

getPvtStyleDeclarations()

Get pivot table style declarations from a pivot table style.

getSimpleColoredTheme()

Get a simple coloured theme.

getStandardTableTheme()

Get the a theme for styling to a pivot table that looks more like a standard table (i.e. no row column headings).

getTheme()

Get a built-in theme for styling a pivot table.

getXlBorderFromCssBorder()

Convert CSS border values to those used by the openxlsx package.

getXlBorderStyleFromCssBorder()

Convert CSS border values to those used by the openxlsx package.

isNumericValue()

Check whether a numeric value is present.

isTextValue()

Check whether a text value is present.

oneToNULL()

Convert a value of 1 to a NULL value.

parseColor()

Convert a CSS colour into a hex based colour code.

parseCssBorder()

Parse a CSS border value.

parseCssSizeToPt()

Convert a CSS size value into points.

parseCssSizeToPx()

Convert a CSS size value into pixels

parseCssString()

Split a CSS attribute value into a vector/array.

parseXlBorder()

Parse an xl-border value.

PivotBatch

R6 class the represents a Calculation Batch

PivotBatchCalculator

R6 class that calculates the values for multiple cells in batches.

PivotBatchStatistics

R6 class that provides summary statistics for batch calculations.

PivotCalculation

R6 class that defines a calculation.

PivotCalculationGroup

R6 class that defines a group of calculations.

PivotCalculationGroups

R6 class that contains multiple calculation groups.

PivotCalculator

R6 class that computes the value of a cell or cells.

PivotCell

R6 class that represents a cell in a pivot table.

PivotCells

R6 class that contains the cells in a pivot table.

PivotData

R6 class that contains named data frames and associated totals.

PivotDataGroup

R6 class that defines a row or column data group.

PivotFilter

R6 class that defines a filter condition.

PivotFilterOverrides

R6 class that defines a set of filter overrides.

PivotFilters

R6 class that defines a set of filter conditions.

PivotHtmlRenderer

R6 class that renders a pivot table in HTML.

PivotLatexRenderer

R6 class that renders a pivot table in Latex.

PivotOpenXlsxRenderer

R6 class that renders a pivot table into an Excel worksheet.

PivotOpenXlsxStyle

R6 class that specifies Excel styling as used by the openxlsx package.

PivotOpenXlsxStyles

R6 class that defines a collection of Excel styles as used by the openxlsx package.

PivotStyle

R6 class that specifies styling.

PivotStyles

R6 class that defines a collection of styles.

PivotTable

R6 class that represents a pivot table.

pivottabler()

Render a pivot table as a HTML widget.

pivottablerOutput()

Standard function for Shiny scaffolding.

processIdentifier()

Handle an identifier that may be illegal (e.g. containing spaces).

processIdentifiers()

Handle identifiers that may be illegal (e.g. containing spaces).

pvtperfresults

Performance Comparison Results

pvtperfsummary

Performance Comparison Summary

qhpvt()

Quickly render a basic pivot table in HTML.

qlpvt()

Quickly get a Latex representation of a basic pivot table.

qpvt()

Quickly build a basic pivot table.

renderBasicTable()

Output a table into a package vignette.

renderPivottabler()

Standard function for Shiny scaffolding.

skipExportingValue()

Should the current value be skipped during export?

trainstations

Train Stations

vreConvertSimpleNumericRange()

Convert a simple range expression to a standard R logical expression.

vreGetSingleValue()

Read the value from a single-valued value range expression.

vreHexToClr()

Convert a colour in hex format (#RRGGBB) into a list.

vreIsEqual()

Test if two numeric values are equal within tolerance.

vreIsMatch()

Test whether a value matches a value range expression.

vreIsSimpleNumericRange()

Determine if a value range expression is a simple range expression.

vreIsSingleValue()

Determine if a value range expression is a single value.

vreScale2Colours()

Scale a number from a range into a colour gradient.

vreScaleNumber()

Rescale a number from one range into another range.