1. Home
  2. Forum
  3. WPF
  4. Pivot elements are not active in exported Excel if FieldCaption differs from FieldHeader

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

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:

7 Replies 1 reply marked as answer
VR Vijayalakshmi Roopkumar Syncfusion Team September 16, 2020 01:07 PM UTC

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


HA Harald September 30, 2020 10:45 AM UTC

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

VR Vijayalakshmi Roopkumar Syncfusion Team October 1, 2020 07:13 AM UTC

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: 
 
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 


HA Harald October 1, 2020 09:48 AM UTC

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

SG Saravanan Ganesan Syncfusion Team October 2, 2020 01:12 PM UTC

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


VR Vijayalakshmi Roopkumar Syncfusion Team October 6, 2020 12:32 PM UTC

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 20th Oct, 2020. You can track the status of this defect using the following feedback link: 
 
 
Please let us know if you have any other concerns. 
 
Regards, 
Vijayalakshmi VR 


TB Thirupathi Bala Krishnan Syncfusion Team December 21, 2020 01:45 PM UTC

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


Marked as answer
Loader.
Up arrow icon