We're experiencing export failures when calling exportTo('excel') under specific conditions:
Flat grid view (type: 'flat')
showHierarchyCaptions: false
Active reportFilters in the slice
Error: Cannot read properties of null (reading 'element')
JSFiddle to reproduce: https://jsfiddle.net/wb9ezuy4/2/
We tried workarounds to fix it and these worked:
Set showHierarchyCaptions: true
Remove reportFilters before export
Use 'compact' or 'classic' view instead of 'flat'
But ideally, flexmonster should handle these user configuration changes, as we provide users the flexibility to customize their data visualization as needed. We've observed that according to the documentation, Flexmonster converts reportFilters into empty columns when in flat view, which appears to be the root cause of this export error. We'd like to know if this should be considered a feature enhancement or a bug fix, as it limits user flexibility in combining these otherwise valid configuration options. Are there any other recommended approaches or configurations we should consider to avoid this issue?
Thanks for your help!
Hello Jeffersom!
Thank you for reporting the issue.
Our team will take a look at the described behavior and provide a fix with our minor release with the ETA September 1st. We will notify you about the release.
Please let us know if any questions arise.
Kind regards,
Nadia
Hello, Jeffersom,
We are glad to inform you that the issue with exporting to Excel when the showHierarchyCaptions
option is set to false was fixed. This is provided in the 2.9.111 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-111/
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/
Please let us know if the fix works.
Best regards,
Maksym
Hello Jeffersom!
Hope you are having a great week.
We were wondering if you had a chance to check the updated version. Could you please confirm if it works for you?
Looking forward to hearing from you.
Kind regards,
Nadia
Hello Nadia!
Thanks! this worked