How to change default negativeCurrencyFormat/positiveCurrencyFormat in format popup

Answered
viguier asked on January 21, 2022

Hello,
We would like to change the default format of the negativeCurrencyFormat and positiiveCurrencyFormat proposed in the format popup:

  • we have defined pivot format by default and specific formats for some values with negativeCurrencyFormat at "-1$" and positiveCurrencyFormat "1$", the format is respected in the pivot
  • Although when we modify the format of a value with the popup the currency format selected by default is always '-$1'/'$1', and we have to change it manually each time

Is there a way to 'force' the format popup to select the '1$'/'-1$' by default?
Many thanks

3 answers

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster January 24, 2022

Hello, Viguier,
 
Thank you for reaching out to us.
 
To define the default formatting in your report, you can create a format with the empty name property. For, example:

formats: [{
   name: "",
   negativeCurrencyFormat: "-1$",
   positiveCurrencyFormat: "1$",
}]

Kindly check the following example illustrating such an approach: https://jsfiddle.net/flexmonster/sqp2ru4b/. If you open the format popup, you will see that the suggested Positive currency format and Negative currency format will be those defined in the report.
 
We hope it helps.
 
Kind regards,
Nadia

Public
viguier January 28, 2022

Hello,
We have define default formatting and specific formatting for the different values but we still don't see the defined Positive currency format and negative currency format by default in the popup. Would you hava another direction for us to investigate?
We are using the 2.7.14 version of flexmonster.

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster January 31, 2022

Hello,
 
Thank you for the response.
 
The behavior of the default formatting was improved in some of the recent releases. We suggest updating Flexmonster to the latest version.
Kindly note that for a comfortable and quick migration to the new major version, it is essential to look through our migration guides:

Please let us know if it works for you.
 
Kind regards,
Nadia

Please login or Register to Submit Answer