Pivot elements are not active in exported Excel if FieldCaption differs from FieldHeader

[Harald]

I defined pivot items having a FieldCaption that differs from FieldHeader. E.g.:

<syncfusion:PivotItem FieldMappingName="Country" FieldCaption="CountryCap" FieldHeader="CountryHeader" TotalHeader="Total"/>

If I use the Excel export function this item will be added to the exported pivot table in the Excel file, but it is not selected there. It can be manually selected in the Excel file and then it will be displayed, so actually nothing is lost. 

But if it's a bigger pivot table where all pivot items are having different FieldCaption compared to FieldHeader, the exported pivot table is empty first and I have to select all items manually which can be quite some work.

I used this test project from another thread where I could reproduce this issue just by adding  FieldCaption with a value differing from FieldHeader:

https://www.syncfusion.com/downloads/support/forum/153964/ze/Pivot-1407061021.zip  

[Vijayalakshmi Roopkumar]

Hi  Harald, 

 

Thank you for your update. 

 

Query :  But if it's a bigger pivot table where all pivot items are having different FieldCaption compared to FieldHeader, the exported pivot table is empty first and I have to select all items manually which can be quite some work. 

 

We have checked the reported problem that exported pivot table is not automatically selected with PivotGrid on setting the different fieldcaption compared to fieldheader. But we are unable to reproduce this problem at our end. Please find the modified sample and also taken the video for the same 

 

Sample: https://www.syncfusion.com/downloads/support/forum/157877/ze/SampleModified562976692 

 

 

 

Exported Excel : https://www.syncfusion.com/downloads/support/forum/157877/ze/Sampleheaderdifferent-493040053 

 

So please check this sample, video and let us know whether our replication steps is same as yours. If not, kindly provide us the video shows your exact requirement and also provide your currently using syncfusion product version, so that we can able to proceed further on this. 

 

Regards, 

Vijayalakshmi VR 

[Harald]

Hi!

When I'm using the provided sample without changing anything in the code the result is the same as described in my original message. That means the exported excel file looks different to the one attached to your last posting.

Also I couldn't find the mentioned video there, is this maybe missing in your post? But I guess there is not so much that can go wrong using that function :)

I'm using version 18.1460.0.36

[Vijayalakshmi Roopkumar]

Hi  Harald,  

 

Thanks for the update.

We have checked the reported query “Pivot fields are not added in the excel file and Pivot table becomes empty” in your reported version 18.1.0.36. But we are unable to reproduce the reported issue in our end. As per the current implementation in the pivot table, we have checked the FieldHeader value in the pivot item. If it is null, we have checked the FieldCaption. Both values are null, we have assigned the FieldMappingName value. 

 

Query	Response
If I use the Excel export function this item will be added to the exported pivot table in the Excel file, but it is not selected there. It can be manually selected in the Excel file and then it will be displayed, so actually nothing is lost.	Defined pivot fields are added in the pivot table properly. For example, I have added the Country in PivotColumns and Product in PivotRows. Both fields are selected in the exported excel file.
Also I couldn't find the mentioned video there, is this maybe missing in your post?	Yes. We have missed to include the video in the previous update.

Please refer the following screenshot for your reference.

Our pivot grid 

 

 

Exported PivotGrid 

 

Also, please refer the attached videos from the following location: 

 

https://www.syncfusion.com/downloads/support/forum/157877/7z/Harald_Export1739515332  

Could you please check the video and let us know whether our replication steps is same as yours. If not, kindly provide us the video shows your exact requirement, so that we can able to proceed further on this. 

Regards,
Vijayalakshmi VR 

[Harald]

Hi,

thanks for providing the video. 

I also attached a video and as you can see the steps and the source are exactly the same, but the result is different.

Could maybe the Excel version cause the difference? We are using Excel 365 Version 2007 (Build 13029.30344)

Thanks, Harald

Attachment: excel_export_20199852.7z

[Saravanan Ganesan]

Hi Anthony,

Thanks for the update.

We are currently validating the reported issue with the provided information. So we will provide further details on the 6th of October 2020.

We appreciate your patience until then.

Regards,
Saravanan

[Vijayalakshmi Roopkumar]

Hi Anthony 

 

Thank you for your patience. 

 

We have confirmed the reported behavior with PivotGrid is a defect and logged a report on this. The patch for this fix is estimated to be available on 20^th Oct, 2020. You can track the status of this defect using the following feedback link: 

 

Link:  https://www.syncfusion.com/feedback/18492/pivot-field-values-are-not-exported-in-the-pivottable 

 

Please let us know if you have any other concerns. 

 

Regards, 

Vijayalakshmi VR 

[Thirupathi Bala Krishnan]

Hi Harald, 

 

We are glad to announce that our Essential Studio 2020 Volume 4 release v18.4.0.30 with the fix of “Pivot field values are not exported in the PivotTable” is rolled out and is available for download under the following link. 

https://www.syncfusion.com/forums/160733/essential-studio-2020-volume-4-release-v18-4-0-30-is-available-for-download 

 

feedback link : https://www.syncfusion.com/feedback/18492/pivot-field-values-are-not-exported-in-the-pivottable  

 

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance. 

 

Regards,            

Thirupathi B.