Skip to main content

​
Configuration Property

PropertyTypeDefaultDescription
global.culturestringenDefines the culture/locale for the Risksheet interface, affecting date formats, number formats, and localization

​
Setting the Culture

Configure the culture in your risksheet.json file under the global object: 
{
  "global": {
    "culture": "de"
  }
}

​
How Culture Affects the Grid

​
Supported Culture Codes

The complete list of supported culture codes depends on the localization library version bundled with your Risksheet release. The following are commonly used codes.

​
Primary Language Codes

CodeLanguageDate FormatNumber Format
enEnglish (US)MM/DD/YYYY1,234.56
en-GBEnglish (UK)DD/MM/YYYY1,234.56
deGermanDD.MM.YYYY1.234,56
frFrenchDD/MM/YYYY1 234,56
esSpanishDD/MM/YYYY1.234,56
itItalianDD/MM/YYYY1.234,56
jaJapaneseYYYY/MM/DD1,234.56
zhChinese (Simplified)YYYY/MM/DD1,234.56
koKoreanYYYY.MM.DD1,234.56
ptPortugueseDD/MM/YYYY1.234,56
nlDutchDD-MM-YYYY1.234,56
svSwedishYYYY-MM-DD1 234,56
csCzechDD.MM.YYYY1 234,56
plPolishDD.MM.YYYY1 234,56

​
Regional Variant Codes

CodeVariantNotes
en-USEnglish (United States)Same as en
en-GBEnglish (United Kingdom)DD/MM/YYYY date format
de-DEGerman (Germany)Standard German
de-ATGerman (Austria)Austrian German
de-CHGerman (Switzerland)Swiss German
fr-FRFrench (France)Standard French
fr-CHFrench (Switzerland)Swiss French
pt-BRPortuguese (Brazil)Brazilian Portuguese
zh-CNChinese (Simplified, China)Simplified Chinese
zh-TWChinese (Traditional, Taiwan)Traditional Chinese

​
Culture Code Format

Culture codes follow the IETF BCP 47 standard:
FormatExampleDescription
llen, de, frPrimary language code (ISO 639-1)
ll-CCen-GB, de-ATLanguage with country/region (ISO 3166-1 alpha-2)
Use the primary language code (e.g., de) for the default regional variant. Use a regional code (e.g., de-CH) only when you need a specific regional format that differs from the language default.

​
Interaction with Polarion Locale

The Risksheet global.culture setting operates independently from Polarion’s server-level locale configuration. The Risksheet culture affects only the grid rendering, not the underlying Polarion data storage format. Dates and numbers are stored in Polarion’s internal format regardless of the display culture.
PropertyTypeDefaultDescription
globalobject{}Global Risksheet settings including culture/locale, help URL, refresh behavior, and menu organization
headers.columnHeader.heightnumber32Height in pixels for column headers
headers.columnGroupHeader.heightnumber32Height in pixels for column group headers

​
Complete Example

A German-locale FMEA configuration using German-language column headers: 
{
  "global": {
    "culture": "de"
  },
  "headers": {
    "columnHeader": {
      "height": 32
    },
    "columnGroupHeader": {
      "height": 32
    }
  },
  "columns": [
    {
      "id": "riskId",
      "header": "ID",
      "binding": "id",
      "readOnly": true
    },
    {
      "id": "failureMode",
      "header": "Fehlerart",
      "binding": "title"
    },
    {
      "id": "severity",
      "header": "Bedeutung (B)",
      "binding": "severity",
      "type": "rating"
    },
    {
      "id": "occurrence",
      "header": "Auftreten (A)",
      "binding": "occurrence",
      "type": "rating"
    },
    {
      "id": "detection",
      "header": "Entdeckung (E)",
      "binding": "detection",
      "type": "rating"
    },
    {
      "id": "rpn",
      "header": "RPZ",
      "formula": "commonRpn"
    },
    {
      "id": "dueDate",
      "header": "Faelligkeitsdatum",
      "binding": "dueDate",
      "type": "date"
    }
  ],
  "formulas": {
    "commonRpn": "function(info){ var value = info.item['occ']*info.item['det']*info.item['sev']; return value?value:null;}"
  }
}
With "culture": "de":
  • The dueDate column displays dates as DD.MM.YYYY (e.g., 15.03.2025)
  • The RPN (RPZ) column formats numbers with German locale conventions (comma as decimal separator)
  • Column headers use German terminology (Bedeutung, Auftreten, Entdeckung)
KB ArticlesSource Code
  • risksheet.json
  • AppConfig.ts