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

Formatting Requirements

Massimo asked on February 7, 2020

I would like to share with you a few requirements that my company received from our partners and customer regarding the usability of a tool built upon the Flexmonster pivot:
Format Cells
Currently it is possible to apply cell format to all measures or just one (in your demo “All Values” or Price). It would be very useful having an option to apply the format to a subset of measures of user’s choice.   
Conditional formatting-1
Currently it is possible to change the background colour of a cell based on an expression. It would be useful if we could choose the type of colour fill (i.e. bucket, gradient, solid border, dot border, etc.)
Conditional formatting-2
Currently it is not possible to show an icon within a cell based on an expression. It would be nice to add this option in the conditional formatting popup.
Column Auto-fit
It would be useful to have an “auto fit” option or api to automatically fit all columns width based on their content.
Could you please take into account the above requirements for future releases?  
Thank you in advance

2 answers

Mykhailo Halaida Mykhailo Halaida Flexmonster February 10, 2020

Hi Massimo,
Thank you for sharing your suggestions on Flexmonster functionality. Let us address the mentioned points below:
Format Cells:
This request seems reasonable to us, so we’ve added it to our wishlist and we will make sure to inform you if there are any updates on this matter.
In the meantime, a potential workaround is to customize the number formatting configurations view on your side and use the setFormat() API call to apply number formatting to multiple measures. Here’s a quick example on how to use setFormat() in this context:
Conditional formatting-1:
Further visual cell customization is somewhat more difficult to implement due to certain technical aspects. Nevertheless, this feature seems reasonable to us as well, so our team will take a deeper look into this and we’ll see what can be done in this regard in future Flexmonster releases.
Meanwhile, as a workaround, we suggest using the customizeCell() API call to modify the type of the background color of a cell, as well as any other CSS configurations. We’ve prepared a JSFiddle sample on how to add gradient to the background of specific cells: 
Conditional formatting-2:
Cell values can be represented by icons of your choice using the customizeCell() API call as well. One of our demos displays a way to implement this functionality:
For more information on customizeCell() method feel free to check out the following documentation page:
Column Auto-fit:

Kindly note that auto-width for columns in the grid is enabled by default, making the width of the columns depend on the cells’ content. It is, however, also a subject to restrictions of default `min-width: 100px` and `max-width: 420px`, regardless of the visual length of the data inside the cell. These restrictions can easily be overridden as one desires:

#fm-pivot-view .fm-grid-column {
min-width: 200px;
max-width: 500px;

Moreover, in case the column’s width was modified by the user in real-time, it can be reset back to default auto-width by double-clicking the column header with the column index.
You can find more information on CSS customization by the following link:
We hope the information above was helpful. Please let us know if you have any other questions we can help you with.
Best regards,

Massimo February 24, 2020

Hi Mykhailo,
thank you for taking in consideration for future releases the functionalities we require.
I’m looking forward for your feedbacks as soon as you’ll have a roadmap for them.
Best regards,

Please login or Register to Submit Answer