On each Oracle Smart View for Office client machine, Windows system locales must match that of Smart View in order for any data (numbers, dates, currencies, percentages) to be interpreted correctly.
The following are the applicable Windows system locales:
Smart View language option
Microsoft Office language
Windows Regional Settings
Windows operating system
When working with Oracle Analytics Cloud data sources, in cases of mismatched Windows system locales, data may display incorrectly, or formatting may be ignored and plain data rendered instead.
An example of a Windows system locale mismatch is the Windows operating system, Regional Settings, and Office language in English, and Smart View in Russian.
When locale mismatches occur, the Smart View log indicates a warning such as the following: "Encountered mismatched locale. Chart will use unformatted data values."