Formatters can be chained with dynamic parameters to create complex operations, check out the example in .

convCurr( target, source )

• converts from one currency to another

• exchange rates are included by default

  • you can provide a new exchange rate for one report in options.currencyRates of Carbone.render or globally with Carbone.set

• convCurr() without parameters converts automatically from options.currencySource to options.currencyTarget

Examples

round( precision )

• rounds a number

• same as toFixed() but it rounds number correctly round(1.05, 1) = 1.1

Examples

formatN( precision )

• formats number according to the locale

• applying a number of decimals depends on the report type:

  • for ODS/XLSX, the number of decimals has to be formatted based on the text editor

  • for the other type of files, the number of decimals depends on the precision parameter passed to the formatter

Examples

formatC( precisionOrFormat )

Examples

add( )

Adds 2 numbers.

Examples

sub( )

Subtracts 2 numbers.

Examples

mul( )

Multiplies 2 numbers.

Examples

div( )

Divides 2 numbers.

Examples

int( )

Converts a number to an INT.

toEN( )

Converts a number with English specifications (decimal separator is a dot .).

toFixed( )

Converts a number into string, keeping only decimals.

toFR( )

Converts a number with French specifications (decimal separator is a comma ,).