Data rendering (formatting) and editing in Risksheet

Modified on Mon, 28 Jul at 1:51 PM

The data format is influenced by two settings:

The country/culture set in Countries - supported in the Globalization > Cultures
The format of the column in Risksheet Document Config File - risksheet.json - format reference

On this page, we describe the available formats you can use in settings #2

The examples are rendered with country/culture set to default, i.e., en (English/US).

TABLE OF CONTENTS

Configuration
Numbers
Dates

Configuration

Date example

Add the property "format": "d", to your desired column.

      "headerGroup": "Potential Failure",
      "headerGroupCss": "headPotentialRisks",
      "headerCss": "headPotentialRisks",
      "header": "Date of Birth",
      "bindings": "dob",
      "id": "dob",
      "format": "d",
      "filterable": true,
      "width": 150,
      "collapseTo": true,
      "level": 2

As a result, you can see the format of the date has changed to Short Date Pattern - MM-DD-YYYY.

Numbers

Note: the * below refers to a number, e.g., * = 2 means the number to two decimal places.

Format	description	result
n*	Number	1,234.57
*n,**	Number (thousands)	1.23
*n,,**	Number (millions)	0.00
f*	Fixed-point	1234.57
g*	General (no trailing zeros)	1234.57
d*	Decimal (integers)	1235
x*	Hexadecimal (integers)	4d3
c*	Currency	$1,234.57
*c€**	Currency (explicit currency symbol)	€1,234.57
c*	Currency (no currency symbol)	1,234.57
p*	Percent	123,457.00%

Dates

Format	description	result
d	Short Date Pattern	2/6/2021
D	Long Date Pattern	Saturday, February 06, 2021
f	Full Date/Time Pattern (short time)	Saturday, February 06, 2021 1:36 PM
F	Full Date/Time Pattern (long time)	Saturday, February 06, 2021 1:36:27 PM
t	Short Time Pattern	1:36 PM
T	Long Time Pattern	1:36:27 PM
'Q'Q yyyy	Quarter/Year	Q1 2021
MMMM dd, yyyy	Custom format	February 06, 2021

For any assistance, please don’t hesitate to reach out by submitting a ticket here.