Get Free Trial

How to restrict some columns not to format

Answered
raviteja asked on October 4, 2022

HI Team, I have some Percentage formats(%) and user should not change its format.
How to restrict some measures not to format.
In the format cell popup I should not get list some measures.
 

3 answers

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster October 5, 2022

Hello, Ravi!
 
Thank you for reaching out to us.
 
Kindly note that the number formatting pop-up we provide as a part of the Toolbar is designed to show all existing measures. If you want some measures to be hidden in the dropdown, we suggest creating a custom number formatting pop-up instead of the built-in one.
 
The algorithm is the following:
 
1. Add a new tab to the Toolbar using the beforetoolbarcreated event.
Here is the JSFiddle example with adding a new tab: https://jsfiddle.net/flexmonster/m7e74ay4/.
You can find more details about customizing the Toolbar in our docs: https://www.flexmonster.com/doc/customizing-toolbar/.
 
2. (optional) Remove the existing ‘Number formatting’ tab from the submenu.
We have prepared the JSFiddle example for visualization: https://jsfiddle.net/flexmonster/2nqLxfrk/.
 
3. Create your own pop-up for number formatting, where you can prefilter fields with percentages before displaying the drop-down.
You can look through the flexmonster/toolbar/flexmonster.toolbar.js file with our Toolbar source code for references. The main pop-up functionality for number formatting can be found in the FlexmonsterToolbar.prototype.showFormatCellsDialog function.
 
Hope you will find our answer helpful.
Feel free to ask if any further questions arise.
 
Regards,
Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster October 12, 2022

Hello, Ravi!

Hope you are having a great week.

Our team is wondering if you had some time to try the suggested approach of making the custom number formatting pop-up. Could you please let us know if it works for your case?

Feel free to ask if any further questions arise.

Best regards,
Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster October 19, 2022

Hello, Ravi!
 
Hope you are doing well.
 
Just checking in to ask if the approach of making custom number formatting pop-up works for your case.
 
Feel free to contact us in case of any other questions.
 
Best regards,
Solomiia

Please login or Register to Submit Answer