Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Save format cell for individual columns

Resolved
Chris Anderson asked on May 12, 2020

Hi
We are using flexmonster (flexmonster@2.7.17) in our application. The charts are being build dynamically by the users based on the CSV data we feed to flexmonster. While trying to build the charts, in grid view, we use the format cell option to format columns in grid view.
While we are able set using “All values”, save it and when viewing next time, able to retrieve the format.
Is there a similar way to same the format cell applied to individual columns? We are using the getFormat() and setFormat() API calls. How to retrieve any format applied to individual columns?
The getFormat API needs a name of the column I think. It does not return the columns or fields to which any custom format has been applied. As the formatting is dynamic, we wouldn’t know which fields or columns have custom formatting. So currently, we are suggesting to use “All values”. But, there are cases where we need different formatting for different columns. We need ability to save these custom formats and apply them again when viewing data the next time on.
Please let us know if you need more information.
Many thanks,
Chris

4 answers

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster May 13, 2020

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

Public
Chris Anderson May 14, 2020

Hi Mykhailo,
Thanks for responding. The above makes sense if you want to set it programmatically.
What we are looking to achieve is to allow the end user to set the format for individual columns using the flexmonster object (Under formats -> format cell). We need an ability to save these custom formats set by user so that they can be reapplied when the user revisits the report.
Hope I am clear on what we are looking for.
Many thanks,
Chris

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster May 15, 2020

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

Public
Chris Anderson May 18, 2020

Thanks Mykhailo, we actually found a different way to do this based on our implementation but the above has helped. Marking as resolved to help others. Thanks

Please login or Register to Submit Answer