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 the sheet configuration file (risksheet.json) under the global object:
global:
  culture: de

How Culture Affects the Grid

The global.culture value is applied to the client-side grid renderer. It changes how cell values are formatted on display (dates, numbers, separators), but it does not change how data is stored in Polarion. Picking the closest culture for your team standardizes how risk records read across locales.

Supported Culture Codes

The Risksheet release supports exactly the following 18 culture codes. Use the code as-is in global.culture.
CodeLanguage / Region
ar-AEArabic (United Arab Emirates)
zhChinese
zh-HKChinese (Hong Kong)
zh-TWChinese (Taiwan)
enEnglish
en-CAEnglish (Canada)
en-GBEnglish (United Kingdom)
frFrench
fr-CAFrench (Canada)
deGerman
heHebrew
hiHindi
jaJapanese
koKorean
ptPortuguese
ruRussian
esSpanish
trTurkish

Culture Code Format

Culture codes follow the IETF BCP 47 standard:
FormatExampleDescription
llen, de, frPrimary language code (ISO 639-1)
ll-CCen-GB, fr-CALanguage 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., en-GB) 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 (Failure Mode and Effects Analysis) sheet configuration using German-language column headers:
global:
  culture: de
headers:
  columnHeader:
    height: 32
  columnGroupHeader:
    height: 32
columns:
  - id: riskId
    header: ID
    bindings: id
    readOnly: true
  - id: failureMode
    header: Fehlerart
    bindings: title
  - id: severity
    header: Bedeutung (B)
    bindings: severity
    type: rating
  - id: occurrence
    header: Auftreten (A)
    bindings: occurrence
    type: rating
  - id: detection
    header: Entdeckung (E)
    bindings: detection
    type: rating
  - id: rpn
    header: RPZ
    formula: commonRpn
  - id: dueDate
    header: Faelligkeitsdatum
    bindings: dueDate
    type: date
formulas:
  commonRpn: "function(info){ var value = info.item['occurrence']*info.item['detection']*info.item['severity']; return value?value:null;}"
With culture: de:
  • The dueDate column displays dates as DD.MM.YYYY (e.g., 15.03.2025)
  • The RPN (Risk Priority Number) column (RPZ) formats numbers with German locale conventions (comma as decimal separator)
  • Column headers use German terminology (Bedeutung, Auftreten, Entdeckung)
Last modified on July 10, 2026