Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Custom Expressions
Created by Guest
Created on Feb 6, 2016

Location invariant value formats in expressions

As an author, I need to control the exact format of my data so that I can properly configure the rest of my analysis. Regional language and cultural settings are client dependent and therefore dates and decimal separators change depending on my client computer/browser configuration.

I need an option to have the dates and decimal separators NOT be dependent on local cultural settings, but be globally defined and static within Spotfire

For example, if I need to use a date column as an input to an expression or script I might need to ensure that the date is in the format MM/DD/YYYY and cannot change.

The forum post mentioned above was due to an expression expecting a period separator with an expression like: when [My Binned Column Name]="x _ 0.00"
But that was failing when a comma separator was used due to local client setting since the binned column was named "x _ 0,00"

There are many other examples where this type of control would be extremely valuable for authors.

Applicable to local installed client and Web Player.

  • Attach files
  • Guest
    Feb 9, 2024

    This seems to be similar to:




    TS-I-7379 ?

    TS-I-6172 ?

  • Guest
    Aug 17, 2016

    Have it depend on the Spotfire server time settings. so everything is in line and everyone receives the same outputs.

    also, week numbers can differ now when using the client  with different locale.


Lock date formatting, culture settings, of an analysis.

I would like to lock (set explicitly) the date formatting, or value formatting at all, within an analysis opened in the Web Player. Currently the different language/culture settings in the web browsers will make it impossible for them to work with...
over 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

Set start of week in calculations independent of regional settings

On using date hierarchies, is Spotfire's definition of a WEEK's start and end days (e.g., Monday to Sunday) entirely dependent on the regional settings of the computer being used? We have a bar chart that presents the weekly volume of IT service r...
over 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

enforce numerical representation of the decimal

Our international organisation has different language settings in local machines, and in the servers. This leads to confusion with the use of the decimal point or comma. Can in the presentation of the report a setting be added to enforce the decim...
over 1 year ago in Spotfire / Visualization 2 Future Consideration