Save format cell for individual columns

Hi Chris,
 
Thank you for posting your question.
 
Please note that you can set a single number format for all hierarchies in the grid by creating a format object with the name: "" property. If, however, you would like to apply different number formats to different columns, you would need to create several format objects and assign specific names to each of them, for example:
 

formats: [
    {
        name: "currencyFormat",
        currencySymbol: "$"
    },
    {
        name: "amountFormat",
        currencySymbol: " pcs."
    }
],

 
After this, you need to reference the defined formats by their name property in the corresponding measures' definitions inside the slice:
 

slice: 
    ...
    measures: [
        {
            uniqueName: "Price"
            format: "currencyFormat" 
        },
        {
            uniqueName: "Discount" 
            format: "currencyFormat" 
        },
        {
            uniqueName: "Quantity"
            format: "amountFormat" 
        }
    ]
},

 
This way, you will be able to restore the current report configurations with the defined number formatting already active from the get-go. Check out the following JSFiddle sample illustrating this approach: https://jsfiddle.net/flexmonster/qxyse7n6/
 
In order to change the number formatting for a specific hierarchy, the setFormat() API call needs to be used. setFormat() receives 2 parameters: format – the format object you want to apply to the hierarchy, and the measureName – the name of the measure you want to apply the format to. Similarly, getFormat() receives 1 parameter – measureName, and returns the format applied to the hierarchy with the name equal to measureName parameter.
 
Also, please note that if the measureName is not specified in the mentioned API calls, the current default number formatting is returned or applied depending on the method.
 
Feel free to check out the following documentation page for a detailed overview of how number formatting works in Flexmonster: https://www.flexmonster.com/doc/number-formatting/
 
Please let us know if this helps.
 
Best regards,
Mykhailo

Hi Chris,
 
Thank you for your swift reply.
 
The mentioned "Format cells" toolbar tab can actually be used to set formats for individual hierarchies as well. Please note that the necessary hierarchies have to already be active (selected to be displayed as measures in the Field List) – once they are, you can select them for formatting in the "Format cells" pop-up window dropdown.
 
In case the above still does not work on your side, we would appreciate it if you could send us your report configurations so that we can investigate this further.
 
Speaking of the ability to save the current formats, this can easily be achieved with the save() API call, which is also the default handler for the "Save" toolbar tab. This API call lets you save the current report configurations (including formats) in their current state to a local JSON file, which can later be loaded back with the open() API call to restore those configurations at any point in the future.
 
In addition to the above, it might also be helpful to track the changes in the report made by the user with the reportchange event, in case this is something that would help you.
 
We hope this helps!
 
Regards,
Mykhailo