BuyLog In
Bug Report T714006
Visible to All Users

Export to XLS or XLSX - The cxExportPivotGridDataToExcel procedure does not export data field headers if no column fields are displayed

created 6 years ago (modified 6 years ago)

[DevExpress Support Team: CLONED FROM T709860: Export to XLS or XLSX - The cxExportPivotGridDataToExcel procedure exports summaries instead of summary variations for data fields whose SummaryVariation property setting differs from svNone]
Hi Paulo,

unfortunately our test center found a bug that occurs if you have 0 values and a additional summary variation field with SummaryVariation svPercentOfRow.

You find the adjusted datasource and the slighlty changed Unit11.pas which adds the second summary variation field . If you export the data to excel after recompiling the project, it seems that the values of the first row are "hidden" / "overwritten" by the column names in excel.

Sorry to bother you once again but this behavior did not appear with my initial test datasource.

Thanks in advance and kind regards
Alex

[Attachment removed by DevExpress]

Comments (1)
AU AU
Alexander Ulbricht 6 years ago

    Hi Paulo,

    out test center just confirmed that everything works fine now.

    Thanks alot and kind regards
    Alexander

    Sign in to comment on this post

    Answers approved by DevExpress Support

    created 6 years ago (modified 6 years ago)

    We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.

    Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.

      Sign in to comment on this post

      Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

      Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.