Exago Logo
Search
Generic filters
Exact matches only

Culture Settings

This article applies to the Admin Console > TreeGeneral.png General > TreeGeneralNode.png Culture Settings.


Introduction

The Culture Settings give administrators control over formats and symbols that vary amongst geographic location. These settings can be overwritten for a specific user or group of users by modifying the Role. For more information see Roles.

Settings

The following settings are available:

Date Format

The format of date values. May be any .NET standard (e.g., MM/dd/yyyy).

Time Format

The format of time values. May be any .NET standard (e.g., h:mm:ss tt).

DateTime Format

The format of date-time values. May be any .NET standard (e.g. M/d/yy h:mm tt).

Note

For more information on .NET Date, Time, and DateTime format strings please visit this MSDN article.

Date Time Values Treated As

Choose to format DateTime as Date or DateTime values. To change this setting for specific columns see Column Metadata.

Note

Column metadata will override culture settings.

Numeric Separator Symbol

Symbol used to separate 3 digit groups (ex. thousandths) in numeric values. The default is a comma (,).

Numeric Currency Symbol

Symbol prepended to numeric values to represent currency. The default is the US currency symbol ($).

Numeric Decimal Symbol

Symbol used for numeric decimal values. The default is a period (.).

Numeric Decimal Places

The default number of decimal places to show when a cell format is set to display a Number or when column metadata or the data source identifies the value is a number data type. This value is also the default value presented to users in the Report Designer Cell Formatting dialog. Default is -1 which will show two decimal places. Values between -1 and 8 are accepted.

Currency Decimal Places

The default number of decimal places to show when a when column metadata or the data source identifies the value is a currency data type. Default is -1 which will show two decimal places. Values between -1 and 8 are accepted.

Apply Numeric Decimal Places to General Cell Formatting

Set to true to apply the Numeric Decimal Places to any cell that has Cell Formatting set to General but contains a number. Default value is false.

Apply General Currency Right Alignment

Set to true to cause currency values to appear right-aligned by default in report cells.

Server Time Zone Offset

A decimal value used to convert server to client time (the negation is used to convert client to server time). This offset is not applied to data coming from Data Sources. It is utilized by Exago features like the Scheduler Service. Set to 0 to use server time or null to use the External Interface (a deprecated extensibility feature) to calculate the time zone change. This value should be set to 0 if a Time Zone Name is selected.

Note

A Server Time Zone Offset is only required if a Client Time Zone Name cannot be provided. Otherwise, all scheduling calculations will be performed using the provided time zone information.

Time Zone Name

Default geopolitical location of the client as determined by the IANA time zone database (e.g., America/New_York). Utilized by Exago to properly resolve scheduling issues centering around DST and other non-linear time zone conflicts. The setting is also used for other time and date related features in the application such as Date/Time functions like Now().

Note

For a full list of official IANA time zones and their relative UTC offsets, please reference this Wikipedia article.

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Table of Contents