FlexmonsterPivotTable-v2.9.0 Excel export problems

posted on June 14th, 2021

Answered

massimo besozzi asked on June 14, 2021

Hi, I have switched to the FlexmonsterPivotTable-v2.9.0 version and in the new version if I export a report in excel it no longer shows in the file the indication of what has been selected as the report filter. We have a series of exports saved in json and then reused by other systems, changing the output the readers after the export no longer work.
It would be urgent.
Thanks in advance.

8 answers

Public

Vera Didenko ⋅ Flexmonster ⋅ June 15, 2021

Hello, Massimo,
Thank you for writing to us.
To show the selected filters in the Excel export, please enable the showFilters export option:

pivot.exportTo("excel", {
   showFilters: true
});

Also, you can enable the showFilters option by customizing the Toolbar. We have prepared a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/on5furjd/.
Please let us know if this works. Looking forward to your response.
Kind regards, Vera

Public

massimo besozzi ⋅ June 15, 2021

Hi Vera, If i use your code and for category I select only one category in the excel file I have in filter also filtered category. I prepare for you that example. In filter I needs only Business type https://jsfiddle.net/vrgw46te/2/

Public

Vera Didenko ⋅ Flexmonster ⋅ June 15, 2021

Hello, Massimo,
Thank you for your response.
You are right; the showFilters property is responsible for showing all filters in the export. Looking deeper, we found that reportFilters stopped being shown by default in the Excel export starting from v2.8.20.

Our team will look into this issue, and we will provide the fix with the ETA 12th of July.
Please let us know if this would work fine for you.
Kind regards, Vera

Public

massimo besozzi ⋅ June 15, 2021

Good morning Vera, if you succeeded before it would be better for me, otherwise I will tell the users to proceed with the insertion of the filters on the finished excel report.
Thanks and I look forward to yours.

Public

Vera Didenko ⋅ Flexmonster ⋅ June 16, 2021

Hello, Massimo,
Thank you for your reply.
Our team has prioritized your request, and we will provide the fix with the ETA 29th of June.
Please let us know if this would work for you.
Kind regards, Vera

Public

massimo besozzi ⋅ June 16, 2021

Hello Vera, OK thanks.

Public

Vera Didenko ⋅ Flexmonster ⋅ June 30, 2021

Hello, Massimo,
We are glad to announce that the issue with report filters not added to Excel was fixed.
This is provided in the 2.9.2 version of Flexmonster: https://www.flexmonster.com/release-notes/.
You are welcome to update the component. Here is our updating to the latest version tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
Please let us know if the fix works fine for you.
Kind regards, Vera

Public

Vera Didenko ⋅ Flexmonster ⋅ July 6, 2021

Hello, Massimo,
How are you?
Just checking in to ask if you've had a chance to try out the latest fix. Does everything work fine for you?
Looking forward to your feedback.
Kind regards, Vera

FlexmonsterPivotTable-v2.9.0 Excel export problems

8 answers

Please login or Register to Submit Answer