asked on November 28, 2023
Dear Flex Monster Support Team,
We are using flexmonster.js v2.9.7 as our core data visualisation library for our clients. We have a SaaS license.
We have a compelling requirement from our customers to view and export the data with formatting. (Bold, Colour, Indentation, etc). Formatting is based on our business rules which cannot be done through the options currently supported in the conditional formatting. So, we have used customizeCell(https://www.flexmonster.com/api/customizecell/) function to apply the required CSS to view the formatted output on the browser. However, when the user downloads the reports using Export to Excel, these formatting are not getting exported.
We have created an example of how we are using and given the same below.
https://jsfiddle.net/f703keL8/
Can you please review and help us if there is a way for us to export the data from flexview with the formatting css that we have applied through customizecell function.
Regards,
Karthik
⋅ November 28, 2023
Hello, Karthik!
Thank you for reaching out to us.
Kindly note that customizations made with customizeCell() API call can only be exported as images.
Hope it helps. Feel free to contact us in case of any other questions.
Regards,
Solomiia
⋅ November 29, 2023
Thank You Solomiia for the response.
Our customers want to export and use the data for further data analysis. So, we want the formatted output in xlsx and not in image. Is there any other way we can do this or you can talk to your product team and check if its part of the roadmap.?
Regards,
⋅ November 29, 2023
Hello, Karthik!
Thank you for your response.
Kindly note that exporting the customizations made with customizeCell API call to Excel is unavailable mainly because it will reflect poorly on performance. customizeCell() applies styles only to the visible members on the grid, while for exporting the whole grid is rendered. Therefore, applying customizeCell() for every cell in a large datasets can become a significant drawback.
However, our team wants to take into account your desired customizations while considering the formatting improvements. Could you please provide us with more details about your use case and the customizations you want to make?
Looking forward to hearing from you.
Kind regards,
Solomiia
⋅ November 29, 2023
Thank You Solomiia for liason-ing with the product team.
We are exporting data to Flexview from our reporting engine. Some of the cells that we have identified based on business classification needs to be formatted to different colour, bold text, Cell BG colour. We are currently achieving this through applying CSS in the customizecell function which works perfectly in the UI.
However these formatting is not reflecting when we do Export to Excel. We will need the same formatting options like text colour, Cell BG colour, Bold/Italics Styling.
If need be, we can schedule a Zoom call and we can take you over our requirement.
Regards,
⋅ December 1, 2023
Hello, Karthik!
Thank you for the provided details.
Could you please also specify the conditions to which mentioned customizations should be applied? For example, are these rows highlighted in bold depending on the row total value, the row member name, the level of nesting, etc?
Looking forward to hearing from you.
Kind regards,
Solomiia
⋅ December 12, 2023
Hello, Karthik!
Hope you are doing well.
Just checking in to ask if you could specify the logic by which the mentioned customizations should be applied.
Looking forward to hearing your feedback.
Kind regards,
Solomiia
