☝️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

Re-Open
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!

 

4 answers

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

Public
Maksym Diachenko Maksym Diachenko Flexmonster September 3, 2025

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

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster 3 days ago

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

Public
Jeffersom Marcel 24 hours ago

Hello Nadia! 

Thanks! this worked

Please login or Register to Submit Answer