How to programmatically open format cells popup

posted on April 2nd, 2020

Closed

Massimo asked on April 2, 2020

Hi,
I'm trying to figure out how to programmatically open the format cells popup as I do with with the Calculate value editor using the "openCalculatedValueEditor" api.
Is there any way to do it or do I need an api that currently does not exists? In this second case could you please add this request to your backlog for future releases?

Thanks in advance.
Massimo Vecchio
sedApta s.r.l

1 answer

Public

Illia Yatsyshyn ⋅ Flexmonster ⋅ April 2, 2020

Hello, Massimo,

Thank you for contacting us.

Our team would like to explain that the pop-up allowing to control formatting is a part of the Toolbar. In contrast, the calculated value editor is an in-built Flexmonster feature and can be accessed using the mentioned openCalculatedValueEditor API.

Therefore, in order to use methods (in your case, the method responsible for the opening of an appropriate pop-up) from the flexmonster.toolbar.js, the Toolbar Object can be used.

The following code snippet demonstrates the way to open the number formatting pop-up programmatically:

flexmonster.toolbar.formatCellsHandler();

You are welcome to see an example we have prepared for you demonstrating the described approach.

Please note that the Toolbar has to be enabled in order to use such a workaround. In case you do not use the Toolbar, it can be hidden using the following CSS rule:

#fm-toolbar-wrapper {
  height: 0px !important;
}

We hope it helps.
Do not hesitate to contact us in case of additional questions.

Best regards,
Illia

This question is now closed