Page Comparison

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

...

Table plus

highlightColor	#ffffec
rowStyles	background:#f0f0f0;color:#222;font-size:14px;border-bottom:black 2px solid;border-top:black 2px solid;,
style	background-color:white;

Numbers

Value (Original)	Format Definition	Value (Formatted)
10000	'0,0.0000'	10,000.0000
10000.23	'0,0'	10,000
10000.23	'+0,0'	+10,000
-10000	'0,0.0'	-10,000.0
10000.1234	'0.000'	10000.123
10000.1234	'0[.]00000'	10000.12340
-10000	'(0,0.0000)'	(10,000.0000)
-0.23	'.00'	-.23
-0.23	'(.00)'	(.23)
0.23	'0.00000'	0.23000
0.23	'0.0[0000]'	0.23
1230974	'0.0a'	1.2m
1460	'0 a'	1 k
-104000	'0a'	-104k
1	'0o'	1st
52	'0o'	52nd
23	'0o'	23rd
100	'0o'	100th

Currency

Value (Original)	Format Definition	Value (Formatted)
1000.234	'$0,0.00'	$1,000.23
1000.2	'0,0[.]00 $'	1,000.20 $
1001	'$ 0,0[.]00'	$ 1,001
-1000.234	'($0,0)'	($1,000)
-1000.234	'$0.00'	-$1000.23
1230974	'($ 0.00 a)'	$ 1.23 m

Bytes

Value (Original)	Format Definition	Value (Formatted)
100	'0b'	100B
2048	'0 b'	2 KB
7884486213	'0.0b'	7.3GB
3467479682787	'0.000 b'	3.154 TB

Percentages

Value (Original)	Format Definition	Value (Formatted)
1	'0%'	100%
0.974878234	'0.000%'	97.488%
-0.43	'0 %'	-43 %
0.43	'(0.000 %)'	43.000 %

Time

Value (Original)	Format Definition	Value (Formatted)
25	'00:00:00'	0:00:25
238	'00:00:00'	0:03:58
63846	'00:00:00'	17:44:06

Examples

The following example shows how numeric values can be converted in total rows:

...

The format can be automatically switch to support various international differences by adding a language parameter to the format.

Tip
A list of the languages available and their specification is

...

available here.

...

For example:

Table plus

ColumnType	Value	Formatted Value
FF"(de)0,0.00 $"	1.234,5	1 234,50 €
FF"(fr)$0,0.00"	1 234,5	€1 234,50

Include Page

	_SupportFooter
	_SupportFooter