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

4 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,

Mykhailo Halaida Mykhailo Halaida Flexmonster December 15, 2020

Hi Massimo,
We are glad to inform you that it is now possible to choose multiple specific measures to apply number formatting to.
This is provided in the 2.8.22 version of Flexmonster:
You are welcome to update the component:
Please let us know if everything works fine for you.
Best regards,

Mykhailo Halaida Mykhailo Halaida Flexmonster December 22, 2020

Hi Massimo,
Hope you’re doing well!
Just checking in to ask if you’ve had a chance to try out the latest formatting feature we’ve introduced. Have you found it helpful?
We would be happy to hear your feedback.
Kind regards,

Please login or Register to Submit Answer