🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

How to deal with the prompt "tooManyColumnsInClassicMode"?

Answered
Zander asked on February 3, 2021

Hello,
 
I have a problem. I need to display a lot of column data in a table, and I want it to be the classic view. Can I cancel this reminder and not have it automatically converted to compact view?
 
Because my goal is to convert data to Excel.
 
Could you help me? Thank you.🥰

8 answers

Public
Zander February 3, 2021

Of course, I am fine on a large screen, but my users are not necessarily like this.😿

Public
Zander February 4, 2021

I have found the answer to the above question from here.
 
But I also want to keep the export button in the original toolbar.
 
So I want to know if I can rewrite the export method to excel? What if I can?
 
Thanks.

Public
Milena Pechura Milena Pechura Flexmonster February 4, 2021

Hi, Zander!
 
Thank you for posting to our forum.
 
Our team would like to confirm that it is possible to rewrite the handler for the “Export to Excel” tab from the Toolbar.
 
We have modified the example from the thread you sent to meet your requirements. Please have a look: https://jsfiddle.net/flexmonster/5xyrLvm8/.
The main idea is to add the beforetoolbarcreated event handler which is used to customize the Toolbar. Please see the following article for further info about this approach: https://www.flexmonster.com/doc/customizing-toolbar/.
 
Please let us know if it works for you and if any other questions arise.
Looking forward to your response.
 
Best regards,
Milena

Public
Zander February 5, 2021

Milena,
 
Thank you, it is very helpful🎉🎉.

Public
Zander April 25, 2021

Hello Milena,
 
For the above problem, my users have been using Flexmonster for a while and are getting tired of the format change bar.Especially if there are more than one table in a page, it will be positioned to the table in the prompt box, not the first table in the header.
 
So I recommend making it an optional property to control whether the user is prompted to change the presentation.

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster April 26, 2021

Hello,
 
Thank you for reaching out to us.
 
If we understand correctly, your requirement is to disable the alert appearing after automatic switching from classic to a compact form. If so, we suggest checking out the workaround you may find useful for your case: https://jsfiddle.net/flexmonster/csr5ex1y/. Try shrinking the frame narrow enough to cause switching in order to see the result. The alert will be closed before being rendered on the page.
 
Please let us know if it works for you.
In case the described functionality differs from the required one, please provide further details/illustrations of the desired behavior.
 
Our team is looking forward to hearing from you.
 
Kind regards,
Illia

Public
Zander April 27, 2021

Illia Yatsyshyn,
 
It works, thank you.
 
BTW, your hair style is very cool, I like it. 😉

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster April 27, 2021

Hello, Zander,
 
Thank you for your feedback!
Our team is happy to hear it works well for you.
 
Do not hesitate to contact us in case any other questions arise.
 
Best regards,
Illia

Please login or Register to Submit Answer