Bug Report T294352
Visible to All Users

GridControl - Nullable DateTime cell format is "General" instead of "Date" during export to XLSX

created 9 years ago

Hello.

I have an issue with the Winforms GridControl in DevExpress 15.1, when exporting a grid to an XLSX spreadsheet.

When exported, cells that originated from Nullable DateTime properties are set to a "General" format in Excel, instead of "Date", and thus appear as a number, not a date.

In DX 14.2 , they were correctly exported using a Date format.

I've attached a sample VS 2013 solution with two projects - one using DX 14.2, and one upgraded to 15.1 - they are otherwise identical.
Also included in the zip are the two corresponding exported xlsx files.

Click the export button in each program, and note the difference in the exported "Nullable Date Time" column.

If relevant, my PC locale is United Kingdom.

Am I doing something wrong?
Is this change intentional?
Can you recommend a workaround?

Thanks.

Comments (1)
Nadezhda (DevExpress Support) 9 years ago

    Hello Martin,

    Thanks for your project. I have reproduced this behavior. I have forwarded this ticket to our R&D team. We will research and update it as soon as we obtain any additional information.

    Answers approved by DevExpress Support

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

      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.