☝️Small business or a startup? See if you qualify for our special offer.
+

Error exporting to Excel when using report filters in Flat view with showHierarchyCaptions: false

Answered
Jeffersom Marcel asked on August 12, 2025

We're experiencing export failures when calling exportTo('excel') under specific conditions:

  1. Flat grid view (type: 'flat')

  2. showHierarchyCaptions: false

  3. 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!

 

1 answer

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster August 14, 2025

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

Please login or Register to Submit Answer