Ticket T335851
Visible to All Users

Date is randomly imported in the US or French date format

created 9 years ago

[DevExpress Support Team: CLONED FROM T335319: CellValue.IsDatetime always false]
Context :  Office 2007 in french


Problem 2
=======
With worksheet.Import, import a DataTable with a datetime will randomly put this date in US format or in correct culture language (french here) specified in workbook and in thread…

Comments (2)
AR AR
Alexandre Richonnier 9 years ago

    Context: French windows 7 x64 computer.
    Excel 2007 x32 French.
    the linked zip doesn't show the problem… to reduce it, you need to create some dummy data with a date column and import it in a workbook with worksheet.Import .
    the problem occurs very randomly.

    DevExpress Support Team 9 years ago

      Hello,

      Thank you for your clarification. I have modified the project you provided but could not replicate the behavior you described on my side. Would you please check the attached project? Are dates generated in the same manner in your project? In which format are dates stored in a data source in your case? Please modify the attached project to make it closer to your scenario. It would be helpful if you also provide us with test data. Your time and cooperation are greatly appreciated.

      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.