> ## Documentation Index
> Fetch the complete documentation index at: https://learn.nextedy.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Culture and Localization Codes

> Nextedy RISKSHEET supports culture-based localization through the `global.culture` configuration property.

export const LastReviewed = ({date}) => {
  if (!date) return null;
  const formatted = new Date(`${date}T00:00:00Z`).toLocaleDateString("en-US", {
    year: "numeric",
    month: "long",
    day: "numeric",
    timeZone: "UTC"
  });
  return <p className="mt-10 text-sm text-gray-400 dark:text-zinc-500 not-prose">
      Last reviewed on {formatted}
    </p>;
};

## Configuration Property

| Property         | Type     | Default | Description                                                                                                      |
| ---------------- | -------- | ------- | ---------------------------------------------------------------------------------------------------------------- |
| `global.culture` | `string` | `en`    | Defines 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:

```yaml theme={null}
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`.

| Code    | Language / Region             |
| ------- | ----------------------------- |
| `ar-AE` | Arabic (United Arab Emirates) |
| `zh`    | Chinese                       |
| `zh-HK` | Chinese (Hong Kong)           |
| `zh-TW` | Chinese (Taiwan)              |
| `en`    | English                       |
| `en-CA` | English (Canada)              |
| `en-GB` | English (United Kingdom)      |
| `fr`    | French                        |
| `fr-CA` | French (Canada)               |
| `de`    | German                        |
| `he`    | Hebrew                        |
| `hi`    | Hindi                         |
| `ja`    | Japanese                      |
| `ko`    | Korean                        |
| `pt`    | Portuguese                    |
| `ru`    | Russian                       |
| `es`    | Spanish                       |
| `tr`    | Turkish                       |

## Culture Code Format

Culture codes follow the IETF BCP 47 standard:

| Format  | Example          | Description                                       |
| ------- | ---------------- | ------------------------------------------------- |
| `ll`    | `en`, `de`, `fr` | Primary language code (ISO 639-1)                 |
| `ll-CC` | `en-GB`, `fr-CA` | Language with country/region (ISO 3166-1 alpha-2) |

<Tip title="Choosing a Culture Code">
  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.
</Tip>

## 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.

## Related Configuration

| Property                           | Type     | Default | Description                                                                                           |
| ---------------------------------- | -------- | ------- | ----------------------------------------------------------------------------------------------------- |
| `global`                           | `object` | `{}`    | Global Risksheet settings including culture/locale, help URL, refresh behavior, and menu organization |
| `headers.columnHeader.height`      | `number` | `32`    | Height in pixels for column headers                                                                   |
| `headers.columnGroupHeader.height` | `number` | `32`    | Height in pixels for column group headers                                                             |

## Complete Example

A German-locale FMEA (Failure Mode and Effects Analysis) sheet configuration using German-language column headers:

```yaml theme={null}
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`)

## Related Pages

* [Configuration Properties Index](/risksheet/reference/configuration/properties-index) -- full property reference
* [Sheet Configuration Format](/risksheet/reference/configuration/risksheet-json-format) -- sheet configuration file structure
* [Default Configuration Values](/risksheet/reference/configuration/default-values) -- all default property values
* [Date and Time Columns](/risksheet/reference/columns/date-time-columns) -- date column formatting options

<LastReviewed date="2026-06-09" />
