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

Can we convert all columns to upper case while exporting?

Answered
Abhilash asked on April 13, 2021

Hi,
Column names in flexmonster are displayed as all uppercase. But when it is exported to excel it doesn’t retain that all uppercase and just displays how it’s written in json. Can we set that all columns to uppercase while exporting to excel as well?

6 answers

Public
Milena Pechura Milena Pechura Flexmonster April 15, 2021

Hi, Abhilash,
 
Apologies for the late response.
 
We would like to confirm that there is a solution for this case.
 
Please specify caption as an uppercase text in the mapping object of your report.
Note that every field of your dataset should be defined in the mapping. However, the uppercase caption has to be set only for the fields that the user expects to see in the rows, columns, or report filters.
Here is the example: https://jsfiddle.net/flexmonster/p5sobLyf/.
 
Let us know if it works for you.
 
Best regards,
Milena

Public
Abhilash April 16, 2021

Hi, Thanks. I already have a caption defined in my reports which is normal casing like “Country” that’s the reason when it’s exported it’s showing as “Country”. So it’s hard to go back to all the report formats in database and update them. Wondering if there is any work around from CSS side or UI side?

Public
Milena Pechura Milena Pechura Flexmonster April 19, 2021

Hello, Abhilash,
 
Thank you for further explanations about your case.
 
Currently, the hierarchy name is exported to Excel as it is specified in the report (either as it is defined in a uniqueName or a caption). The uppercase style was added to Flexmonster via CSS, but this style is not exported with a grid.
 
Still, with the help of CSS, you can change the hierarchies’ names on the grid to a capitalized text instead of uppercase.
If the main point of your request is consistency, this approach could help.
 
Hope our answer was useful!
 
Kind regards,
Milena

Public
Abhilash April 22, 2021

thanks

Public
Milena Pechura Milena Pechura Flexmonster May 11, 2021

Hi, Abhilash,
 
How are you?
 
We were wondering whether our response helped.
Was the suggested approach useful?
 
Our team will be glad to hear your feedback.
 
Best regards,
Milena

Public
Milena Pechura Milena Pechura Flexmonster May 27, 2021

Hello, Abhilash,
 
Hope you are doing well!
 
Could you please let us know whether our response was helpful?
Is the suggested approach suitable for your case?
 
Looking forward to hearing from you.
 
Kind regards,
Milena

Please login or Register to Submit Answer